<?php
require_once(__DIR__ . '/../../../../vendor/autoload.php');

use Orchard\QueryWrapper;

class label_artist{

	private $artist_id;

	public function __construct($artist_id)
	{
		$this->artist_id = intval($artist_id);
	}

	public static function add_release_artists ($release_id, $type, $names, $wrapperObj)
	{
		$name_array = explode('|',$names);
		$count = 0;
		$sql = 'INSERT INTO release_artist (release_id, artist_name, role) VALUES';
        $data_params = [];

		if (count($name_array)) {
			foreach ($name_array as $name) {
				$name = trim($name);
				if ($name) {
					if ($count > 0){
						$sql .= ',';
					}
					$sql .= ' (?, ?, ?)';
					$data_params[] = $release_id;
					$data_params[] = $name;
					$data_params[] = $type;
					$count++;
				}
			}
		}
		if ($count) {
			$result = $wrapperObj->executeQuery($sql, $data_params, QueryWrapper::RETURN_AFFECTED_ROWS);
			if ($result === false) {
			    show_pdo_error($sql, $wrapperObj->getLastStatement());
			}
			return $result;
		}
		return 0;
	}

	public static function insert_artist_info($vendor_id, $uploaded_fields, $userId, $product_type = 1, $wrapperObj)
	{
		$sql = 'INSERT INTO artist_info (name, vendor_id, orchard_country, address_state, address_other_state, url,
 		        entered_by, artist_type, when_entered, last_updated) VALUES (?, ?, ?, ?, ?, ?, ?';
		$data_params = [];
		$data_params[] = $uploaded_fields['artist_name'];
		$data_params[] = $vendor_id;
		$data_params[] = $uploaded_fields['country_id'];
		$data_params[] = $uploaded_fields['state_id'];
		$data_params[] = $uploaded_fields['other_state'];
		$data_params[] = $uploaded_fields['url'];
		$data_params[] = $userId;
        switch($product_type){
            case 2:
                $artistType = 'tv_artist';
                break;
            case 3:
                 $artistType = 'film_collection';
                break;
            default:
                $artistType = 'artist';
                break;
        }
        $sql .= ', ?';
        $sql .= ', NOW(), NOW())';
		$data_params[] = $artistType;
		$result = $wrapperObj->executeQuery($sql, $data_params, QueryWrapper::RETURN_INSERT_ID);
		if ($result === false) {
		    show_pdo_error($sql, $wrapperObj->getLastStatement());
		}
		return $result;
	}

	public function update_artist_info($uploaded_fields, $wrapperObj)
	{
		$sql = 'UPDATE artist_info SET orchard_country = ?, address_state = ?, address_other_state = ?, url = ?,
 		        last_updated = NOW() WHERE artist_id = ?';
		$data_params = [];
		$data_params[] = $uploaded_fields['country_id'];
		$data_params[] = $uploaded_fields['state_id'];
		$data_params[] = $uploaded_fields['other_state'];
		$data_params[] = $uploaded_fields['url'];
		$data_params[] = $this->artist_id;
		if ($wrapperObj->executeQuery($sql, $data_params, QueryWrapper::RETURN_AFFECTED_ROWS) === false) {
		    show_pdo_error($sql, $wrapperObj->getLastStatement());
		}
	}


}

?>