if ($s->check(true, $token, "CREATE_NOTE")) { $o->updatedby = $xoopsUser->getVar('uid'); //get current uid if (!$pl->createDebitCreditNoteLine($o->debitcreditnote_id, $o->adddebitcreditnotelineqty)) { $log->showLog(1, 'Fail to add debitcreditnoteline, you may try to add more debitcreditnote line after form refresh'); } $o->itemqty = $o->getLineCount($o->debitcreditnote_id); $pl->updateDebitCreditNoteLine(); if ($o->updateDebitCreditNote()) { //if data save successfully if ($o->iscomplete == 1) { $itemqty = $o->getLineCount($o->debitcreditnote_id); $pl->updateTotalAmt($o->debitcreditnote_id, $cur, $o->currency_id, $itemqty); include_once "class/AccountsAPI.php"; $accapi = new AccountsAPI(); /* if($o->documenttype==1){ $amt1=$o->amt; $amt2=$o->amt*-1; $originalamt1=$o->originalamt; $originalamt2=$o->originalamt*-1; $documentname="debit note"; } elseif($o->documenttype==2){ $amt1=$o->amt*-1; $amt2=$o->amt; $originalamt1=$o->originalamt*-1; $originalamt2=$o->originalamt; $documentname="credit note";
public function posting() { include "../simbiz/class/AccountsAPI.php"; $multiply = 1; if ($this->issotrx == 1) { $multiply = -1; } $acc = new AccountsAPI(); global $defaultcurrency_id, $defaultorganization_id, $userid, $taxaccount_id, $xoopsUser; $documentnoarray = array($this->sppayment_prefix . $this->document_no); $totaltransactionamt = $this->subtotal; $accountsarray = array($this->bpartneraccounts_id); $amtarray = array($this->subtotal * $multiply); $currencyarray = array($defaultcurrency_id); $conversionarray = array(1); $originalamtarray = array($this->subtotal * $multiply); $bpartnerarray = array($this->bpartner_id); $linetypearray = array(0); $transtypearray = array(""); $chequenoarray = array(""); $linedesc = array($this->description); $orgarray = array($this->organization_id); $track1array = array($this->track1_id); $track2array = array($this->track2_id); $track3array = array($this->track3_id); $sql = "SELECT pl.invoice_id,concat(i.spinvoice_prefix,i.document_no) as invoice_no,pl.chequeno,\n pl.amt,pl.branch_id,pl.track1_id,pl.track2_id,pl.track3_id,pl.accounts_id\n from sim_simbiz_paymentline pl\n inner join sim_simbiz_invoice i on pl.invoice_id=i.invoice_id\n where payment_id={$this->payment_id}"; $query = $this->xoopsDB->query($sql); $this->log->showLog(4, "Posting payment with SQL: {$sql}"); //$taxaccount_id= //declare 2nd line and above as creditor while ($row = $this->xoopsDB->fetchArray($query)) { array_push($documentnoarray, $this->sppayment_prefix . $this->document_no); array_push($accountsarray, $row['accounts_id']); array_push($amtarray, $row['amt'] * -1 * $multiply); array_push($currencyarray, $defaultcurrency_id); array_push($conversionarray, 1); array_push($originalamtarray, $row['amt'] * -1 * $multiply); array_push($bpartnerarray, 0); array_push($linetypearray, 1); array_push($transtypearray, ""); array_push($chequenoarray, $row['chequeno']); array_push($linedesc, "Payment ({$this->sppayment_prefix}{$this->document_no}), from {$this->bpartner_name}"); array_push($orgarray, $row['branch_id']); array_push($track1array, $row['track1_id']); array_push($track2array, $row['track2_id']); array_push($track3array, $row['track3_id']); } // $a=array($uid, // $this->document_date, // "simbiz", // "Payment: $this->sppayment_prefix$this->document_no", // $this->description, // $this->localamt, // $documentnoarray, // $accountsarray, // $amtarray, // $currencyarray, // $conversionarray, // $originalamtarray, // $bpartnerarray, // $transtypearray, // $linetypearray, // $chequenoarray, // "", // 1, // "", // $orgarray, // $track1array, // $track2array, // $track3array); $uname = $xoopsUser->getVar('uname'); if ($acc->PostBatch($userid, $this->document_date, "simbiz", "Payment {$this->sppayment_prefix}{$this->document_no}", "Post from Simbiz: Payment ({$this->sppayment_prefix}{$this->document_no}), from {$uname}", $this->subtotal, $documentnoarray, $accountsarray, $amtarray, $currencyarray, $conversionarray, $originalamtarray, $bpartnerarray, $transtypearray, $linetypearray, $chequenoarray, $linedesc, 1, "", $orgarray, $track1array, $track2array, $track3array)) { $this->batch_id = $acc->resultbatch_id; $this->xoopsDB->query("update sim_simbiz_payment set batch_id={$acc->resultbatch_id},iscomplete=1 where payment_id={$this->payment_id}"); return true; } else { return false; } }
\t\t//alert(self.parent.document.getElementById('divbpartner').innerHTML); \t\tself.parent.document.getElementById('divbpartner').innerHTML="{$bpartnerctrl}"; \t\tif({$acc->account_type} == 2 || {$acc->account_type} ==3) \t\tself.parent.document.getElementById('bpartnerID').innerHTML=""; \t\t//\tself.parent.document.getElementById('bpartner_id').value=0; \t\tself.parent.changePaidFrom(self.parent.document.frmPaymentVoucher.bpartner_id); \t</script> EOF; break; case "reactivate": if ($o->fetchPaymentVoucher($o->paymentvoucher_id)) { $o->iscomplete = 0; include_once "class/AccountsAPI.php"; $accapi = new AccountsAPI(); $result = $accapi->reverseBatch($o->batch_id); if ($result) { $o->iscomplete = 0; $o->batch_id = 0; $o->updatePaymentVoucher(); redirect_header("paymentvoucher.php?action=edit&paymentvoucher_id={$o->paymentvoucher_id}", $pausetime, "Record reactivated, transaction in accounts is reversed."); } else { redirect_header("paymentvoucher.php?action=edit&paymentvoucher_id={$o->paymentvoucher_id}", $pausetime, "<b style='color:red'>PaymentVoucher can't reactivated due to internal error.</b>"); } } break; case "refreshaccountsto": $accounts_id = $_POST['accounts_id']; $line = $_POST['line']; include_once "class/Accounts.php";
if ($o->fetchPayment($_POST['payment_id'])) { if ($o->posting()) { echo "<result><status>1</status><detail><msg>Record post successfully.</msg></detail></result>"; } else { echo "<result><status>0</status><detail><msg>Error, you cannot post record</msg></detail></result>"; } } else { echo "<result><status>0</status><detail><msg>Error, you cannot post record due to cannot fetch payment from database</msg></detail></result>"; } die; break; case "reactivate": $payment_id = $_POST['payment_id']; if ($o->fetchPayment($payment_id)) { include "../simbiz/class/AccountsAPI.php"; $acc = new AccountsAPI(); if ($acc->reverseBatch($o->batch_id)) { $o->iscomplete = 0; if ($xoopsDB->query("update sim_simbiz_payment set iscomplete=0 where payment_id=" . $payment_id)) { $arr = array("status" => 1); } else { $arr = array("status" => 0, "msg" => "cannot update payment status to not complete, probably due to sql error"); } } else { $arr = array("status" => 0, "msg" => "Cannot reverse transaction, probably due to financial year issue"); } } else { $arr = array("status" => 0, "msg" => "Cannot reverse transaction, fetch sql error"); } echo json_encode($arr); die;
public function posting() { include "../simbiz/class/AccountsAPI.php"; $multiply = 1; if ($this->issotrx == 0) { $multiply = -1; } $acc = new AccountsAPI(); global $defaultcurrency_id, $defaultorganization_id, $userid, $taxaccount_id, $xoopsUser; $documentnoarray = array($this->spinvoice_prefix . $this->document_no); $totaltransactionamt = $this->localamt; $accountsarray = array($this->bpartneraccounts_id); $amtarray = array($this->localamt * $multiply); $currencyarray = array($defaultcurrency_id); $conversionarray = array(1); $originalamtarray = array($this->localamt * $multiply); $bpartnerarray = array($this->bpartner_id); $linetypearray = array(0); $transtypearray = array(""); $chequenoarray = array(""); $linedesc = array($this->description); $orgarray = array($this->organization_id); $track1array = array($this->track1_id); $track2array = array($this->track2_id); $track3array = array($this->track3_id); $rowgettaxaccount = $this->xoopsDB->fetchArray($this->xoopsDB->query("Select accounts_id from sim_simbiz_accounts where account_type=9")); $taxaccount_id = $rowgettaxaccount['accounts_id']; $sql = "SELECT * from sim_simbiz_invoiceline where invoice_id={$this->invoice_id}"; $query = $this->xoopsDB->query($sql); $totalgstamt = 0; //$taxaccount_id= //declare 2nd line and above as creditor while ($row = $this->xoopsDB->fetchArray($query)) { array_push($documentnoarray, $this->spinvoice_prefix . $this->document_no); array_push($accountsarray, $row['accounts_id']); array_push($amtarray, $row['amt'] * -1 * $multiply); array_push($currencyarray, $defaultcurrency_id); array_push($conversionarray, 1); array_push($originalamtarray, $row['amt'] * -1 * $multiply); array_push($bpartnerarray, 0); array_push($linetypearray, 1); array_push($transtypearray, ""); array_push($chequenoarray, ""); array_push($linedesc, $row['subject']); array_push($orgarray, $row['branch_id']); array_push($track1array, $row['track1_id']); array_push($track2array, $row['track2_id']); array_push($track3array, $row['track3_id']); $totalgstamt += $row['gstamt']; } if ($totalgstamt != 0) { array_push($documentnoarray, $this->spinvoice_prefix . $this->document_no); array_push($accountsarray, $taxaccount_id); array_push($amtarray, $totalgstamt * -1 * $multiply); array_push($currencyarray, $defaultcurrency_id); array_push($conversionarray, 1); array_push($originalamtarray, $totalgstamt * -1 * $multiply); array_push($bpartnerarray, 0); array_push($transtypearray, ""); array_push($linetypearray, 1); array_push($chequenoarray, ""); array_push($linedesc, "Tax"); array_push($orgarray, $this->organization_id); array_push($track1array, 0); array_push($track2array, 0); array_push($track3array, 0); } // $a=array($uid, // $this->document_date, // "simbiz", // "Invoice: $this->spinvoice_prefix$this->document_no", // $this->description, // $this->localamt, // $documentnoarray, // $accountsarray, // $amtarray, // $currencyarray, // $conversionarray, // $originalamtarray, // $bpartnerarray, // $transtypearray, // $linetypearray, // $chequenoarray, // "", // 1, // "", // $orgarray, // $track1array, // $track2array, // $track3array); $uname = $xoopsUser->getVar('uname'); if ($acc->PostBatch($userid, $this->document_date, "simbiz", "Invoice {$this->spinvoice_prefix}{$this->document_no}", "Post from Simbiz: Invoice ({$this->spinvoice_prefix}{$this->document_no}), from {$uname}", $this->localamt, $documentnoarray, $accountsarray, $amtarray, $currencyarray, $conversionarray, $originalamtarray, $bpartnerarray, $transtypearray, $linetypearray, $chequenoarray, $linedesc, 1, "", $orgarray, $track1array, $track2array, $track3array)) { $this->batch_id = $acc->resultbatch_id; $this->xoopsDB->query("update sim_simbiz_invoice set batch_id={$acc->resultbatch_id},iscomplete=1 where invoice_id={$this->invoice_id}"); return true; } else { return false; } }
\talert("Retain earning posted! batch no:{$newbatchno}"); self.parent.document.getElementById("divperiod{$financialyearline_id}").innerHTML="<A href='batch.php?action=view&batch_id={$api->resultbatch_id}'> Amount: {$amt} (Posted as Batch No: {$newbatchno})</A>"; \t \t</script> EOF; break; case "repost": $batch_id = $_POST['batch_id']; $batchno = $_POST['batchno']; $newamt = $_POST['newamt'] * -1; $financialyearline_id = $_POST['financialyearline_id']; $reactivateresult = "failed"; include "class/AccountsAPI.php"; $api = new AccountsAPI(); if ($batch_id > 0) { if ($api->reActivateBatch($batch_id)) { $arraytrans_id = $l->getRetainEarningTransaction($batch_id); $trans1 = $arraytrans_id[0]; $trans2 = $arraytrans_id[1]; if ($api->updateTransactionAmount($batch_id, $newamt, $arraytrans_id, array($newamt, $newamt * -1))) { $reactivateresult = "success"; } } } $newamt = $newamt * -1; if ($newamt == 0) { $newamt = 0; } echo <<<EOF