Example #1
0
 /**
  * 插入订单快递描述的方法,key为fedexRemark,现在只有独立商城会用到
  * 以下为demo
  * @param array $data 为一个二维数组,至少是一条快递描述记录
  * @return bool
  * @author zqt
  * @modify 20140807 修改方法名,同时订单大数组键改为了declarationContent,表也换了
  */
 public function insertOrderDeclarationContent($data)
 {
     $data = array_filter($data);
     if (empty($data)) {
         //如果$data为空,则不支持操作,直接返回,因为订单跟踪号是非必须的
         return true;
     }
     //检测订单号是否插入成功
     if ($this->_orderid == 0) {
         return false;
     } else {
         foreach ($data as $key => $value) {
             $data[$key]['omOrderId'] = $this->_orderid;
             $data[$key]['datetime'] = time();
         }
     }
     $table = C('DB_PREFIX') . 'declaration_content';
     foreach ($data as $value) {
         $fdata = $this->formatInsertField($table, $value);
         if ($fdata === false) {
             self::$errMsg = $this->validatemsg;
             return false;
         }
         if (!$this->sql("INSERT INTO {$table} SET " . array2sql($fdata))->insert()) {
             return false;
         }
     }
     return true;
 }
Example #2
0
 public static function deleteExpressRemark($omOrderId)
 {
     !self::$dbConn ? self::initDB() : null;
     $sql = "DELETE FROM " . self::$Table . " WHERE omOrderId = " . $omOrderId;
     //echo $sql;
     if (!self::$dbConn->query($sql)) {
         self::$errCode = "002";
         self::$errMsg = " 插入数据失败! ";
         return false;
         //失败则设置错误码和错误信息, 返回false
     } else {
         self::$errCode = "200";
         self::$errMsg = " 插入数据成功! ";
         return true;
         //失败则设置错误码和错误信息, 返回true
     }
 }