unset all variables

l0ve2hat3 · August 8, 2008

is it possible to unset all variables that are set?

without doing this:

unset($var1,$var2,$var3);

DarkWater · August 8, 2008

Might I ask why?

l0ve2hat3 · August 8, 2008

becuase i have to loop the same code 3 times and it will mess up the numbers if they do not get unset.

DarkWater · August 8, 2008

Use a different variable then? Post the code.

l0ve2hat3 · August 8, 2008

lol u want to see the code? yeah maybe u'll understand y

<?php
error_reporting(0);
ini_set(max_execution_time,999);


include("functions.php");


//check_posclient_login();

//declared Variables
$buy_back_text=$CONFIG[buy_back_text];
$gift_cert_text=$CONFIG[gift_cert_text];
$party_payment_text=$CONFIG[party_payment_text];
$cc_credit_text=$CONFIG[cc_credit_text];

$additional_discounts=$CONFIG[additional_discounts];
$additional_comps=$CONFIG[additional_comps];

$exceptions_reasons[1]=$CONFIG[exceptions_reasons][1];
$exceptions_reasons[2]=$CONFIG[exceptions_reasons][2];
$exceptions_reasons[3]=$CONFIG[exceptions_reasons][3];
$exceptions_reasons[4]=$CONFIG[exceptions_reasons][4];


//company name
$sql1='SELECT [Company_Info_1] FROM [setup]';
$template['company_name']=mssql_result(mssql_query($sql1),0,0);



//for($p=1;$p<=3;$p++{

////////////////
//START END TIME
$TIMEsql='SELECT TOP 100 * FROM [End_Of_Day] ORDER BY [EndDateTime] DESC';
$TIMEres=mssql_query($TIMEsql);
while($TIMErow=mssql_fetch_assoc($TIMEres)){
    $i++;
    if($i==1&&$_GET[index]=='')$_GET[index]=$TIMErow['Close_Out_Index'];
$template['select'].='<OPTION value="'.$TIMErow['Close_Out_Index'].'">'.$TIMErow['StartDateTime'].' - '.$TIMErow['EndDateTime'].'</OPTION>';
}

$TIMEsql="SELECT * FROM [End_Of_Day] WHERE [Close_Out_Index]='$_GET[index]'";
$TIMEres=mssql_query($TIMEsql);
$TIMErow=mssql_fetch_assoc($TIMEres);

$shift_start=$TIMErow['StartDateTime'];
$shift_end=$TIMErow['EndDateTime'];

$template['from_period']=$shift_start;
$template['to_period']=$shift_end;
$template['to_period_day']=date('l',strtotime($shift_end));
//END START END TIME
////////////////////


    $where='DateTime >= \''.$shift_start.'\' AND DateTime <= \''.$shift_end.'\'';


    //General Totals And Money Track
    $sql_numbers='SELECT * FROM [invoice_Totals] WHERE '.$where.' ORDER BY [invoice_Number] ASC';
    $res_numbers=mssql_query($sql_numbers)or die($sql_numbers."<br>".mssql_get_last_message().": $sql_numbers");

    while($row_numbers=mssql_fetch_assoc($res_numbers)){

    	//only do also this stuff if it's not voided
    	if($row_numbers['Status']!="V"){
    		//General Totals
    		$template['var13']+=$row_numbers['Total_Price'];
    		$template['var14']+=$row_numbers['Total_Tax1'] + $row_numbers['Total_Tax2'] + $row_numbers['Total_Tax3'];
    		$template['var15']+=$row_numbers['Grand_Total'];


            ////TESTING ONLY
            $row_numbers['Cashier_ID']=($row_numbers['Cashier_ID']=='')?'NO CASHIER ID ON INVOICE':$row_numbers['Cashier_ID'];
    //        $empTOTAL[$row_numbers[Cashier_ID]][Total_Price]+=$row_numbers['Total_Price'];
    //        $empTOTAL[$row_numbers[Cashier_ID]][CA_Amount]+=$row_numbers['CA_Amount'];
    //        $empTOTAL[$row_numbers[Cashier_ID]][Total_Tax]+=$row_numbers['Total_Tax1'] + $row_numbers['Total_Tax2'] + $row_numbers['Total_Tax3'];
    //        $empTOTAL[$row_numbers[Cashier_ID]][Grand_Total]+=$row_numbers['Grand_Total'];
    //        $empTOTAL[$row_numbers[Cashier_ID]][Cashier_ID]=$row_numbers['Cashier_ID'];
              $empTOTAL[$row_numbers[Cashier_ID]]+=$row_numbers['CA_Amount'];



    		//total checks
    		$template['var55']++;

    		//total guests
    		$template['var56']+=$row_numbers['Num_People_Party'];

            if($row_numbers['Acc_Balance_due']>0){
                $template['checks_outstanding_num']++;
                $template['checks_outstanding']+=$row_numbers['Acc_Balance_due'];
            }else{
                $template['checks_outstanding_num']+=0;
                $template['checks_outstanding']+=0;
            }



    		//Money Track - Cash
    		if($row_numbers['CA_Amount']>0){
    			$template['var16']++;
    			$template['var17']+=$row_numbers['CA_Amount'];
    		}

    		if($row_numbers['Payment_Method']=="CA"){
    			//Money Track - Applied Gratuity Part 1
    			if($row_numbers['Tip_Amount']>0){
    				$template['var21']++;
    				$template['var22']+=$row_numbers['Tip_Amount'];
    			}
    		}
    		if($row_numbers['Payment_Method']=="ST" || $row_numbers['Payment_Method']=="CC"){
    			//Money Track - CC Tips + Applied Gratuity
    			$sub_amount_sum=0;
    			$sql_sub_tip='SELECT * From [CC_Trans] WHERE [CRENumber] ='.$row_numbers['Invoice_Number'];
    			$sub_tip_res=mssql_query($sql_sub_tip);

    			while($sub_tip_row=mssql_fetch_assoc($sub_tip_res)){
    				//Money Track - CC Tips
    				if($sub_tip_row['TipAmount']>0){
    					$template['var19']++;
    					$template['var18']+=$sub_tip_row['TipAmount'];
    					//old applied grat
    					//$sub_tip_sum+=$sub_tip_row['TipAmount'];
    				}

    				//new applied grat
    				$sub_amount_sum+=$sub_tip_row['Amount'];

    				//Payment Breakdown For CC Array Fill
    				$cc_breakdown[$sub_tip_row['Type']]['count']++;
    				$cc_breakdown[$sub_tip_row['Type']]['sum']+=$sub_tip_row['TipAmount']+$sub_tip_row['Amount'];
    				$cc_breakdown['ALL']['count']++;
    				$cc_breakdown['ALL']['sum']+=$sub_tip_row['TipAmount']+$sub_tip_row['Amount'];

    				//Credit Cards Itemized
    				if($count_cc++%2==1) $bgcolor_cc='white';
    				else $bgcolor_cc='lightgray';
    				$template['cc_itemized'].='<TR style="background-color:'.$bgcolor_cc.'"><TD align=center>'.$sub_tip_row['Type'].'</TD><TD align=center>'.substr($sub_tip_row['Number'],-4).'</TD><TD align=center>$'.number_format($sub_tip_row['Amount'],2,'.','').'</TD><TD align=center>$'.number_format($sub_tip_row['TipAmount'],2,'.','').'</TD><TD align=center>$'.number_format($sub_tip_row['TipAmount']+$sub_tip_row['Amount'],2,'.','').'</TD><TD align=center>'.$row_numbers['Invoice_Number'].'</TD></TR>';
    			}

    			//Money Track - Applied Gratuity Part 2

    			//old applied grat
    			//$sub_applied=$row_numbers['Tip_Amount']-$sub_tip_sum;
    			//new applied grat
    			$sub_applied=$sub_amount_sum-($row_numbers['Grand_Total']-$row_numbers['Amt_Tendered']+$row_numbers['Amt_Change']);
    			if($sub_applied>0){
    				$template['var21']++;
    				$template['var22']+=$sub_applied;
    			}

    		}
    		if($row_numbers['Payment_Method']=="ST" || $row_numbers['Payment_Method']=="CH"){
    			//Payment Breakdown For Gift Certificates
    			$sql_sub_gc='SELECT SUM([Amount]) AS [sum], COUNT([Amount]) AS [count] From [CH_Trans] WHERE [Trans_Number] ='.$row_numbers['Invoice_Number'];
    			$sub_gc_row=mssql_fetch_assoc(mssql_query($sql_sub_gc));
    			$template['var36']+=$sub_gc_row['count'];
    			$template['var37']+=$sub_gc_row['sum'];
    		}

    		//Invoice Exceptions
    		$sql_exceptions='SELECT * FROM [invoice_Exceptions] LEFT JOIN [inventory] ON [invoice_Exceptions].[itemNum]=[inventory].[itemNum] WHERE [invoice_Number] ='.$row_numbers['Invoice_Number'];
    		$exceptions_res=mssql_query($sql_exceptions);
    		while($exceptions_row=mssql_fetch_assoc($exceptions_res)){
    			if($exceptions_row['Amount']>0){
    				if($exceptions_row['Exception_Type']==2 && $exceptions_row['Reason_Code']==$buy_back_text){
    					$exceptions_row['Exception_Type']=4;
    				}
    				$exceptions_breakdown[$exceptions_row['Exception_Type']]['count']++;
    				$exceptions_breakdown[$exceptions_row['Exception_Type']]['sum']+=$exceptions_row['Amount'];
    				$exceptions_row['ItemName']=substr($exceptions_row['ItemName'],0,20);
    				$exceptions_row['Reason_Code']=substr($exceptions_row['Reason_Code'],0,20);
    				$exceptions_row['Reason_Code']=substr($exceptions_row['Reason_Code'],0,20);
    				if($exceptions_row['Exception_Type']==3){
    					$row_discount=($exceptions_row['Amount']/$exceptions_row['Price'])*100;
    					$discount_disp=' ('.$row_discount.'%)';
    				}
    				if($count_exceptions++%2==1) $bgcolor_exceptions='white';
    				else $bgcolor_exceptions='lightgray';
    				$template['exceptions_itemized'].='<TR style="background-color:'.$bgcolor_exceptions.'"><TD align=center>'.$exceptions_reasons[$exceptions_row['Exception_Type']].'</TD><TD align=center>'.$exceptions_row['ItemName'].'</TD><TD align=center>$'.number_format($exceptions_row['Amount'],2,'.','').' '.$discount_disp.'</TD><TD align=center>'.$exceptions_row['Reason_Code'].'</TD><TD align=center>'.$exceptions_row['Invoice_Number'].'</TD></TR>';
    			}
    		}

    		//additional discounts
    		$additional_discounts_string='';
    		foreach($additional_discounts as $additional_discount){
    			$additional_discounts_string.='OR [itemNum] = \''.$additional_discount.'\'';
    		}
    		$additional_discounts_string='('.substr($additional_discounts_string,3).') AND';
    		$sql_additional_discounts='SELECT * FROM [invoice_Itemized] WHERE '.$additional_discounts_string.' [invoice_Number] ='.$row_numbers['Invoice_Number'];
    		$additional_discounts_res=mssql_query($sql_additional_discounts);
    		while($additional_discounts_row=mssql_fetch_assoc($additional_discounts_res)){
    			$additional_discounts_row['PricePer']=abs($additional_discounts_row['PricePer']);
    			$template['var49']++;
    			$template['var50']+=$additional_discounts_row['PricePer'];
    			if($count_exceptions++%2==1) $bgcolor_exceptions='white';
    			else $bgcolor_exceptions='lightgray';
    			$template['exceptions_itemized'].='<TR style="background-color:'.$bgcolor_exceptions.'"><TD align=center>Discount</TD><TD align=center>Entire Check</TD><TD align=center>$'.number_format($additional_discounts_row['PricePer'],2,'.','').'</TD><TD align=center>'.$additional_discounts_row['ItemNum'].'</TD><TD align=center>'.$additional_discounts_row['Invoice_Number'].'</TD></TR>';
    		}

    		//additional comps
    		$additional_comps_string='';
    		foreach($additional_comps as $additional_comp){
    			$additional_comps_string.='OR [itemNum] = \''.$additional_comp.'\'';
    		}
    		$additional_comps_string='('.substr($additional_comps_string,3).') AND';
    		$sql_additional_comps='SELECT * FROM [invoice_Itemized] WHERE '.$additional_comps_string.' [invoice_Number] ='.$row_numbers['Invoice_Number'];
    		$additional_comps_res=mssql_query($sql_additional_comps);
    		while($additional_comps_row=mssql_fetch_assoc($additional_comps_res)){
    			$additional_comps_row['PricePer']=abs($additional_comps_row['PricePer']);
    			$template['var47']++;
    			$template['var48']+=$additional_comps_row['PricePer'];
    			if($count_exceptions++%2==1) $bgcolor_exceptions='white';
    			else $bgcolor_exceptions='lightgray';
    			$template['exceptions_itemized'].='<TR style="background-color:'.$bgcolor_exceptions.'"><TD align=center>Comp</TD><TD align=center>Entire Check</TD><TD align=center>$'.number_format($additional_comps_row['PricePer'],2,'.','').'</TD><TD align=center>'.$additional_comps_row['ItemNum'].'</TD><TD align=center>'.$additional_comps_row['Invoice_Number'].'</TD></TR>';
    		}

    		//Gift Card Payments
    		$sql_gc_sales='SELECT * FROM [Gift_Card_Trans] WHERE [TransType]=1 AND [invoice_Number] ='.$row_numbers['Invoice_Number'];
    		$gc_sales_res=mssql_query($sql_gc_sales);
    		while($gc_sales_row=mssql_fetch_assoc($gc_sales_res)){
    			$template['var38']++;
    			$template['var39']+=(-1*$gc_sales_row['Amt']);
    		}

    		//Gift Certificates Sold!
    		$sql_gcert_sales1='SELECT SUM([Quantity]*[PricePer]) as [sum],COUNT(*) as [count] FROM [invoice_Itemized] WHERE [itemNum] = \''.$gift_cert_text.'\' AND [invoice_Number] ='.$row_numbers['Invoice_Number'];
    		$gcert_sales_row1=mssql_fetch_assoc(mssql_query($sql_gcert_sales1));
    		$template['var53']+=$gcert_sales_row1['count'];
    		$template['var54']+=$gcert_sales_row1['sum'];

    		//Party Payments!
    		$sql_gcert_sales2='SELECT SUM([Quantity]*[PricePer]) as [sum],COUNT(*) as [count] FROM [invoice_Itemized] WHERE [itemNum] = \''.$cc_credit_text.'\' AND [invoice_Number] ='.$row_numbers['Invoice_Number'];
    		$gcert_sales_row2=mssql_fetch_assoc(mssql_query($sql_gcert_sales2));
    		$template['var95']+=$gcert_sales_row2['count'];
    		$template['var96']+=$gcert_sales_row2['sum'];

    		//Credit Card Credits!
    		$sql_gcert_sales3='SELECT SUM([Quantity]*[PricePer]) as [sum],COUNT(*) as [count] FROM [invoice_Itemized] WHERE [itemNum] = \''.$party_payment_text.'\' AND [invoice_Number] ='.$row_numbers['Invoice_Number'];
    		$gcert_sales_row3=mssql_fetch_assoc(mssql_query($sql_gcert_sales3));
    		$template['var97']+=$gcert_sales_row3['count'];
    		$template['var98']+=$gcert_sales_row3['sum'];

    		//Gift Cards Sold!
    		$sql_gc_sales4='SELECT SUM([Quantity]*[GC_Sold]) as [sum],COUNT(*) as [count] FROM [invoice_Itemized] WHERE [itemNum] = \'GIFT_C\' AND [invoice_Number] ='.$row_numbers['Invoice_Number'];
    		$gc_sales_row4=mssql_fetch_assoc(mssql_query($sql_gc_sales4));
    		$template['var42']+=$gc_sales_row4['sum'];
    		$template['var43']+=$gc_sales_row4['count'];


            //////////////////////
            /////CATEGORY TOTALS//
            //////////////////////
            $Invoice_Number=$row_numbers['Invoice_Number'];

            $sql_cat="SELECT [invoice_Totals].[invoice_Number],[invoice_Totals].[Discount],[invoice_Itemized].[itemNum],[invoice_Itemized].[Quantity],[invoice_Itemized].[PricePer],[invoice_Itemized].[Tax1Per],[inventory].[Dept_ID],[Departments].[subType],[Categories].[Description]  FROM [invoice_Totals] LEFT JOIN [invoice_Itemized] on [invoice_Itemized].[invoice_Number]=[invoice_Totals].[invoice_Number] LEFT JOIN [inventory] on [inventory].[itemNum]=[invoice_Itemized].[itemNum] LEFT JOIN [Departments] on [Departments].[Dept_ID]=[inventory].[Dept_ID] LEFT JOIN [Categories] on [Categories].[Cat_ID]=[Departments].[subType] WHERE [invoice_Totals].[invoice_Number]='$Invoice_Number'";
            $result_cat=mssql_query($sql_cat) or die("error: <br>$sql_cat: <br>".mssql_get_last_message());
            while($row_cat=mssql_fetch_array($result_cat)){
                $tracking[$row_cat['Description']]['name']=$row_cat['Description'];
                $tracking[$row_cat['Description']]['quantity']+=$row_cat['Quantity'];
                $tracking[$row_cat['Description']]['price']+=number_format((1-$row_cat['Discount'])*$row_cat['PricePer']*$row_cat['Quantity'],2,'.','');
            }
             ///////////////////////
            //END CATEGORY TOTALS//
            ///////////////////////

            ///////////////////////
            ///BREAK DOWN TOTALS///
            ///////////////////////


            //BAR TOTALS
            if(in_array($row_numbers['Station_ID'],$CONFIG[bar])&&$row_numbers['InvType']=='0'){
                //SALES
                $template['2_bar_checks']++;
                $template['2_bar_net_sales']+=$row_numbers['Total_Price'];
                //GIFT cert/cards
                $template['3_bar_giftcert_redeemed_total']+=$gcert_sales_row1['sum'];
                $template['3_bar_giftcert_redeemed_count']+=$gcert_sales_row1['count'];
                $template['3_bar_giftcard_redeemed_total']+=$gc_sales_row['sum'];
                $template['3_bar_giftcard_redeemed_count']+=$gc_sales_row['count'];
            }else{
                $template['2_bar_checks']+=0;
            }
            //TOGO TOTALS
            if($row_numbers['InvType']>0){
                //SALES
                $template['2_togo_checks']++;
                $template['2_togo_net_sales']+=$row_numbers['Total_Price'];
                //GIFT CARDS
                $template['3_togo_giftcert_redeemed_total']+=$gcert_sales_row1['sum'];
                $template['3_togo_giftcert_redeemed_count']+=$gcert_sales_row1['count'];
                $template['3_togo_giftcard_redeemed_total']+=$gc_sales_row['sum'];
                $template['3_togo_giftcard_redeemed_count']+=$gc_sales_row['count'];
            }else{
                $template['2_togo_checks']+=0;
            }
            //DINING TOTALS
            if(!in_array($row_numbers['Station_ID'],$CONFIG[bar])&&$row_numbers['InvType']=='0'){
                //SALES
                $template['2_dining_checks']++;
                $template['2_dining_guests']+=$row_numbers['Num_People_Party'];
                $template['2_dining_net_sales']+=$row_numbers['Total_Price'];
                //GIFT CARDS
                $template['3_dining_giftcert_redeemed_total']+=$gcert_sales_row1['sum'];
                $template['3_dining_giftcert_redeemed_count']+=$gcert_sales_row1['count'];
                $template['3_dining_giftcard_redeemed_total']+=$gc_sales_row['sum'];
                $template['3_dining_giftcard_redeemed_count']+=$gc_sales_row['count'];
            }else{
                $template['2_dining_checks']+=0;
                $template['2_dining_guests']+=0;
            }

            ///////////////////////////
            ///END BREAK DOWN TOTALS///
            ///////////////////////////


    	} else {

    		//add the voided check to the exceptions table
    		$template['var91']++;
    		$template['var92']+=$row_numbers['Total_Price'];
    		if($count_exceptions++%2==1) $bgcolor_exceptions='white';
    		else $bgcolor_exceptions='lightgray';
    		$template['exceptions_itemized'].='<TR style="background-color:'.$bgcolor_exceptions.'"><TD align=center>Check Void</TD><TD align=center>Entire Check</TD><TD align=center>$'.number_format($row_numbers['Total_Price'],2,'.','').'</TD><TD align=center>***</TD><TD align=center>'.$row_numbers['Invoice_Number'].'</TD></TR>';
    	}
    }
    //////////////////////
    /////CATEGORY TOTALS//
    //////////////////////
    foreach($tracking as $Description){
        $quantTotal+=$Description['quantity'];
        $priceTotal+=$Description['price'];

        $template['cat_table'].='<tr><td NOWRAP align=left">'.$Description['name'].'</td><td NOWRAP align=right>'.$Description['quantity'].'</td><td NOWRAP align=right>'.number_format($Description['price'],2,'.','').'</td></tr>';
    }
    $template['cat_table'].='<tr><td NOWRAP align=right style="font-weight:bold;border-top: 2px solid black;">Sub Total</td><td NOWRAP style="font-weight:bold;border-top: 2px solid black;" align=right>'.$quantTotal.'</td><td NOWRAP style="font-weight:bold;border-top: 2px solid black;" align=right>'.number_format($priceTotal,2,'.','').'</td></tr>';
    //////////////////////////
    /////END CATEGORY TOTALS//
    //////////////////////////
    //Money Track - Payouts
    $sql_payouts='SELECT * From [Payouts] WHERE DateTime >= \''.$shift_start.'\' AND DateTime <= \''.$shift_end.'\' AND [Cashier_ID]='.$template['var6'];
    $payouts_res=mssql_query($sql_payouts);
    while($payouts_row=mssql_fetch_assoc($payouts_res)){
    	$template['var23']++;
    	$template['var24']+=$payouts_row['Amount'];
    	if($count_payouts++%2==1) $bgcolor_payouts='white';
    	else $bgcolor_payouts='lightgray';
    	$template['payout_itemized'].='<TR style="background-color:'.$bgcolor_payouts.'"><TD align=center>$'.number_format($payouts_row['Amount'],2,'.','').'</TD><TD align=center>'.$payouts_row['Vendor_Number'].'</TD><TD align=center>'.$payouts_row['Description'].'</TD></TR>';
    }

    //fix CC tips
    $template['var18']=number_format($template['var18'],2,'.','');
    $template['var20']=number_format($template['var18'] *1,2,'.','');

    //Money Track - Owe Outs
    $template['var25']=$template['var17'] + $template['var59'] - $template['var20'] - $template['var22'] - $template['var24'];
    if($template['var25']<0){
    	$template['owe_statement']=$template['var1'].' Owes '.$template['var5'];
    	$template['owe_coupon_start']='';
    	$template['owe_coupon_end']='';
    } else {
    	$template['owe_statement']=$template['var5'].' Owes '.$template['var1'];
    	$template['owe_coupon_start']='<!--';
    	$template['owe_coupon_end']='-->';
    }

    $template['var25']=number_format(abs($template['var25']),2,'.','');

    //Payment Breakdown By CC Extraction
    $template['var26']=$cc_breakdown['Visa']['count']+0;
    $template['var27']=number_format($cc_breakdown['Visa']['sum'],2,'.','');
    $template['var28']=$cc_breakdown['MC']['count']+0;
    $template['var29']=number_format($cc_breakdown['MC']['sum'],2,'.','');
    $template['var30']=$cc_breakdown['Amex']['count']+0;
    $template['var31']=number_format($cc_breakdown['Amex']['sum'],2,'.','');
    $template['var32']=$cc_breakdown['Dine']['count']+0;
    $template['var33']=number_format($cc_breakdown['Dine']['sum'],2,'.','');
    $template['var87']=$cc_breakdown['Disc']['count']+0;
    $template['var88']=number_format($cc_breakdown['Disc']['sum'],2,'.','');
    $template['var89']=$cc_breakdown['Othr']['count']+0;
    $template['var90']=number_format($cc_breakdown['Othr']['sum'],2,'.','');
    $template['var34']=$cc_breakdown['ALL']['count']+0;
    $template['var35']=number_format($cc_breakdown['ALL']['sum'],2,'.','');

    //Invoice Exception Breakdown
    $template['var45']=$exceptions_breakdown[1]['count']+0;
    $template['var46']=number_format($exceptions_breakdown[1]['sum'],2,'.','');
    $template['var47']=$template['var47'] + $exceptions_breakdown[2]['count']+0;
    $template['var48']=number_format($template['var48'] + $exceptions_breakdown[2]['sum'],2,'.','');
    $template['var49']=$template['var49'] + $exceptions_breakdown[3]['count']+0;
    $template['var50']=number_format($template['var50'] + $exceptions_breakdown[3]['sum'],2,'.','');
    $template['var51']=$exceptions_breakdown[4]['count']+0;
    $template['var52']=number_format($exceptions_breakdown[4]['sum'],2,'.','');


    //Format Numbers
    $template['var13']=number_format($template['var13']-$template['var54'],2,'.','');
    $template['var14']=number_format($template['var14'],2,'.','');
    $template['var15']=number_format($template['var15']-$template['var42']-$template['var54'],2,'.','');
    $template['var16']=$template['var16']+0;
    $template['var17']=number_format($template['var17'],2,'.','');
    $template['var19']=$template['var19']+0;
    $template['var20']=number_format($template['var20'],2,'.','');
    $template['var21']=$template['var21']+0;
    $template['var22']=number_format($template['var22'],2,'.','');
    $template['var23']=$template['var23']+0;
    $template['var24']=number_format($template['var24'],2,'.','');
    $template['var25']=number_format($template['var25'],2,'.','');
    $template['var36']=$template['var36']+0;
    $template['var37']=number_format($template['var37'],2,'.','');
    $template['var38']=$template['var38']+0;
    $template['var39']=number_format($template['var39'],2,'.','');
    $template['var40']=$template['var36']+$template['var38']+0;
    $template['var41']=number_format($template['var37']+$template['var39'],2,'.','');
    $template['var42']=number_format($template['var42'],2,'.','');
    $template['var43']=$template['var43']+0;
    $template['var53']=$template['var53']+0;
    $template['var54']=number_format($template['var54'],2,'.','');
    $template['var55']=$template['var55']+0;
    $template['var56']=$template['var56']+0;
    $template['var57']=number_format($template['var13']/$template['var56'],2,'.','');
    $template['var58']=number_format($template['var13']/$template['var55'],2,'.','');
    $template['var59']=number_format($template['var59'],2,'.','');
    $template['var60']=number_format($template['var59']+$template['var17']-$template['var24'],2,'.','');
    $template['var85']=number_format($template['var85'],2,'.','');
    $template['var86']=$template['var85']-$template['var60'];
    $template['var91']=$template['var91']+0;
    $template['var92']=number_format($template['var92'],2,'.','');
    $predisc_net=$template['var13']+$template['var48']+$template['var50']+$template['var52'];
    $template['var93']=number_format($predisc_net/$template['var56'],2,'.','');
    $template['var94']=number_format($predisc_net/$template['var55'],2,'.','');
    $template['var95']=$template['var95']+0;
    $template['var96']=number_format($template['var96'],2,'.','');
    $template['var97']=$template['var97']+0;
    $template['var98']=number_format($template['var98'],2,'.','');
    $template['var001']=number_format($template['var60']-$template['var59'],2,'.','');

    //do over under statement
    if($template['var86']>0){
    	$template['over_under_statement']='Drawer Over By';
    	$template['drawer_under_show_start']='<!--';
    	$template['drawer_under_show_end']='-->';
    } else {
    	$template['over_under_statement']='Drawer Under By';
    	$template['drawer_under_show_start']='';
    	$template['drawer_under_show_end']='';
    }

    if($row63to84['ID']!=$_GET['id']){
    	$template['drawer_under_show_start']='';
    	$template['drawer_under_show_end']='';
    }

    $template['var86']=number_format(abs($template['var86']),2,'.','');

    //force replacements
    $template['cc_itemized']=$template['cc_itemized'];
    $template['exceptions_itemized']=$template['exceptions_itemized'];
    $template['payout_itemized']=$template['payout_itemized'];


    //MAKE TEMPLATE FIELDS
    $template['net_sales']=$template['var13'];
    $template['service_charge']=number_format($template['var20']+$template['var22'],2,'.','');
    $template['tax_collected']=number_format($template['var14'],2,'.','');
    $template['total_revenue']=number_format($template['tax_collected']+$template['service_charge']+$template['var13'],2,'.','');
    $template['item_discount']=$template['var50'];
    $template['subtotal_discount']='0.00';
    $template['total_discount']=number_format($template['subtotal_discount']+$template['item_discount'],2,'.','');
    $template['voids_num']=$template['var91'];
    $template['voids']=$template['var92'];
    $template['checks_num']=$template['var55'];
    $template['checks']=$template['total_revenue'];
    $template['checks_paid_num']=$template['checks_num']-$template['checks_outstanding_num'];
    $template['checks_paid']=number_format($template['checks']-$template['checks_outstanding'],2,'.','');
    $template['checks_outstanding']=number_format($template['checks_outstanding'],2,'.','');
    $template['gross_receipts']=$template['var17'];
    $template['charged_receipts']='0.00';
    $template['service_charges']=$template['var22'];
    $template['charged_tips']=number_format($template['var20'],2,'.','');
    $template['cash_tips_dec']='0.00';
    $template['indirect_tips_dec']='0.00';
    $template['total_tips']=$template['service_charge'];
    $template['total_tips_percent']=number_format(($template['total_tips']/$template['gross_receipts'])*100,2,'.','');
    $template['var56']=$template['2_togo_guests']+$template['2_dining_guests'];




    $template['2_dining_net_sales']=number_format($template['2_dining_net_sales']-$template['3_dining_giftcert_redeemed_total'],2,'.','');
    $template['2_dining_net_sales_percent']=number_format(($template['2_dining_net_sales']/$template['var13'])*100,2,'.','');
    $template['2_dining_guests_percent']=number_format(($template['2_dining_guests']/$template['var56'])*100,2,'.','');
    $template['2_dining_guests_average']=number_format($template['2_dining_net_sales']/$template['2_dining_guests'],2,'.','');
    $template['2_dining_checks_percent']=number_format(($template['2_dining_checks']/$template['var55'])*100,2,'.','');
    $template['2_dining_checks_average']=number_format($template['2_dining_net_sales']/$template['2_dining_checks'],2,'.','');
    $template['2_dining_tables']=$template['2_dining_checks'];
    $template['2_dining_tables_percent']=number_format(($template['2_dining_tables']/$template['var55'])*100,2,'.','');
    $template['2_dining_tables_average']=number_format($template['2_dining_net_sales']/$template['2_dining_tables'],2,'.','');

    $template['2_bar_net_sales']=number_format($template['2_bar_net_sales']-$template['3_bar_giftcert_redeemed_total'],2,'.','');
    $template['2_bar_net_sales_percent']=number_format(($template['2_bar_net_sales']/$template['var13'])*100,2,'.','');
    $template['2_bar_guests']=0;
    $template['2_bar_guests_percent']=number_format(0,2,'.','');
    $template['2_bar_guests_average']=number_format(0,2,'.','');
    $template['2_bar_checks_percent']=number_format(($template['2_bar_checks']/$template['var55'])*100,2,'.','');
    $template['2_bar_checks_average']=number_format($template['2_bar_net_sales']/$template['2_bar_checks'],2,'.','');
    $template['2_bar_tables']=0;
    $template['2_bar_tables_percent']=number_format(0,2,'.','');
    $template['2_bar_tables_average']=number_format(0,2,'.','');

    $template['2_togo_net_sales']=number_format($template['2_togo_net_sales']-$template['3_togo_giftcert_redeemed_total'],2,'.','');
    $template['2_togo_net_sales_percent']=number_format(($template['2_togo_net_sales']/$template['var13'])*100,2,'.','');
    $template['2_togo_guests']=0;
    $template['2_togo_guests_percent']=number_format(($template['2_togo_guests']/$template['var56'])*100,2,'.','');
    $template['2_togo_guests_average']=number_format($template['2_togo_net_sales']/$template['2_togo_guests'],2,'.','');
    $template['2_togo_checks_percent']=number_format(($template['2_togo_checks']/$template['var55'])*100,2,'.','');
    $template['2_togo_checks_average']=number_format($template['2_togo_net_sales']/$template['2_togo_checks'],2,'.','');
    $template['2_togo_tables']=0;
    $template['2_togo_tables_percent']=number_format(0,2,'.','');
    $template['2_togo_tables_average']=number_format(0,2,'.','');

    $template['2_total_net_sales']=number_format($template['2_togo_net_sales']+$template['2_bar_net_sales']+$template['2_dining_net_sales'],2,'.','');
    $template['2_total_guests']=$template['var56'];
    $template['2_total_checks']=$template['var55'];
    $template['2_total_tables']=$template['2_dining_tables'];

    $template['priceTotal-var54']=number_format($priceTotal-$template['var54'],2,'.','');

    $template['service_charge_num']=$template['var19']+$template['var21'];
    $template['cash_due_num']=$template['var16']+$template['service_charge_num']+$template['var23'];
    $template['cash_due']=number_format($template['var17']-($template['service_charge']-$template['var24']),2,'.','');
    $template['cards_total']=number_format($template['var27']+$template['var29']+$template['var31']+$template['var33'],2,'.','');
    $template['cards_total_num']=$template['var26']+$template['var28']+$template['var30']+$template['var32']+$template['var88']+$template['var90'];

    $i++;

/*
    $template['test']= "CASH: ".$template['var17']."  CREDIT: ".$template['var35']."  CCTIP: ".$template['var20']." TOTAL: ".$template['var15']."   :: ".($template['var15']-$template['var35']-$template['var17']-$template['var20']);

    $template['empTOTAL']="<table width=5 border=1 style='border-collapse: collapse;'><tr><td NOWRAP>Employee Name</td><td NOWRAP>ID</td><td NOWRAP>Cash</td><td NOWRAP>Credit</td><td NOWRAP>Tax</td><td NOWRAP>Total</td></tr>";
    foreach($empTOTAL as $emp=>$val){
        foreach ($key as $emp){
            $empSQL='SELECT [EmpName] FROM [Employee] WHERE Cashier_ID=\''.$emp.'\'';
            $name=mssql_result(mssql_query($empSQL),0,0);
            $template['empTOTAL'].="<tr><td NOWRAP>$name</td><td NOWRAP>$emp</td><td NOWRAP>$val</td><td NOWRAP></td><td NOWRAP>$emp[Total_Tax]</td><td NOWRAP>$emp[Grand_Total]</td></tr>";
            $grandCASH+=$;
            $grandTAX+=$;
            $grandCC+=$;
            $grandTOTAL+=$;
        }
    }
    $template['empTOTAL'].="<tr><td colspan=2>GRAND TOTAL</td><td NOWRAP>$grandTOTAL</td></tr>";
    $template['empTOTAL'].="</table>";
*/





$template[todays_datetime]=date('l, F j, Y - g:iA');
$template[logged_username]=$_SESSION[posclient_firstname];

$fcontents=get_page($template_file,$CONFIG[customer_name]." Administration Page","templates/html_print_template.html",$_GET[msg]);
echo parse_template($template,$fcontents);

?>

DarkWater · August 8, 2008

1) Oh boy, that was some long sloppy code. They make loops for a reason (referring to the 50+ repetitive lines with just different variable names in there at certain places)... >_>

2) Which variables do you need reset?

l0ve2hat3 · August 8, 2008

well i just want to know how to unset all variable...

The Little Guy · August 8, 2008

http://us2.php.net/manual/en/reserved.variables.globals.php

l0ve2hat3 · August 8, 2008

how can i do it using $GLOBALS??

foreach($GLOBALS as $var)unset($GLOBALS[$var]);

doesnt work

Sign In

unset all variables

Recommended Posts

l0ve2hat3

Link to comment

Share on other sites

DarkWater

Link to comment

Share on other sites

l0ve2hat3

Link to comment

Share on other sites

DarkWater

Link to comment

Share on other sites

l0ve2hat3

Link to comment

Share on other sites

DarkWater

Link to comment

Share on other sites

l0ve2hat3

Link to comment

Share on other sites

The Little Guy

Link to comment

Share on other sites

l0ve2hat3

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information