<?php


require_once('config.php');
require_once(DIR_SYSTEM.'class/class.inc.php');

/*
$res=$db->select("*","sales_invoices","","22000,2000","");
while($row=$db->fetch($res))
{

	$respopayments=$db->select("*","sales_invoice_payments","invoice_id='".$row['id']."'","","id ASC");
	while($rowpopayments=$db->fetch($respopayments))
	{
		
		$card=0;
		$cash=0;
		$cheque=0;
		
		if($rowpopayments['type']!=='Credit' && $rowpopayments['type']!=='Return')
		{
			
			$resloc=$db->select("*","store_locations","id='".$row['location']."'","","");
			$rowloc=$db->fetch($resloc);
	
			if($rowpopayments['type']=='Card')
			{
				$accountid=$rowpopayments['card_type'];
				$card+=$rowpopayments['amount'];
			}
			elseif($rowpopayments['type']=='Cash')
			{
				$accountid=$rowloc['cash_account'];
				$cash+=$rowpopayments['amount'];
			}
			elseif($rowpopayments['type']=='Cheque')
			{
				$accountid=$rowloc['bank_account'];
				$cheque+=$rowpopayments['amount'];
			}
			
			$db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, rec_main_id, `rec_id` ,`narration`, `status`","'".$row['added_date']."' , '".$accountid."' , 'dr' , '".$rowpopayments['amount']."' , 'inv_sett' , '".$row['id']."', '".$rowpopayments['id']."' , '".$row['invoice_no']."', '".$row['status']."'");
		}
		
		
	}
				
				
}
		
	*/			
	/*	
$res=$db->select("*","customers_settlements","","","");
while($row=$db->fetch($res))
{	
					
	$db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, `rec_id` ,`narration`","'".$row['added_date']."' , '".$row['cash_book']."' , 'dr' , '".$row['amount_paid']."' , 'customer_settlement' , '".$row['id']."' , '".$str->zerono('CPR-',$row['id'])."'");
				
}
*/				
/*
			
	$db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, `rec_id` ,`narration`","'".$added_datedb."' , '".$account_id."' , 'cr' , '".$amount."' , 'customer_refund' , '".$lastid."' , '".$str->zerono('CRFND-',$lastid)."'");

*/
/*
$res=$db->select("*","general_ledger_payments","","","");
while($row=$db->fetch($res))
{	
		
	$db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, `rec_id` ,`narration`","'".$row['added_date']."' , '".$row['account']."' , 'cr' , '".$row['amount']."' , 'gl_payment' , '".$row['id']."' , '".$str->zerono('PMNT-',$row['id'])."'");

}

*/
/*
$res=$db->select("*","general_ledger_loan_management","","","");
while($row=$db->fetch($res))
{		
	$db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, `rec_id` ,`narration`","'".$row['received_date']."' , '".$row['debit_account']."' , 'dr' , '".$row['approved_amount']."' , 'loan_rcvd' , '".$row['id']."' , '".$str->zerono('CLOAN-',$row['id'])."'");
}
*/			
/*
$res=$db->select("*","general_ledger_loan_management_payments","","","id ASC");
while($row=$db->fetch($res))
{			
				
	$db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, rec_main_id, `rec_id` ,`narration`","'".$row['paid_date']."' , '".$row['account']."' , 'cr' , '".$row['amount']."' , 'loan_pmnt' , '".$row['loan_management_id']."' , '".$row['id']."' , '".$str->zerono('CLOAN-',$row['loan_management_id'])." Payment'");
	
}
*/
							
/*
$res=$db->select("*","general_ledger_journal_line","","","id ASC");
while($row=$db->fetch($res))
{
	
	$resm=$db->select("*","general_ledger_journal","id='".$row['journal_id']."'","","");
	$rowm=$db->fetch($resm);
						
	$db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, `rec_main_id`, `rec_id` ,`narration`","'".$rowm['date']."' , '".$row['accounts']."' , '".$row['type']."' , '".$row['amount']."' , 'gl_journal' , '".$rowm['id']."' , '".$row['id']."' , '".$str->zerono('JRNL-',$rowm['id'])."'");
	
}


*/



/*
$res=$db->select("*","general_ledger_general_payments","","","id ASC");
while($row=$db->fetch($res))
{					
	$db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, `rec_id` ,`narration`","'".$row['added_date']."' , '".$row['account']."' , 'cr' , '".$row['amount']."' , 'general_payment' , '".$row['id']."' , '".$str->zerono('GLP-',$row['id'])."'");
}

*/
	/*				
				
				//  $db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, `rec_id` ,`narration`","'".$paid_datedb."' , '".$uaccount."' , 'cr' , '".$approved_amount."' , 'payroll_loan_pmnt' , '".$lastid."' , '".$str->zerono('SLN-',$lastid)."'");
				
				
						//$db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, rec_main_id, `rec_id` ,`narration`","'".$paid_daten."' , '".$accountn."' , 'dr' , '".$amountn."' , 'payroll_loan_sett' , '".$lastid."' , '".$lastlineid."' , '".$str->zerono('SLN-',$lastid)." Settlement'");
						
						
				
				//  $db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, `rec_id` ,`narration`","'".$added_datedb."' , '".$cash_book."' , 'cr' , '".$allamt."' , 'salary_pmnt' , '".$lastid."' , '".$str->zerono('SLTRN-',$lastid)."'");
				

				//$db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, `rec_id` ,`narration`","'".$added_datedb."' , '".$debit_account."' , 'cr' , '".$amount."' , 'supplier_o_pmnt' , '".$lastid."' , '".$str->zerono('SOP-',$lastid)."'");
				
				*/
				
/*				
$res=$db->select("*","suppliers_payments_types","","","id ASC");
while($row=$db->fetch($res))
{	
	
	$resm=$db->select("*","suppliers_payments","id='".$row['payment_id']."'","","");
	$rowm=$db->fetch($resm);
				
	$db->insert("general_ledger_account_transactions","`added_date`,`account_id` , `type`, `amount`, `rec_type`, rec_main_id, `rec_id` ,`narration`","'".$rowm['added_date']."' , '".$row['account']."' , 'cr' , '".$row['amount']."' , 'supplier_payment' , '".$rowm['id']."' , '".$row['id']."' , '".$str->zerono('SPR-',$rowm['id'])."'");
				
}



*/