$o->taxctrl = $ctrl->getSelectTax($o->tax_id, 'Y'); if ($accountmoduleexist == true) { $o->debtoraccountsctrl = $ctrl->getSelectAccounts($o->debtoraccounts_id, 'Y', "onchange=''", "debtoraccounts_id", ""); $o->creditoraccountsctrl = $ctrl->getSelectAccounts($o->creditoraccounts_id, 'Y', "onchange=''", "creditoraccounts_id", ""); } else { $o->debtoraccountsctrl = "Accounting Module doesn't exist <input type='hidden' name='debtoraccounts_id' value=0>"; $o->creditoraccountsctrl = "Accounting Module doesn't exist <input type='hidden' name='creditoraccounts_id' value=0>"; } $o->getInputForm("new", -1, $token); $o->showBPartnerTable("WHERE bpartner_id>0 and organization_id={$defaultorganization_id}", "ORDER BY defaultlevel,bp.bpartner_no,bpartner_name"); } break; //when user request to edit particular organization //when user request to edit particular organization case "view": if ($o->fetchBPartner($o->bpartner_id)) { $o->orgctrl = $ctrl->selectionOrg($o->createdby, $o->organization_id, 'N', "", 'Y'); $o->viewBpartnerInfo(); $tokenadd = $s->createToken($tokenlife, "CREATE_ADD"); $tokencontacts = $s->createToken($tokenlife, "CREATE_CONTACTS"); include_once "class/Address.php.inc"; include_once "class/Contacts.php.inc"; $add = new Address(); $contacts = new Contacts(); $add->showAddressTable($o->bpartner_id, "WHERE ad.bpartner_id={$o->bpartner_id}", "ORDER BY ad.defaultlevel,ad.address_name", $tokenadd); echo "<BR>"; $contacts->showContactsTable($o->bpartner_id, "WHERE c.bpartner_id={$o->bpartner_id}", "ORDER BY c.defaultlevel,c.contacts_name", $tokencontacts); } else { //if can't find particular organization from database, return error message redirect_header("bpartner.php", 3, "Some error on viewing your bpartner data, probably database corrupted"); }
public function saveBPartnerFromTableList() { $this->log->showLog(2, "Access saveBPartnerFromTableList()"); // die; global $xoopsDB, $saveHandler, $createdby, $timestamp, $defaultorganization_id; $tablename = "sim_bpartner"; $pkey = "bpartner_id"; $keyword = "BPartner"; $controlfieldname = "bpartner_no"; $insertCount = $saveHandler->ReturnInsertCount(); $this->log->showLog(3, "Start Insert({$insertCount} records)"); if ($insertCount > 0) { $arrfield = array($controlfieldname, "bpartner_name", "companyno", "bpartnergroup_id", "industry_id", "terms_id", "isactive", "defaultlevel", "created", "createdby", "updated", "updatedby", "organization_id"); $arrfieldtype = array('%s', '%s', '%s', '%d', '%d', '%d', '%d', '%d', '%s', '%d', '%s', '%d', '%d'); // Yes there are INSERTs to perform... for ($currentRecord = 0; $currentRecord < $insertCount; $currentRecord++) { $arrvalue = array($saveHandler->ReturnInsertField($currentRecord, $controlfieldname), $saveHandler->ReturnInsertField($currentRecord, "bpartner_name"), $saveHandler->ReturnInsertField($currentRecord, "companyno"), $saveHandler->ReturnInsertField($currentRecord, "bpartnergroup_id"), $saveHandler->ReturnInsertField($currentRecord, "industry_id"), $saveHandler->ReturnInsertField($currentRecord, "terms_id"), $saveHandler->ReturnInsertField($currentRecord, "isactive"), $saveHandler->ReturnInsertField($currentRecord, "defaultlevel"), $timestamp, $createdby, $timestamp, $createdby, $defaultorganization_id); $controlvalue = $saveHandler->ReturnInsertField($currentRecord, $controlfieldname); $this->InsertRecord($tablename, $arrfield, $arrvalue, $arrfieldtype, $controlvalue, $pkey); // Now we execute this query } } $updateCount = $saveHandler->ReturnUpdateCount(); $this->log->showLog(3, "Start update({$updateCount} records)"); if ($updateCount > 0) { $arrfield = array($controlfieldname, "bpartner_name", "companyno", "bpartnergroup_id", "industry_id", "terms_id", "isactive", "defaultlevel", "updated", "updatedby", "isdeleted"); $arrfieldtype = array('%s', '%s', '%s', '%d', '%d', '%d', '%d', '%d', '%s', '%d', '%d'); // Yes there are UPDATEs to perform... for ($currentRecord = 0; $currentRecord < $updateCount; $currentRecord++) { $arrvalue = array($saveHandler->ReturnUpdateField($currentRecord, $controlfieldname), $saveHandler->ReturnUpdateField($currentRecord, "bpartner_name"), $saveHandler->ReturnUpdateField($currentRecord, "companyno"), $saveHandler->ReturnUpdateField($currentRecord, "bpartnergroup_id"), $saveHandler->ReturnUpdateField($currentRecord, "industry_id"), $saveHandler->ReturnUpdateField($currentRecord, "terms_id"), $saveHandler->ReturnUpdateField($currentRecord, "isactive"), $saveHandler->ReturnUpdateField($currentRecord, "defaultlevel"), $timestamp, $createdby, $saveHandler->ReturnUpdateField($currentRecord, "isdeleted")); $controlvalue = $saveHandler->ReturnUpdateField($currentRecord, $controlfieldname); $this->UpdateRecord($tablename, $pkey, $saveHandler->ReturnUpdateField($currentRecord), $arrfield, $arrvalue, $arrfieldtype, $controlvalue); } } $ispurge = 0; $deleteCount = $saveHandler->ReturnDeleteCount(); $this->log->showLog(3, "Start delete/purge({$deleteCount} records)"); $classname = "class/{$keyword}.inc.php"; include $classname; $this->log->showLog(3, "Include {$classname} successfully"); $o = new BPartner(); $this->log->showLog(3, "Inilialize {$keyword}()"); if ($deleteCount > 0) { for ($currentRecord = 0; $currentRecord < $deleteCount; $currentRecord++) { $record_id = $saveHandler->ReturnDeleteField($currentRecord); $o->fetchBPartner($record_id); $controlvalue = $o->bpartner_no; $isdeleted = $o->isdeleted; if ($o->allowDelete($record_id)) { $this->DeleteRecord($tablename, $pkey, $record_id, $controlvalue, $isdeleted); } else { $this->failfeedback .= "Cannot delete {$keyword}: {$o->followuptype_name} <br/>"; } } } //$this->failfeedback.="asdasdpasd<br/>\n"; //$this->failfeedback.="123 3443<br/>\n"; //$this->failfeedback.="234 45656523 234<br/>\n"; if ($this->failfeedback != "") { $this->failfeedback .= "Warning!<br/>\n" . $this->failfeedback; } $saveHandler->setErrorMessage($this->failfeedback); $saveHandler->CompleteSave(); }
$o->tooltips = $_POST["tooltips"]; $o->bpartner_url = $_POST["bpartner_url"]; $o->description = $_POST["description"]; if ($o->updateBPartnerBasicInfo()) { echo "OK<br/>{$o->errormessage}"; } else { echo "Error:<br/>{$o->errormessage}"; } break; case "showForm": include_once "class/SelectCtrl.inc.php"; $ctrl = new SelectCtrl(); $bpartner_id = $_GET['bpartner_id']; // echo print_r($_GET); if ($bpartner_id > 0) { $o->fetchBPartner($bpartner_id); $o->getBasicInputForm("edit"); // $o->getAccountingInputForm("edit"); } else { echo "<b class=\"highlight\">Error! Retrieved invalid business partner id, please choose appropriate business partner.</b>"; } break; default: include "menu.php"; $o->searchbpartnergroupctrl = $ctrl->getSelectBPartnerGroup(2, "searchbpartnergroup_id", "", "", "classic"); $xoTheme->addScript('browse.php?Frameworks/jquery/jquery.js'); $arrayresult = $o->searchAToZ(); $quicknamelist = $arrayresult[0]; $filterstring = $arrayresult[1]; $tabcount = 6; if ($havewriteperm == 1) {