/** * 临时插入订单数据对比关系 * @para $data as array * return true */ public static function insertTempOrderRelation($data) { self::initDB(); $string = array2sql_extral($data); $sql = "INSERT INTO `om_temp_orderRelation` SET " . $string; $query = self::$dbConn->query($sql); if ($query) { //$orderid = $data['omOrderId']; return true; } else { self::$errCode = "003"; self::$errMsg = "error"; return false; } }
/** * 插入订单快递描述的方法,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; }