File manager

File manager - Edit - /home/webivo6/rado.webivox.com/gltrn.php

Back
<?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'])."'"); } */

| ver. 1.4 | Github | . | PHP 7.2.34 | Generation time: 0 | proxy | phpinfo | Settings