");

				$notify_conn->query("insert into script_execution(script_name,execution_time,execution_log, alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "',
				'Existing Limit:$ebay_sheet','$alert_id')");

				$t_sheet_price = array_sum(array_column($total_sheet_array,4));
				echo("total limit---->".$t_sheet_price."
");

				$notify_conn->query("insert into script_execution(script_name,execution_time,execution_log, alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "',
				'Newly Calculated Limit:$t_sheet_price','$alert_id')");


			$c=0;
				if($t_sheet_price > 3000000)
				{
					$notify_conn->query("insert into script_execution(script_name,execution_time,execution_log, alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "',
					'New Limit greater than 3 million,sorting the array','$alert_id')");

					if(isset($total_sheet_array))
					$col = array_column( $total_sheet_array, 4 );
					array_multisort(array_column($total_sheet_array, 2 ), SORT_DESC,
									array_column($total_sheet_array, 4 ), SORT_DESC,
									$total_sheet_array);

					foreach($total_sheet_array as $lmt_rec)
					{

						if( !isset($lmt_rec[0]) )
						{
							continue;
						}

						$nm=strpos($lmt_rec[0], 'NM01');
						if($nm !== false)
						{
							$b2b=strpos($lmt_rec[0], 'b2b');
							if($b2b !== false)
							{
								continue;
							}
							$lmt_rec[0]=strtoupper($lmt_rec[0]);
							if($lmt_rec[2] == 3)
							{
								$total_sheet_array[$lmt_rec[0]][2] = 2;
								$total_sheet_array[$lmt_rec[0]][4] = 2*$lmt_rec[1];
							}else if($lmt_rec[2] == 2)
							{
								$total_sheet_array[$lmt_rec[0]][2] = 1;
								$total_sheet_array[$lmt_rec[0]][4] = 1*$lmt_rec[1];
							}else if($lmt_rec[2] == 1)
							{
								$total_sheet_array[$lmt_rec[0]][2] = 0;
								$total_sheet_array[$lmt_rec[0]][4] = 0;
							}
							$compare_qnty[]= $total_sheet_array[$lmt_rec[0]];


						}else{
							continue;
						}
						$c++;
						if($c>=1000)
						{
              echo "reaced c >1000";

							$c=0;
						$new_value = round(array_sum(array_column($total_sheet_array, 4)), 2);
            $notify_conn->query("insert into script_execution(script_name,execution_time,execution_log, alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "',
            'New limit:$new_value, after reducing inventory by 1 for each sku.','$alert_id')");

						if( $new_value < 2900000 )
						{

							foreach($compare_qnty as $c_qnty_rec)
							{
								if( $c_qnty_rec[2] === $sheet_array[$c_qnty_rec[0]][2])
								{
									if(isset($final_array[$c_qnty_rec[0]]))
									{
										unset($final_array[$c_qnty_rec[0]]);
									}

								}else{
									if(isset($final_array[$c_qnty_rec[0]]))
									{
										$final_array[$c_qnty_rec[0]]['*Quantity'] = $c_qnty_rec[2];
									}else{
										$final_array[$c_qnty_rec[0]]=array('*Action(SiteID=US|Country=US|Currency=USD|Version=941)' =>'Revise',
																			'ItemID'=> $c_qnty_rec[3],
																			'*Quantity'=> $c_qnty_rec[2]);
									}
								}

							}
							break;
						}
					}
					}
				}
		}
		echo "new limit-------".$new_value;

		if($EST == TRUE)
		{
		$file="upload_ec_". date("Y_m_d_h_i_s") . ".csv";
    $_SESSION['upload_file_name']=$file;

			$fp = fopen($file, 'w');
			$array_columns=array_keys($header[0]);
			fputcsv($fp, $array_columns);
			foreach ($final_array as $row) {
				fputcsv($fp, $row);
			}
			$notify_conn->query("insert into script_execution(script_name,execution_time,execution_log, alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "',
      'Upload.csv created with final_array values','$alert_id')");

			$p = getcwd();
			$foldername = $main_link_to_onedrive;
			//https://back.greatvaluestores.com/python_scripts/upload_file_onedrive.py
			$command1 = escapeshellcmd("python ../../../python_scripts/upload_file_onedrive.py $p $foldername $file");
			$output1 = shell_exec($command1);
			echo $output1;

			if(trim($output1) == 'done'){
					$notify_conn->query("insert into script_execution(script_name,execution_time,execution_log,alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "','Uploaded file in onedrive Successfully','$alert_id')");
			}else{
			$notify_conn->query("insert into script_execution(script_name,execution_time,execution_log,alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "','Unable to upload file in onedrive folder','$alert_id')");
			$q2 = "UPDATE alert_success_error_dashboard SET error_msg = 'Unable to upload file in onedrive', action = 'Issue' WHERE id = '$alert_id'";
			$succ_query = mysqli_query($notify_conn, $q2);
			}
      //uncomment
		include('sub_ec_upload_inv.php');
      if(file_exists("error_log"))
			unlink('error_log');

			// close the file
			fclose($fp);



		}else{
			echo "File not generated due to time zone";
			$notify_conn->query("insert into script_execution(script_name,execution_time,execution_log, alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "',
      'No file generated due to time zone.','$alert_id')");

		}

	}
	catch (Exception $E)
	{
		$msg=$E->getMessage();
		echo $msg;
		$notify_conn->query("insert into script_execution(script_name,execution_time,execution_log, alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "',
		'Exception Occured:$msg','$alert_id')");

	}

	// delete data in execution log
  $del_data = "Delete from script_execution WHERE DATEDIFF(CURRENT_DATE, execution_time) > 30 and script_name ='$script_name' ";
  $del = $notify_conn->query($del_data);
  if ($del)
   $notify_conn->query("insert into script_execution(script_name,execution_time,execution_log,alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "','Deleted data from log table above 30 days','$alert_id')");

   $foldertocheck = $main_link_to_onedrive;
$del_count=0;
   if ($foldertocheck != '')
   {
       //https://back.greatvaluestores.com/python_scripts/delete_file_onedrive_thirty.py
   		echo "python ../../../python_scripts/delete_file_onedrive_thirty.py $foldertocheck";
       $command1 = escapeshellcmd("python ../../../python_scripts/delete_file_onedrive_thirty.py $foldertocheck");
       $output1 = shell_exec($command1);
       if(trim($output1) == 'done'){
           $notify_conn->query("insert into script_execution(script_name,execution_time,execution_log,alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "','Deleted data from onedrive above 30 days','$alert_id')");
       }else{
       $notify_conn->query("insert into script_execution(script_name,execution_time,execution_log,alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "','Unable to delete onedrive files','$alert_id')");
       $q2 = "UPDATE alert_success_error_dashboard SET error_msg = 'Unable to delete file in onedrive', action = 'Issue' WHERE id = '$alert_id'";
       $succ_query = mysqli_query($notify_conn, $q2);
       $del_count++;
       }
   }

	 $link_to_onedrive = $foldername . '/' . $file;
   if($del_count==0){
   $q2 = "UPDATE alert_success_error_dashboard SET success_msg = 'Successfully generated csv file', action = 'No Action Needed', link_to_onedrive = '$link_to_onedrive', error_msg = '' WHERE id = '$alert_id'";
   $succ_query = mysqli_query($notify_conn, $q2);
 }else {
   $q2 = "UPDATE alert_success_error_dashboard SET  link_to_onedrive = '$link_to_onedrive'  WHERE id = '$alert_id'";
   $err_query = mysqli_query($notify_conn, $q2);
 }


unlink($file);

$sql_query="UPDATE gvs_scripts_execution_log  set closed_on=NOW() where  id='$last_id' ";
mysqli_query($reports_conn,$sql_query) ;

$notify_conn->query("insert into script_execution(script_name,execution_time,execution_log,alert_id) values('$script_name','" . date('Y-m-d H:i:s', time()) . "','Ebay EC inventory update script completed','$alert_id')");


?>