Example #1
0
 public function act_isaudit($ordersn)
 {
     $status = PictureAuditModel::isaudit($ordersn);
     return $status;
 }
Example #2
0
 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;
     }
 }