<?php 
	ini_set("display_errors","off");
	session_start();
	include("getID3-master/getid3/getid3.php");
	$dbcon=mysql_connect('35.187.110.251','root','5qA8kDtFkaNtd5vD');
	if (!$dbcon) {
		die('Could not connect: ' . mysql_error());
		}
	//mysql_select_db('routenote6_upgrade',$dbcon);
	mysql_select_db('rn22_upgrade',$dbcon);
	//5054316120063
	//5054316598398
	if( ! ini_get('date.timezone') )
	{
		date_default_timezone_set('GMT');
	}
	  /* $array_requests = '{"track":["test1"],"audio":["https://storage.googleapis.com/newtestrn/5059741102462/SENGKAN-KIMI_1613698949_1616050502_161614830043.mp3"],"fileName":["SENGKAN-KIMI_1613698949_1616050502_161614830043.mp3"],"notes":["notes1 is here"],"evidencefile":["http://104.155.118.229/rnapi/rn_evidence/License.pdf"],"upc":"5054316120063","uid":"38","track_cnt":"1","sample_rate":[""],"bits_per_sample":[""],"bits_per_sample":[""],"channelmode":[""],"bitrate":[""],"playtime_seconds":[""],"title":[""],"artist":[""],"album":[""],"track_number":[""],"file_mime":["image/mp3"],"filesize":[""],"bitrate_mode":[""],"evidencefileName":[""]}';   */
	 
	 /* $array_requests = '{"track":["track1","traack2"],"audio":["https://storage.googleapis.com/newtestrn/5057302950347/Ocean0View_1613268363_161614796738.mp3","https://storage.googleapis.com/newtestrn/5057302950347/SENGKAN-KIMI_1613698949_1616050502_161614830057.mp3"],"fileName":["Ocean0View_1613268363_161614796738.mp3","SENGKAN-KIMI_1613698949_1616050502_161614830057.mp3",null,null,null,null,null,null,null,null,null,null,null,null,null],"notes":"[null, null]","evidencefile":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"upc":"5057302950347","uid":"38","track_cnt":"2","evidencefileName":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]}'; */
	
	//$array_requests =  json_decode(file_get_contents('php://input'), true);
	$array_request =  json_decode(file_get_contents('php://input'), true);
	//$array_request = json_decode($array_requests,true);
	//print_r($array_request);
	/* $tracks = mysql_fetch_array(mysql_query("SELECT a.trackmod_report,a.nid,a.isrc,a.upc,a.vid,a.playtime,a.fid,CAST(am.value as unsigned int) as trackno FROM audio a join audio_metadata am on am.vid=a.vid join node n on n.nid=a.nid WHERE n.del_flag=0 and am.tag='track' and upc='5054316120063' group by am.vid order by trackno asc")); */
	//print_r($tracks);
	//exit;
	//include("getID3-master/getid3/getid3.php");
	$uid = $array_request['uid'];
	$track_cnt = $array_request['track_cnt'];
	$upcidd = $array_request['upc'];
	//$upcidd = $_REQUEST['upc'];
	$total = $array_request['track_cnt'];
	
	//$getID3 = new getID3;
	setlocale(LC_ALL, "en_US.utf8");	
	try {
	for($i=0;$i<=$total;$i++)
	{
		//$node_arr = $getID3->analyze('https://routenotetest.com/rn22/rn_audio/'.$array_request['fileName'][$i]);
		//print_r($node_arr);
		//exit;
		$extension = pathinfo(parse_url($array_request['audio'][$i], PHP_URL_PATH), PATHINFO_EXTENSION);
		$filename  = pathinfo(parse_url($array_request['audio'][$i], PHP_URL_PATH), PATHINFO_FILENAME);
		//$imagetoken = $filename.'_'.time().'.'.$extension;
		$imagetoken = $filename.'.'.$extension;
		$imagename= $imagetoken ;
		$source1 = '/var/www/html/rnapi/' . $imagetoken;
		if(copy($array_request['audio'][$i],$source1)){
		//	echo "File moved";
		}else{
			//echo "File not upload";
		}
		$getID3 = new getID3;
		$node_arr = $getID3->analyze('/var/www/html/rnapi/'.$imagetoken);
		//print_r($node_arr);
		//exit;
		$track_id1 = $array_request['track'][$i];
		$fileName  = $array_request['fileName'][$i];
		$uidd      = $uid;
		$str       = $array_request['audio'][$i];
		$str 	   = substr($str, strpos($str, 'form'));
		$t = time();
		$title = "";
		$node_id = "";
		$vidd = "";
		$fid = "";
	
		
		$node_arr->audio_tags = array();
		$sample_rate = $node_arr['audio']['sample_rate'];
		 $bits_per_sample = $node_arr['audio']['bits_per_sample'];
		 $filesize = $node_arr['filesize'];
		 $channel_mode = $node_arr['audio']['channelmode'];
		 $bitrate = $node_arr['audio']['bitrate'];
		 $bitrate_mode = $node_arr['audio']['bitrate_mode'];
		 $playtime = $node_arr['playtime_seconds'];
		 $play_count = 0;
		 $download_count = 0;
		 $downloadable = 1;
		//echo $title = $array_request['track'][$i];
		//echo "title";
		$title = $node_arr['tags_html']['id3v2']['title'][0];
		 $title_new = $node_arr['tags_html']['id3v2']['title'][0];
		$title_new = str_replace(",", "", $title_new);
		$title_new = str_replace('"', "", $title_new);
		$title_new = str_replace("'", "", $title_new);
		$title_new = stripslashes($title_new);
		$artist_new = $node_arr['tags']['id3v2']['artist'][0];
		$title = str_replace(",", "", $title);
		$title = str_replace('"', "", $title);
		$title = stripslashes($title);
		$artist_new = str_replace(",", "", $artist_new);
		$artist_new = str_replace('"', "", $artist_new);
		$artist_new = str_replace("'", "", $artist_new);
		$artist_new = stripslashes($artist_new);
		$artist = $node_arr['tags']['id3v2']['artist'][0];
		$album = $node_arr['tags']['id3v2']['album'][0];
	//	$track = $node_arr['tags']['id3v2']['track'][0];
		$trackno = $node_arr['tags']['id3v2']['track_number'][0];
		$filemime = $array_request['file_mime'][$i];
		$created_at = date("Y-m-d H:i:s");
		/* if($playtime !='')
		{ */
		if($filemime=='application/x-flac' || $filemime=='audio/x-flac'){
			$fileformat = "flac";
		}
		else{
			$fileformat = "mp3";
		}
		$SQL_QRY = "INSERT INTO luna_evidence (artwork_url, user_id, upc, evidence_notes, evidence_filename, evidence_filepath, is_active, created_at) VALUES ";
		$SQL_QRY .= '('.$array_request['audio'][$i].','.$uid.','.$upcidd.','.$array_request['notes'][$i].','.$array_request['evidencefile'][$i].','.$array_request['evidencefileName'][$i].',"1","'.$created_at.'")';
	
		$trac_titles="";
		$bitrate = round($bitrate);
		$title = $track_id1;
		$userid_reles = mysql_fetch_array(mysql_query("select uid from release_table where upc='".$upcidd."'"));
		$user_id = $userid_reles['uid'];
		$track_reles = mysql_fetch_array(mysql_query("select * from audio where upc='".$upcidd."'"));
		// and title_format='".$title."'
		//print_r($track_reles);
		//exit;
		$trac_titles = $track_reles['title_format'];
		$nid_titles = $track_reles['nid'];
		if($trac_titles==""){
		//echo "adasdasedf";
			$SQL_QRY1 = "INSERT INTO node (type, title, uid, status, created, changed, moderate,track_title,artist_name,del_flag) VALUES ";
			$SQL_QRY1 .= '("audio","'.$title.'","'.$user_id.'",0,"'.$t.'","'.$t.'",0,"'.$title_new.'","'.$artist_new.'","1")';
			mysql_query($SQL_QRY1);
			$last_nid = mysql_insert_id();
			$SQL_QRY2 = "INSERT INTO audio (nid, title_format, play_count, download_count, downloadable, file_format, sample_rate, channel_mode, bitrate, bitrate_mode, playtime, upc, isrc,file_mime,file_name,file_path,file_size,remote_size,fid,status) VALUES ";
			$SQL_QRY2 .= '('.$last_nid.',"'.$title.'","'.$play_count.'","'.$download_count.'","'.$downloadable.'","'.$fileformat.'","'.$sample_rate.'","'.$channel_mode.'","'.$bitrate.'","'.$bitrate_mode.'","'.$playtime.'","'.$upcidd.'","","","","","'.$filesize.'","","0",1)';
			mysql_query($SQL_QRY2);
			
			 $vidd = mysql_insert_id();
			//echo "vidd";
			$node_id=$last_nid;
			$SQL_QRY3 = "INSERT INTO node_revisions (nid, vid, uid, title, body, teaser, log, timestamp, format) VALUES ";
			$SQL_QRY3 .= '('.$node_id.','.$vidd.',"'.$user_id.'","'.$title.'"," "," "," ","'.$t.'",0)';
			mysql_query($SQL_QRY3);
			if($last_nid!=0 || $last_nid!='')
					mysql_query("UPDATE sequences SET id=".$last_nid." WHERE name='node_nid'");
					
					$SQL_QRY4 = "update node set vid='".$vidd."' where nid=".$node_id;
					mysql_query($SQL_QRY4);
					
					mysql_query("UPDATE  sequences SET id=".$vidd." WHERE name='node_revisions_vid'");
					
					$fidqry = mysql_fetch_array(mysql_query("select max(fid) as fid from files"));
					$fid = $fidqry['fid'];
					$renamefilename = $fileName;
					
					$query_d=mysql_query("select filename from files where fid='".$fid."'");
					$fpath = $query_d['filename'];
									
					if($fpath!=''){								
					$SQL_QRY5 = "update files set filename='".$renamefilename."',filepath='rn_audio/".$renamefilename."' where fid=".$fid;
					mysql_query($SQL_QRY5);
					}else{
					$SQL_QRY5 = "insert into files(uid,filename,filepath,filemime,filesize,status,timestamp) values";
					$SQL_QRY5 .= '("'.$user_id.'","'.$renamefilename.'","rn_audio/'.$renamefilename.'","'.$filemime.'","'.$filesize.'",0,"'.$t.'")';
					mysql_query($SQL_QRY5);	
					$fid = mysql_insert_id();				
					}
									
					$SQL_QRY6 = "update audio set fid='".$fid."' where nid=".$node_id;
					mysql_query($SQL_QRY6);
					
					
					//here we need to add
					$QRES = mysql_query("SELECT max(did) d FROM route_distributors ORDER BY did ASC");
					$cnt = mysql_fetch_array($QRES);
					
					$disarray= explode(",",$_SESSION['distributor']);
					$coundermod=$cnt['d'];
					//echo "coundermod";
					//echo $coundermod;
					for($k=3;$k<=$coundermod;$k++)
						{
							if(in_array($k,$disarray))
								$wid = 1;
							else
								$wid = 0;
							if($k==3 || $k==4 || $k==6 ||$k==7 ||$k==8 ||$k==9 ||$k==10 ||$k==11 ||$k==14 ||$k==17 ||$k==19 ||$k==26){
								$insertwid=0;
							}else{
								$insertwid=1;
							}
							$QRY =mysql_query("INSERT INTO route_audio_distribution (nid, did, wid, date) VALUES(".$node_id.",".$k.",".$insertwid.",'".$t."')");
						}
					$nidsetquery=mysql_query("select nid from audio where upc=$upcidd");
					$distributors=mysql_query("select distributors from album_distribution where upc=$upcidd");
					$distributors_ar=mysql_fetch_array($distributors);
					$distributors_value=$distributors_ar['distributors'];
					$distributors_arr=explode(',',$distributors_value);
					while($nidsetfetch=mysql_fetch_array($nidsetquery)){
							$nidset=$nidsetfetch['nid'];
							for($forcounter=0;$forcounter<count($distributors_arr);$forcounter++)
							{
								mysql_query("update route_audio_distribution set wid=1 where nid=$nidset and did =".$distributors_arr[$forcounter]);
							}
						}
						
					
					
				}
				else{
					//echo"HIii";
					$SQL_QRY1 = ("update node set title='".$title."',created='".$t."',changed='".$t."',track_title='".$title_new."',artist_name='".$artist_new."',del_flag='1' where nid='".$nid_titles."'");
					mysql_query($SQL_QRY1);
					
					$SQL_QRY2 = ("update audio set title_format='".$title."',play_count='".$play_count."',download_count='".$download_count."',downloadable='".$downloadable."',file_format='".$fileformat."',sample_rate='".$sample_rate."',channel_mode='".$channel_mode."',bitrate='".$bitrate."',bitrate_mode='".$bitrate_mode."',playtime='".$playtime."',file_size='".$filesize."' where nid='".$nid_titles."' and upc='".$upcidd."'");
					mysql_query($SQL_QRY2);
					
					$SQL_QRY3 = ("update node_revisions set title='".$title."',timestamp='".$t."' where nid='".$nid_titles."'");
					mysql_query($SQL_QRY3);
					$last_nid = $nid_titles;
					
					
					$fidqry = mysql_fetch_array(mysql_query("select fid from audio where nid='".$nid_titles."' and title_format='".$title."' and upc='".$upcidd."'"));
					$fid = $fidqry['fid'];
					$renamefilename = $fileName;
					
					$SQL_QRY5 = "update files set filename='".$renamefilename."',filepath='rn_audio/".$renamefilename."' where fid=".$fid;
					mysql_query($SQL_QRY5);
								
					$SQL_QRY6 = "update audio set fid='".$fid."' where nid=".$node_id;
					mysql_query($SQL_QRY6);
				}
				$uploaded_cloud_object_url = $array_request['audio'][$i];
				$SQL_QRY = "update files set filepath='".$uploaded_cloud_object_url."', status=1 where fid=".$fid;
				$SQL_QRY1 = "update audio set file_path='".$uploaded_cloud_object_url."' where fid=".$fid;
				mysql_query("update release_table set mp3status=1 WHERE upc='".$upcidd."'");
				mysql_query($SQL_QRY);
				mysql_query($SQL_QRY1);
				//unlink($origname);
				//ob_end_clean();
				
				//$cloud_up=mysql_query("select * from files where fid='".$fid."'");
				$cloud_up=mysql_query("select f.filepath,a.fid from files f join audio a on a.file_path=f.filepath where a.fid='".$fid."'");
				$cloud_check=mysql_fetch_array($cloud_up);
				$file_path = $cloud_check['filepath'];
				$file_path_fid = $cloud_check['fid'];
				
				/* }
				else
				{
					unlink($origname);
					echo $track_id1.",";
					echo "playtime_null";
					
				} */
		}
		 $data = array('msg'=>'success','data'=>'DB insertion successfully');
		 echo json_encode($data);
		}

		//catch exception
		catch(Exception $e) {
		  echo 'Message: ' .$e->getMessage();
		}
		
		 
  
 
	
	
?>