public function saveBPartnerGroup() { $this->log->showLog(2, "Access saveBPartnerGroup()"); // die; global $xoopsDB, $saveHandler, $createdby, $timestamp, $defaultorganization_id; $tablename = "sim_bpartnergroup"; $pkey = "bpartnergroup_id"; $keyword = "BPartnerGroup"; $controlfieldname = "bpartnergroup_name"; $insertCount = $saveHandler->ReturnInsertCount(); $this->log->showLog(3, "Start Insert({$insertCount} records)"); if ($insertCount > 0) { $arrfield = array($controlfieldname, "debtoraccounts_id", "creditoraccounts_id", "description", "isactive", "defaultlevel", "created", "createdby", "updated", "updatedby", "organization_id"); $arrfieldtype = array('%s', '%d', '%d', '%s', '%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, "debtoraccounts_id"), $saveHandler->ReturnInsertField($currentRecord, "creditoraccounts_id"), $saveHandler->ReturnInsertField($currentRecord, "description"), $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, "debtoraccounts_id", "creditoraccounts_id", "description", "isactive", "defaultlevel", "updated", "updatedby", "isdeleted"); $arrfieldtype = array('%s', '%d', '%d', '%s', '%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, "debtoraccounts_id"), $saveHandler->ReturnUpdateField($currentRecord, "creditoraccounts_id"), $saveHandler->ReturnUpdateField($currentRecord, "description"), $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 BPartnerGroup(); $this->log->showLog(3, "Inilialize {$keyword}()"); if ($deleteCount > 0) { for ($currentRecord = 0; $currentRecord < $deleteCount; $currentRecord++) { $record_id = $saveHandler->ReturnDeleteField($currentRecord); $o->fetchBPartnerGroup($record_id); $controlvalue = $o->bpartnergroup_name; $isdeleted = $o->isdeleted; if ($o->allowDelete($record_id)) { $this->DeleteRecord($tablename, $pkey, $record_id, $controlvalue, $isdeleted); } else { $this->failfeedback .= "Cannot delete {$keyword}: {$o->bpartnergroup_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(); }
} } else { // if the token is not valid or the token is expired, it back to previous form with previous inputed data $log->showLog(1, "Business partner group '{$o->bpartnergroup_name}' cannot be save due to token expired."); $token = $s->createToken($tokenlife, "CREATE_ACG"); $o->orgctrl = $ctrl->selectionOrg($o->createdby, $o->organization_id, 'N', "", 'Y'); //$o->debtoraccountsctrl=$ctrl->getSelectAccounts($o->debtoraccounts_id,'Y',"","debtoraccounts_id","AND placeholder=0 AND account_type =2"); //$o->creditoraccountsctrl=$ctrl->getSelectAccounts($o->creditoraccounts_id,'Y',"","creditoraccounts_id","AND placeholder=0 AND account_type =3"); $o->getInputForm("new", -1, $token); $o->showBPartnerGroupTable("WHERE g.bpartnergroup_id>0 and g.organization_id={$defaultorganization_id}", "ORDER BY g.defaultlevel,g.bpartnergroup_name"); } break; //when user request to edit particular organization //when user request to edit particular organization case "edit": if ($o->fetchBPartnerGroup($o->bpartnergroup_id)) { //create a new token for editing a form $token = $s->createToken($tokenlife, "CREATE_ACG"); $o->orgctrl = $ctrl->selectionOrg($o->createdby, $o->organization_id, 'N', "", 'Y'); if ($issimbiz) { $o->debtoraccountsctrl = $simbizctrl->getSelectAccounts($o->debtoraccounts_id, 'Y', "", "debtoraccounts_id", "AND placeholder=0 AND account_type =2"); $o->creditoraccountsctrl = $simbizctrl->getSelectAccounts($o->creditoraccounts_id, 'Y', "", "creditoraccounts_id", "AND placeholder=0 AND account_type =3"); } else { $o->debtoraccountsctrl = "<input name='debtoraccounts_id' value='0'>"; $o->creditoraccountsctrl = "<input name='creditoraccounts_id' value='0'>"; } $o->getInputForm("edit", $o->bpartnergroup, $token); $o->showBPartnerGroupTable("WHERE g.bpartnergroup_id>0 and g.organization_id={$defaultorganization_id}", "ORDER BY g.defaultlevel,g.bpartnergroup_name"); } else { //if can't find particular organization from database, return error message redirect_header("bpartnergroup.php", 3, "Some error on viewing your bpartnergroup data, probably database corrupted");