public function act_isaudit($ordersn) { $status = PictureAuditModel::isaudit($ordersn); return $status; }
public static function exceloutput($starttime, $endtime, $scanuser, $pictype, $pic_status) { self::initDB(); $table = self::$table; $sql = "select ebay_ordersn,scanuser,picture_type,audit_status,audituser,scantime from {$table} WHERE audit_status={$pic_status}"; if (!empty($starttime)) { $sql .= " AND scantime>='{$starttime}'"; } if (!empty($endtime)) { $sql .= " AND scantime<='{$endtime}'"; } if (!empty($scanuser)) { $sql .= " AND scanuser='******'"; } if (!empty($pictype)) { $sql .= " AND picture_type='{$pictype}'"; } else { $sql .= " AND picture_type='fh' OR picture_type='cz'"; } //echo $sql; $query = self::$dbConn->query($sql); $res = self::$dbConn->fetch_array_all($query); if (count($res) > 0) { return $res; } else { self::$errCode = 203; self::$errMsg = 'select error'; return false; } }