<?php
	require_once(__DIR__ . '/../../../../../vendor/autoload.php');

	use Orchard\Mysqli\QueryData;
	use Orchard\Mysqli\Wrapper as MysqliWrapper;
	$wrapperObj = new MysqliWrapper ($mysqli);
	$pdoWrapperObj = getPDOQueryWrapper();
	$criteria_counter = 0;
	$report_criteria = array();
		
	
	$labels = array();
	$start_period = quaterly_period::getPeriodFromID(1);
	$labels = array();
	$last_period = accounting::get_last_processed_quaterly_period($pdoWrapperObj);
	$mainarray= array();

	$get_labels = "SELECT v.vendor_id, v.company
					FROM vendor v
						INNER JOIN artist_info a ON a.vendor_id = v.vendor_id
						INNER JOIN releases r ON r.artist_id = a.artist_id
						INNER JOIN checkspaid cp ON cp.upc = r.upc
					WHERE v.status IN ('signed', 'deletions')  AND cp.paidfor_type IN ('phy_recoupe','dig_recoupe')
					GROUP BY v.vendor_id
					ORDER BY v.vendor_id";
	$get_labels_result = $pdoWrapperObj->executeQuery($get_labels, []);
	if ($get_labels_result === false) {
	    show_pdo_error($get_labels, $pdoWrapperObj->getLastStatement());
	}

	$acct = new accounting();	
	foreach ($get_labels_result as $labels_row) {
		$vendor_id = $labels_row["vendor_id"];
		$labels = array();
		$labels[$vendor_id]["company"] = $labels_row["company"];

		$current_label_total = 0;
		foreach ($get_labels_result as $labels_row) {
		    if ($current_label_total >= 30) {
		        break;
		    }

		    $vendor_id = $labels_row["vendor_id"];
		    $labels[$vendor_id]["company"] = $labels_row["company"];
		    $current_label_total++;
		}

		$l_act = new label_accounting($wrapperObj, array_keys($labels));
		$l_act->set_total_sales($last_period);
		$total_sales = $l_act->get_transformed_total_sales(true);
		
		foreach($labels as $vendor_id => $vendor_info) {
			$subarray = array();
			
			$recoup_fees = array();
			$dig_actual_net = array();
			$phy_actual_net = array();
			$recouped_amt = array();
			$checkspaid = array();
			$total_recoup_fees = 0;
			$total_checkspaid = 0;
			$total_earnings = 0;
			$total_recouped = 0;
			
			if(isset($total_sales[$vendor_id])){
				$quarters = array_keys($total_sales[$vendor_id]);
				if(sizeof($quarters) > 0 && is_array($quarters)) {
					sort($quarters);
					$qy = $quarters[0];
				}
				else 
					$qy = $last_period->getPeriodCode();
				foreach($total_sales[$vendor_id] as $qy=>$total_sale){
					$total_checkspaid += $total_sale->phy_sales->checkspaid;
					$total_checkspaid += $total_sale->dig_sales->checkspaid;
					
					$total_earnings += $total_sale->phy_sales->actual_net;
					$total_earnings += $total_sale->dig_sales->actual_net;
					
					$total_recoup_fees += $total_sale->phy_sales->recoup_fees;
					$total_recoup_fees += $total_sale->dig_sales->recoup_fees;

					$recoup_fees[$qy] = isset($recoup_fees[$qy])?$recoup_fees[$qy]:0;
					$recoup_fees[$qy] += $total_sale->phy_sales->recoup_fees + $total_sale->dig_sales->recoup_fees;
					
					$dig_actual_net[$qy] = isset($dig_actual_net[$qy])?$dig_actual_net[$qy]:0;
					$dig_actual_net[$qy] += $total_sale->dig_sales->actual_net;
					
					$phy_actual_net[$qy] = isset($phy_actual_net[$qy])?$phy_actual_net[$qy]:0;
					$phy_actual_net[$qy] += $total_sale->phy_sales->actual_net;
					
					$checkspaid[$qy] = isset($checkspaid[$qy])?$checkspaid[$qy]:0;
					$checkspaid[$qy] += $total_sale->phy_sales->checkspaid;
					$checkspaid[$qy] += $total_sale->dig_sales->checkspaid;

					$tmp_unrecouped = -$total_recoup_fees - $total_recouped;
					$tmp_applicable_earning = $total_earnings - $total_checkspaid - $total_recouped;
					if($tmp_unrecouped > 0 && $tmp_applicable_earning > 0) {
						if($tmp_applicable_earning > $tmp_unrecouped)
						{
							$tmp = $tmp_unrecouped;
						}
						else 
							$tmp = $tmp_applicable_earning;
							
						if($tmp > 0)
						{
							$recouped_amt[$qy] = $tmp;
							$total_recouped += $tmp;
						}
					}
				}
			} 
				
			$subarray = array("vendor_id"=>$vendor_id
							, "company" => $vendor_info["company"]
							, "recoup_fees" => $recoup_fees
							, "dig_actual_net"=>$dig_actual_net
							, "phy_actual_net"=>$phy_actual_net
							, "checkspaid" => $checkspaid
							, "recouped_amt" => $recouped_amt
						);
			$mainarray[] = $subarray;
		}
	}
	

	/*
	$order = ($sort_desc)?false:true;		
	if (count($mainarray)>0)
		if ( in_array($sort_by, array("recoup_fees", "unrecouped_fees", "vendor_id")))
			$mainarray = multisort($mainarray, $sort_by , $order, SORT_NUMERIC);
		else {
			$mainarray = multisort($mainarray, $sort_by , $order, SORT_REGULAR);
	}
	*/

	$report_data = '<table class="data">
			<tr>
				<th class="center" rowspan="2">Label ID</th>
				<th class="center" rowspan="2">Label</th>';
	$row1="";
	$row2="";
	$qy = $start_period->getPeriodCode();
	while($qy <= $last_period->getPeriodCode())
	{
		$row1 .= "<th class='center' colspan='5'>$qy</th>";
		$row2 .= "<th class='center'>Dig Final Net</th>
					<th class='center'>Phy Final Net</th>
					<th class='center'>Amount Paid</th>
					<th class='center'>Encoding</th>
					<th class='center'>Amt Recouped</th>	";
		$qy = QY_Add_Subtract($qy);
	}
	$report_data .= $row1 . '</tr>';
	$report_data .= $row2 . '</tr>';
	

	foreach ($mainarray as $value){	
		$row_class = ($row_class == '') ? 'alt' : ''; 
		//$total_recoup_fees += $value['recoup_fees'];
		//$total_unrecoup_fees += $value['unrecouped_fees'];
		$report_data .= '	<tr class="'.$row_class.'">
			<td align="right">'.$value["vendor_id"].'</td>
			<td class="left">'.(($view_links)?"<a href='/cont_mgmt/view_vendor.php?vendor_id={$value['vendor_id']}'>{$value["company"]}</a>":$value["company"]).'</td>';
		$qy = $start_period->getPeriodCode();
		while($qy <= $last_period->getPeriodCode()) {	
			$report_data .= '<td class="right">'.money_format('%.4n',$value['dig_actual_net'][$qy]).'</td>
						<td class="right">'.money_format('%.4n',$value['phy_actual_net'][$qy]).'</td>
						<td class="right">'.money_format('%.4n',$value['checkspaid'][$qy]).'</td>
						<td class="right">'.money_format('%.4n',$value['recoup_fees'][$qy]).'</td>
						<td class="right">'.money_format('%.4n',$value['recouped_amt'][$qy]).'</td>';
			$qy = QY_Add_Subtract($qy);
		}
		$report_data .= '</tr>';
	}
	$report_data .= '</tr>
			</table>';
?>