PHP ebpls_insert_data函数代码示例

 function add($admin)
 {
     if ($this->m_dbLink) {
         $this->data_elems[EBPLS_ACCT_CODE_DATE_REGISTERED] = date("Y-m-d H:i:s");
         $this->data_elems[EBPLS_ACCT_CODE_UPDATED] = date("Y-m-d H:i:s");
         $this->data_elems[EBPLS_UPDATED_BY] = $admin;
         if (($error_num = $this->validateData()) > 0) {
             $strValues = $this->getData();
             $ret = ebpls_insert_data($this->m_dbLink, EBPLS_COT_TABLE, $strValues);
             if ($ret < 0) {
                 $this->debug("CREATE TAX FEE SYSREF FAILED [error:{$ret},msg=" . get_db_error() . "]");
                 $this->setError($ret, get_db_error());
                 return $ret;
             } else {
                 $this->debug("CREATE TAX FEE SYSREF SUCCESSFULL [{$ret}]");
                 return $ret;
             }
         } else {
             $this->debug("CREATE TAX FEE SYSREF FAILED [error:{$ret},msg=" . get_db_error() . "]");
             return $error_num;
         }
     } else {
         $this->debug("CREATE TAX FEE SYSREF FAILED INVALID DB LINK {$this->m_dbLink}");
         $this->setError($ret, "Invalid Db link {$this->m_dbLink}");
         return -1;
     }
 }

 function add($admin)
 {
     $this->debug("Formulatype : " . $this->getData(EBPLS_FORMULAS_FORMULA_TYPE));
     if ($this->m_dbLink) {
         $this->data_elems[EBPLS_FORMULAS_CREATE_TS] = date("Y-m-d H:i:s");
         $this->data_elems[EBPLS_FORMULAS_UPDATE_TS] = date("Y-m-d H:i:s");
         $this->data_elems[EBPLS_FORMULAS_ADMIN] = $admin;
         $obj = $this;
         unset($obj->err_code);
         unset($obj->err_mesg);
         $this->data_elems[EBPLS_FORMULAS_FORMULA_CLASS] = serialize($obj);
         if (($error_num = $this->validateData()) > 0) {
             $strValues = $this->getData();
             $ret = ebpls_insert_data($this->m_dbLink, EBPLS_FORMULAS_TABLE, $strValues);
             if ($ret < 0) {
                 $this->debug("CREATE FORMULA FAILED [error:{$ret},msg=" . get_db_error() . "]");
                 $this->setError($ret, get_db_error());
                 return $ret;
             } else {
                 $this->debug("FORMULA : " . $this->data_elems[EBPLS_FORMULAS_FORMULA_CLASS]->formula);
                 $this->debug("CREATE FORMULA SYSREF SUCCESSFULL [{$ret}]");
                 return 1;
             }
         } else {
             $this->debug("CREATE FORMULA FAILED [error:{$ret},msg=" . get_db_error() . "]");
             return $error_num;
         }
     } else {
         $this->debug("CREATE FORMULA FAILED INVALID DB LINK {$this->m_dbLink}");
         $this->setError($ret, "Invalid Db link {$this->m_dbLink}");
         return -1;
     }
 }

 /**
  * Adds new Industry Sector to ebls_INDUSTRY_SECTOR table
  *
  */
 function add()
 {
     if ($this->m_dbLink) {
         if (($error_num = $this->validateData()) > 0) {
             $strValues = $this->data_elems;
             $ret = ebpls_insert_data($this->m_dbLink, EBPLS_ZIP_TABLE, $strValues);
             if ($ret < 0) {
                 //$this->debug( "CREATE OCCUPNACY TYPE FAILED" );
                 //$this->setError( $ret, get_db_error() );
                 return $ret;
             } else {
                 //$this->debug( "CREATE OCCUPNACY TYPE SUCCESSFULL" );
                 $this->data_elems[ZIP_CODE] = $ret;
                 return $ret;
             }
         } else {
             //$this->debug( "CREATE INDUSTRY FAILED" );
             return $error_num;
         }
     } else {
         //$this->debug( "CREATE OWNER FAILED INVALID DB LINK $this->m_dbLink" );
         $this->setError($ret, "Invalid Db link {$this->m_dbLink}");
         return -1;
     }
 }

 function add()
 {
     if ($this->validateData() > 0) {
         $ts = time();
         $nYear = date("Y", $ts);
         $dt = date("Y-m-d H:i:s", $ts);
         $this->data_elems[TR_TS_SUBMITTED] = $dt;
         $this->data_elems[TR_TS_UPDATE] = $dt;
         $this->data_elems[TR_TS_CREATE] = $dt;
         $strValues = $this->data_elems;
         $ret = ebpls_insert_data($this->m_dbLink, TR_TABLE, $strValues);
         if ($ret < 0) {
             $this->debug("TR ADD ERROR : {$ret}");
             $this->setError(-1, get_db_error());
             return $ret;
         } else {
             $this->debug("TR ADD OK : {$ret}");
             return $ret;
         }
     } else {
         $this->debug("TR ADD TRANS REQ FAILED : {$ret}");
         $this->setError(-1, "TR ADD TRANS REQ FAILED validate data failed : {$ret}");
         return -1;
     }
 }

 function addTaxFeeList($arr_tax_fee_code)
 {
     if (is_array($arr_tax_fee_code)) {
         foreach ($arr_tax_fee_code as $key => $nature_code) {
             $strValues[EBPLS_BUSINESS_NATURE_NATURE_CODE] = $nature_code;
             $strValues[EBPLS_BUSINESS_NATURE_TAXFEES_TAX_FEE_CODE] = $tax_fee_code;
             $strValues[EBPLS_BUSINESS_NATURE_TAXFEES_CREATE_TS] = date("Y-m-d H:i:S");
             $strValues[EBPLS_BUSINESS_NATURE_TAXFEES_ADMIN] = $admin;
             ebpls_insert_data($this->m_dbLink, EBPLS_BUSINESS_NATURE_TAXFEES_TABLE, $strValues);
         }
     }
 }

 function addCheckPayment($trans_id, $check_name, $check_no, $check_amount, $check_date, $admin)
 {
     $this->data_elems[TPC_TRANS_ID] = $trans_id;
     $this->data_elems[TPC_CHECK_NO] = $check_no;
     $this->data_elems[TPC_CHECK_NAME] = $check_name;
     $this->data_elems[TPC_CHECK_STATUS] = CHECK_STATUS_PENDING;
     $this->data_elems[TPC_CHECK_AMOUNT] = $check_amount;
     $this->data_elems[TPC_CHECK_ISSUE_DATE] = $check_date;
     $this->data_elems[TPC_TS_CREATE] = date("Y-m-d H:i:s");
     $this->data_elems[TPC_ADMIN] = $admin;
     $this->data_elems[TPC_TS_LAST_UPDATE] = date("Y-m-d H:i:s");
     $ret = ebpls_insert_data($this->m_dbLink, TPC_TABLE, $this->data_elems);
     if ($ret > 0) {
         $this->data_elems[TPC_CHECK_ID] = $ret;
     }
     return $ret;
 }

 /**
  * Adds new occ permit application, creates an instance of EBPLSTransaction class, accessible using getTransaction of EBPLSPermit class.
  * Instance of EBPLSTransaction class identifies the Permit application status and requirements status in the system.
  *
  */
 function newApplication($creator, $user_level)
 {
     if ($this->m_dbLink) {
         $clsOwner = new EBPLSOwner($this->m_dbLink);
         $owner_id = $this->data_elems[FRANCHISE_OWNER_ID];
         if ($clsOwner->view($owner_id) <= 0) {
             $this->debug("Onwer with owner id {$owner_id} not found.");
             return -1;
         }
         $this->setOwner($clsOwner);
         if (($error_num = $this->validateData()) > 0) {
             // create reg ts
             $ts = time();
             $nYear = date("Y", $ts);
             $dt = date("Y-m-d H:i:s", $ts);
             $this->data_elems[FRANCHISE_APPLICATION_DATE] = $dt;
             $this->data_elems[FRANCHISE_FOR_YEAR] = $nYear;
             $this->setPermitRegistrationDates($dt, $dt, $nYear);
             $strValues = $this->data_elems;
             // create permit
             $ret = ebpls_insert_data($this->m_dbLink, EBPLS_FRANCHISE_PERMIT_TABLE, $strValues);
             if ($ret < 0) {
                 $this->debug("CREATE PEDDLERS PERMIT FAILED [error:{$ret},msg=" . get_db_error() . "]");
                 $this->setError($ret, get_db_error());
             } else {
                 $this->debug("CREAT PEDDLER OK {$ret}");
                 $this->data_elems[FRANCHISE_PERMIT_ID] = $ret;
                 $this->m_strPermitNo = $ret;
                 $this->m_strPermitType = PERMIT_TYPE_FRANCHISE;
             }
             return $ret;
         } else {
             $this->debug("CREATE PEDDLERS PERMIT FAILED [error:{$ret},msg=" . get_db_error() . "]");
             return $error_num;
         }
     } else {
         $this->debug("CREATE PEDDLERS FAILED INVALID DB LINK {$this->m_dbLink}");
         $this->setError($ret, "Invalid Db link {$this->m_dbLink}");
         return -1;
     }
 }

 function add()
 {
     if ($this->m_dbLink) {
         $this->data_elems[TRANS_BUSNATURE_FOR_YEAR] = date("Y");
         $this->data_elems[TRANS_BUSNATURE_TS_CREATE] = date("Y-m-d H:i:s");
         $this->data_elems[TRANS_BUSNATURE_TS_UPDATE] = date("Y-m-d H:i:s");
         if (($error_num = $this->validateData()) > 0) {
             $strValues = $this->getData();
             $ret = ebpls_insert_data($this->m_dbLink, TRANS_BUSNATURE_TABLE, $strValues);
             if ($ret < 0) {
                 $this->debug("CREATE EBPLSTransactionBusinessNature FAILED [error:{$ret},msg=" . get_db_error() . "]");
                 $this->setError($ret, get_db_error());
                 return $ret;
             } else {
                 $this->debug("CREATE EBPLSTransactionBusinessNature SUCCESSFULL [{$ret}]");
                 return 1;
             }
         } else {
             //print_r($this->getError());
             $this->debug("CREATE EBPLSTransactionBusinessNature FAILED [error:{$ret},msg=" . get_db_error() . "]");
             return $error_num;
         }
     } else {
         $this->debug("CREATE EBPLSTransactionBusinessNature FAILED INVALID DB LINK {$this->m_dbLink}");
         $this->setError($ret, "Invalid Db link {$this->m_dbLink}");
         return -1;
     }
 }

 function add()
 {
     if ($this->m_dbLink) {
         $this->data_elems[EBPLS_MOTORIZED_VEH_CREATE_TS] = date("Y-d-m H:i:s");
         $this->data_elems[EBPLS_MOTORIZED_VEH_UPDATED_TS] = date("Y-d-m H:i:s");
         if (($error_num = $this->validateData()) > 0) {
             $strValues = $this->data_elems;
             $this->debug("DATE : " . $this->data_elems[EBPLS_MOTORIZED_VEH_CREATE_TS]);
             $ret = ebpls_insert_data($this->m_dbLink, EBPLS_MOTORIZED_VEHICLES_TABLE, $strValues);
             if ($ret < 0) {
                 $this->debug("CREATE MOTORIZED VEH FAILED [error:{$ret},msg=" . get_db_error() . "]");
                 $this->setError($ret, get_db_error());
                 return $ret;
             } else {
                 $this->debug("CREATE MOTORIZED VEH SUCCESSFULL [{$ret}]");
                 $this->data_elems[EBPLS_MOTORIZED_VEH_MOTOR_ID] = $ret;
                 return $ret;
             }
         } else {
             $this->debug("CREATE MOTORIZED VEH FAILED [error:{$ret},msg=" . get_db_error() . "]");
             return $error_num;
         }
     } else {
         $this->debug("CREATE MOTORIZED VEH FAILED INVALID DB LINK {$this->m_dbLink}");
         $this->setError($ret, "Invalid Db link {$this->m_dbLink}");
         return -1;
     }
 }

 /**
  * Creats a CTC entry, will automatically validate data set ( data is set using setData( key, value) method ).
  *
  */
 function create()
 {
     if ($this->m_dbLink) {
         mysql_query("LOCK TABLES", $this->m_dbLink);
         $this->computeTax();
         if (($error_num = $this->validateData()) > 0) {
             if ($this->m_ctcType == CTC_TYPE_INDIVIDUAL) {
                 $m_strLastCode = get_next_system_code($this->m_dbLink, CODES_CTC_IND_COL);
             } else {
                 $m_strLastCode = get_next_system_code($this->m_dbLink, CODES_CTC_BUS_COL);
             }
             $this->data_elems[CTC_CODE] = $m_strLastCode;
             $this->data_elems[CTC_DATE_ISSUED] = date("Y-m-d H:i:s");
             $this->data_elems[CTC_ACCT_CODE] = "CTC PAYMENT";
             $strValues = $this->data_elems;
             $ret = ebpls_insert_data($this->m_dbLink, $this->m_strTable, $strValues);
             if ($ret < 0) {
                 $this->debug("CREATE CTC FAILED [error:{$ret},msg=" . get_db_error() . "]");
                 $this->m_arrError["err_code"] = $ret;
                 $this->m_arrError["err_mesg"] = get_db_error();
             } else {
                 $this->debug("CREATE CTC SUCCESSFULL [{$m_strLastCode}]");
                 $this->data_elems[CTC_CODE] = $m_strLastCode;
                 if ($this->m_ctcType == CTC_TYPE_INDIVIDUAL) {
                     $ret_ctc_code = update_system_code($this->m_dbLink, CODES_CTC_IND_COL, $m_strLastCode);
                 } else {
                     $ret_ctc_code = update_system_code($this->m_dbLink, CODES_CTC_BUS_COL, $m_strLastCode);
                 }
             }
         } else {
             $this->debug("CREATE CTC FAILED DUE TO INVALID DATA INPUT");
             $ret = $error_num;
         }
         mysql_query("UNLOCK TABLES", $this->m_dbLink);
         return $ret;
     } else {
         $this->setError(-1, "CREATE CTC FAILED DUE TO INVALID DB LINK");
         $this->debug("CREATE CTC FAILED DUE TO INVALID DB LINK");
         return -1;
     }
 }

 function add($creator)
 {
     $dt = date("Y-m-d H:i:s");
     $this->data_elems[NATURE_BUSINESS_APPLICATION_STATUS] = "PENDING";
     $this->data_elems[NATURE_BUSINESS_APPLICATION_YEAR] = date("Y");
     $this->data_elems[NATURE_UPDATED_BY] = $creator;
     $this->data_elems[NATURE_UPDATED_LAST_TS] = $dt;
     $this->data_elems[NATURE_CREATE_TS] = $dt;
     $strValues = $this->data_elems;
     $ret = ebpls_insert_data($this->m_dbLink, NATURE_BUSINESS_TABLE, $strValues);
     if ($ret < 0) {
         $this->setError(-1, "Insert error : " . get_db_error());
         $this->debug("Add Business nature failed");
     } else {
         $this->debug("Add Business nature ok. {$creator}");
     }
     return $ret;
 }

 function add()
 {
     $dt = date("Y-m-d H:i:s");
     $this->data_elems[TPORD_TS] = $dt;
     $strValues = $this->data_elems;
     //print_r($strValues);
     if ($this->validateData() > 0) {
         $ret = ebpls_insert_data($this->m_dbLink, TPORD_TABLE, $strValues);
         if ($ret < 0) {
             $this->debug("TPORD ADD DETAIL ERROR : {$ret}");
             return $ret;
         } else {
             $this->debug("TPORD ADD DETAIL OK : {$ret}");
             $this->data_elems[TPORD_OR_DETAIL_ID] = $ret;
             return $ret;
         }
     } else {
         $this->debug("TPORD ADD DETAIL FAILED.");
         $trans_obj->m_arrError = $this->getError();
         return -1;
     }
 }

 function add()
 {
     if ($this->m_dbLink) {
         $this->data_elems[$this->m_strTimeStamp] = date("Y-m-d H:i:s");
         if (($error_num = $this->validateData()) > 0) {
             $strValues = $this->getData();
             $ret = ebpls_insert_data($this->m_dbLink, $this->m_strTable, $strValues);
             if ($ret < 0) {
                 $this->debug("CREATE PDF SYSREF FAILED [error:{$ret},msg=" . get_db_error() . "]");
                 $this->setError($ret, get_db_error());
                 return $ret;
             } else {
                 //$this->data_elems[EBPLS_PDR_PR_ID] = $ret;
                 $this->debug("CREATE PDF SYSREF SUCCESSFULL [{$ret}]");
                 return $ret;
             }
         } else {
             $this->debug("CREATE PDF SYSREF FAILED [error:{$ret},msg=" . get_db_error() . "]");
             return $error_num;
         }
     } else {
         $this->debug("CREATE PDF SYSREF FAILED INVALID DB LINK {$this->m_dbLink}");
         $this->setError($ret, "Invalid Db link {$this->m_dbLink}");
         return -1;
     }
 }

 function addExtra($code, $desc, $tf_code, $user)
 {
     if ($this->m_dbLink) {
         $this->setData($this->m_strCodeKey, $code);
         $this->setData($this->m_strDescKey, $desc);
         $this->setData($this->m_strAdminKey, $user);
         $this->data_elems[$this->m_strCreateKey] = date("Y-m-d H:i:s");
         $this->data_elems[$this->m_strUpdateKey] = date("Y-m-d H:i:s");
         if ($this->m_strTableKeyConst == EBPLS_BUSINESS_NATURE) {
             $this->data_elems[SYSREF_NATURE_TAX_FEE_CODE] = $tf_code[0];
             $this->data_elems[SYSREF_NATURE_TAX_FEE_CODE2] = $tf_code[1];
         }
         $strValues = $this->getData();
         if (($error_num = $this->validateData()) > 0) {
             $ret = ebpls_insert_data($this->m_dbLink, $this->m_strTableKey, $strValues);
             if ($ret < 0) {
                 $this->debug("CREATE SYSREF {$this->m_strTableKey} FAILED [error:{$ret},msg=" . get_db_error() . "]");
                 $this->setError($ret, get_db_error());
                 return $ret;
             } else {
                 $this->debug("CREATE {$this->m_strTableKey} SUCCESSFULL [{$ret}]");
                 return $ret;
             }
         } else {
             $this->debug("CREATE {$this->m_strTableKey} FAILED [error:{$ret},msg=" . get_db_error() . "]");
             return $error_num;
         }
     } else {
         $this->debug("CREATE {$this->m_strTableKey} FAILED INVALID DB LINK {$this->m_dbLink}");
         $this->setError($ret, "Invalid Db link {$this->m_dbLink}");
         return -1;
     }
 }

 function add(&$trans_obj, $creator)
 {
     if ($this->loadFeeCodeData() < 0) {
         $trans_obj->setError(-1, "Unable to load fee data with feecode : " . $trans_obj->getData(TRANS_FEE_ID));
         return -1;
     }
     if ($this->validateData() > 0) {
         $ts = time();
         $dt = date("Y-m-d H:i:s", $ts);
         $this->data_elems[TF_LAST_UPDATED_TS] = $dt;
         $this->data_elems[TF_TS_CREATE] = $dt;
         $this->data_elems[TF_TRANS_ID] = $trans_obj->getData(TRANS_ID);
         $this->data_elems[TF_PERMIT_TYPE] = $trans_obj->getPermitType();
         $this->data_elems[TF_PERMIT_ID] = $trans_obj->getPermitId();
         $this->data_elems[TF_LAST_UPDATED_BY] = $creator;
         if (($computeRet = $this->computeTaxTotalAmounDue()) < 0) {
             $trans_obj->setError(-1, "computeTaxTotalAmounDue failed with feecode : " . $this->getData(TF_TAX_FEE_CODE) . ", return {$computeRet}!");
             return -2;
         }
         unset($this->data_elems[TF_TAX_FORMULA]);
         $strValues = $this->data_elems;
         $ret = ebpls_insert_data($this->m_dbLink, TF_TABLE, $strValues);
         if ($ret < 0) {
             $this->debug("TF ADD ERROR : {$ret}");
             $trans_obj->setError($ret, get_db_error());
             return $ret;
         } else {
             $this->debug("TF ADD OK : {$ret}");
             $this->data_elems[TF_FEE_ID] = $ret;
             return $ret;
         }
     } else {
         $this->debug("TF ADD FEE FAILED.");
         $trans_obj->m_arrError = $this->getError();
         return -1;
     }
 }