Exemplos de WhWavePickRecordModel::query em PHP

Exemplo n.º 1

Arquivo: whWavePickRecord.model.php Projeto: ohjack/newErp

 public static function checkPickStatus($waveId = 0, $shipOrderId = 0)
 {
     if (!$waveId && !$shipOrderId) {
         return false;
     }
     $sql = "select pickStatus, amount, sku from wh_wave_pick_record where is_delete=0 AND waveId='{$waveId}'" . ($shipOrderId ? " AND shipOrderId='{$shipOrderId}'" : "");
     $list = WhWavePickRecordModel::query($sql);
     if ($list) {
         $result = true;
         foreach ($list as $val) {
             if (empty($val['amount'])) {
                 $skus[] = $val['sku'];
             }
             if ($val['amount'] && !$val['pickStatus']) {
                 $result = false;
             }
         }
     } else {
         $result = 0;
     }
     if ($skus) {
         return implode(',', $skus);
     } else {
         return $result;
     }
 }