PHP Query\Query类代码示例

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'QuestionMatrixResponse')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['id_matrix_response']) && !empty($fields['id_matrix_response'])) {
         $criteria->add(QuestionMatrixResponse::ID_MATRIX_RESPONSE, $fields['id_matrix_response']);
     }
     if (isset($fields['id_question']) && !empty($fields['id_question'])) {
         $criteria->add(QuestionMatrixResponse::ID_QUESTION, $fields['id_question']);
     }
     if (isset($fields['header_type']) && !empty($fields['header_type'])) {
         $criteria->add(QuestionMatrixResponse::HEADER_TYPE, $fields['header_type']);
     }
     if (isset($fields['description']) && !empty($fields['description'])) {
         $criteria->add(QuestionMatrixResponse::DESCRIPTION, $fields['description']);
     }
     if (isset($fields['status']) && !empty($fields['status'])) {
         $criteria->add(QuestionMatrixResponse::STATUS, $fields['status']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'PurchaseOrderLog')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['id_purchase_order_log']) && !empty($fields['id_purchase_order_log'])) {
         $criteria->add(PurchaseOrderLog::ID_PURCHASE_ORDER_LOG, $fields['id_purchase_order_log']);
     }
     if (isset($fields['id_purchase_order']) && !empty($fields['id_purchase_order'])) {
         $criteria->add(PurchaseOrderLog::ID_PURCHASE_ORDER, $fields['id_purchase_order']);
     }
     if (isset($fields['id_user']) && !empty($fields['id_user'])) {
         $criteria->add(PurchaseOrderLog::ID_USER, $fields['id_user']);
     }
     if (isset($fields['date']) && !empty($fields['date'])) {
         $criteria->add(PurchaseOrderLog::DATE, $fields['date']);
     }
     if (isset($fields['event_type']) && !empty($fields['event_type'])) {
         $criteria->add(PurchaseOrderLog::EVENT_TYPE, $fields['event_type']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'AIT1')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['ItemCode']) && !empty($fields['ItemCode'])) {
         $criteria->add(ProductPriceListHistory::ITEMCODE, $fields['ItemCode']);
     }
     if (isset($fields['PriceList']) && !empty($fields['PriceList'])) {
         $criteria->add(ProductPriceListHistory::PRICELIST, $fields['PriceList']);
     }
     if (isset($fields['Price']) && !empty($fields['Price'])) {
         $criteria->add(ProductPriceListHistory::PRICE, $fields['Price']);
     }
     if (isset($fields['Currency']) && !empty($fields['Currency'])) {
         $criteria->add(ProductPriceListHistory::CURRENCY, $fields['Currency']);
     }
     if (isset($fields['LogInstance']) && !empty($fields['LogInstance'])) {
         $criteria->add(ProductPriceListHistory::LOGINSTANCE, $fields['LogInstance']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'OCRY')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['Code']) && !empty($fields['Code'])) {
         $criteria->add(Country::CODE, $fields['Code']);
     }
     if (isset($fields['Name']) && !empty($fields['Name'])) {
         $criteria->add(Country::NAME, $fields['Name']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'PriceList')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['id_price_list']) && !empty($fields['id_price_list'])) {
         $criteria->add(PriceList::ID_PRICE_LIST, $fields['id_price_list']);
     }
     if (isset($fields['id_product']) && !empty($fields['id_product'])) {
         $criteria->add(PriceList::ID_PRODUCT, $fields['id_product']);
     }
     if (isset($fields['quantity_min']) && !empty($fields['quantity_min'])) {
         $criteria->add(PriceList::QUANTITY_MIN, $fields['quantity_min']);
     }
     if (isset($fields['quantity_max']) && !empty($fields['quantity_max'])) {
         $criteria->add(PriceList::QUANTITY_MAX, $fields['quantity_max']);
     }
     if (isset($fields['price']) && !empty($fields['price'])) {
         $criteria->add(PriceList::PRICE, $fields['price']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'PurchaseOrder')
 {
     $criteria = $query->where();
     // $criteria->prefix($prefix);
     if (isset($fields['id_purchase_order']) && !empty($fields['id_purchase_order'])) {
         $criteria->add(PurchaseOrder::ID_PURCHASE_ORDER, $fields['id_purchase_order']);
     }
     if (isset($fields['sap_document_number']) && !empty($fields['sap_document_number'])) {
         $criteria->add(PurchaseOrder::SAP_DOCUMENT_NUMBER, $fields['sap_document_number']);
     }
     if (isset($fields['id_supplier']) && !empty($fields['id_supplier'])) {
         $criteria->add(PurchaseOrder::ID_SUPPLIER, $fields['id_supplier']);
     }
     if (isset($fields['id_courtyard']) && !empty($fields['id_courtyard'])) {
         $criteria->add(PurchaseOrder::ID_COURTYARD, $fields['id_courtyard']);
     }
     if (isset($fields['id_destination_country']) && !empty($fields['id_destination_country'])) {
         $criteria->add(PurchaseOrder::ID_DESTINATION_COUNTRY, $fields['id_destination_country']);
     }
     if (isset($fields['num_purchase_order']) && !empty($fields['num_purchase_order'])) {
         $criteria->add(PurchaseOrder::NUM_PURCHASE_ORDER, $fields['num_purchase_order']);
     }
     if (isset($fields['purchase_order_date']) && !empty($fields['purchase_order_date'])) {
         $criteria->add(PurchaseOrder::PURCHASE_ORDER_DATE, $fields['purchase_order_date']);
     }
     if (isset($fields['delivery_estimate_date']) && !empty($fields['delivery_estimate_date'])) {
         $criteria->add(PurchaseOrder::DELIVERY_ESTIMATE_DATE, $fields['delivery_estimate_date']);
     }
     if (isset($fields['courtyard_arrival_date']) && !empty($fields['courtyard_arrival_date'])) {
         $criteria->add(PurchaseOrder::COURTYARD_ARRIVAL_DATE, $fields['courtyard_arrival_date']);
     }
     if (isset($fields['reference']) && !empty($fields['reference'])) {
         $criteria->add(PurchaseOrder::REFERENCE, $fields['reference']);
     }
     if (isset($fields['id_currency']) && !empty($fields['id_currency'])) {
         $criteria->add(PurchaseOrder::ID_CURRENCY, $fields['id_currency']);
     }
     if (isset($fields['groupnum']) && !empty($fields['groupnum'])) {
         $criteria->add(PurchaseOrder::GROUPNUM, $fields['groupnum']);
     }
     if (isset($fields['comments']) && !empty($fields['comments'])) {
         $criteria->add(PurchaseOrder::COMMENTS, $fields['comments']);
     }
     if (isset($fields['invoice_number']) && !empty($fields['invoice_number'])) {
         $criteria->add(PurchaseOrder::INVOICE_NUMBER, $fields['invoice_number']);
     }
     if (isset($fields['id_folio_import']) && $fields['id_folio_import'] != "") {
         $criteria->add(PurchaseOrder::ID_FOLIO_IMPORT, $fields['id_folio_import']);
     }
     if (isset($fields['status']) && $fields['status'] != "") {
         switch ($fields['status']) {
             case PurchaseOrder::$Status["Canceled"]:
                 $criteria->add(PurchaseOrder::CANCELLED, PurchaseOrder::$Cancelled["Yes"]);
                 break;
             case PurchaseOrder::$Status["Closed"]:
                 $criteria->add(PurchaseOrder::CANCELLED, PurchaseOrder::$Cancelled["No"]);
                 $criteria->add(PurchaseOrder::CLOSED, PurchaseOrder::$Closed["Yes"]);
                 break;
             default:
                 $criteria->add(PurchaseOrder::STATUS, $fields['status']);
                 $criteria->add(PurchaseOrder::CANCELLED, PurchaseOrder::$Cancelled["No"]);
                 $criteria->add(PurchaseOrder::CLOSED, PurchaseOrder::$Closed["No"]);
                 break;
         }
     }
     if (isset($fields['startDate']) && !empty($fields['startDate']) && isset($fields['endDate']) && !empty($fields['endDate'])) {
         $criteria->add(PurchaseOrder::PURCHASE_ORDER_DATE, array($fields['startDate'] . " 00:00:00", $fields['endDate'] . " 23:59:59"), BaseQuery::BETWEEN);
     } else {
         if (isset($fields['startDate']) && !empty($fields['startDate'])) {
             $criteria->add(PurchaseOrder::PURCHASE_ORDER_DATE, array($fields['startDate'] . " 00:00:00", $fields['startDate'] . " 23:59:59"), BaseQuery::BETWEEN);
         }
     }
     //$criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'CustomsTariffCode')
 {
     $criteria = $query->where();
     //$criteria = $query->order(" TotalTax asc ");
     $criteria->prefix($prefix);
     if (isset($fields['CstGrpCode']) && !empty($fields['CstGrpCode'])) {
         $criteria->add(CustomsTariffCode::CODE, $fields['CstGrpCode']);
     }
     if (isset($fields['CstGrpName']) && !empty($fields['CstGrpName'])) {
         $criteria->add(CustomsTariffCode::NAME, $fields['CstGrpName']);
     }
     if (isset($fields['TotalTax']) && !empty($fields['TotalTax'])) {
         $criteria->add(CustomsTariffCode::PERCENT, $fields['TotalTax']);
     }
     if (isset($fields['Locked']) && !empty($fields['Locked'])) {
         $criteria->add(CustomsTariffCode::STATUS, $fields['Locked']);
     }
     if (isset($fields['DataSource']) && !empty($fields['DataSource'])) {
         $criteria->add(CustomsTariffCode::DATASOURCE, $fields['DataSource']);
     }
     if (isset($fields['UserSign']) && !empty($fields['UserSign'])) {
         $criteria->add(CustomsTariffCode::USERSIGN, $fields['UserSign']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'WarehouseEntranceClaimReport')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['id_warehouse_entrance_quarantine_claim_report']) && !empty($fields['id_warehouse_entrance_quarantine_claim_report'])) {
         $criteria->add(WarehouseEntranceClaimReport::ID_WAREHOUSE_ENTRANCE_QUARANTINE_CLAIM_REPORT, $fields['id_warehouse_entrance_quarantine_claim_report']);
     }
     if (isset($fields['id_warehouse_entrance']) && !empty($fields['id_warehouse_entrance'])) {
         $criteria->add(WarehouseEntranceClaimReport::ID_WAREHOUSE_ENTRANCE, $fields['id_warehouse_entrance']);
     }
     if (isset($fields['id_warehouse_entrance_product']) && !empty($fields['id_warehouse_entrance_product'])) {
         $criteria->add(WarehouseEntranceClaimReport::ID_WAREHOUSE_ENTRANCE_PRODUCT, $fields['id_warehouse_entrance_product']);
     }
     if (isset($fields['reimbursement_doc_num']) && !empty($fields['reimbursement_doc_num'])) {
         $criteria->add(WarehouseEntranceClaimReport::REIMBURSEMENT_DOC_NUM, $fields['reimbursement_doc_num']);
     }
     if (isset($fields['invoice_number']) && !empty($fields['invoice_number'])) {
         $criteria->add(WarehouseEntranceClaimReport::INVOICE_NUMBER, $fields['invoice_number']);
     }
     if (isset($fields['claimed_amount']) && !empty($fields['claimed_amount'])) {
         $criteria->add(WarehouseEntranceClaimReport::CLAIMED_AMOUNT, $fields['claimed_amount']);
     }
     if (isset($fields['final_amount']) && !empty($fields['final_amount'])) {
         $criteria->add(WarehouseEntranceClaimReport::FINAL_AMOUNT, $fields['final_amount']);
     }
     if (isset($fields['debit_meno_amount']) && !empty($fields['debit_meno_amount'])) {
         $criteria->add(WarehouseEntranceClaimReport::DEBIT_MENO_AMOUNT, $fields['debit_meno_amount']);
     }
     if (isset($fields['video_link']) && !empty($fields['video_link'])) {
         $criteria->add(WarehouseEntranceClaimReport::VIDEO_LINK, $fields['video_link']);
     }
     if (isset($fields['description']) && !empty($fields['description'])) {
         $criteria->add(WarehouseEntranceClaimReport::DESCRIPTION, $fields['description']);
     }
     if (isset($fields['good']) && !empty($fields['good'])) {
         $criteria->add(WarehouseEntranceClaimReport::GOOD, $fields['good']);
     }
     if (isset($fields['missing']) && !empty($fields['missing'])) {
         $criteria->add(WarehouseEntranceClaimReport::MISSING, $fields['missing']);
     }
     if (isset($fields['rejected']) && !empty($fields['rejected'])) {
         $criteria->add(WarehouseEntranceClaimReport::REJECTED, $fields['rejected']);
     }
     if (isset($fields['price']) && !empty($fields['price'])) {
         $criteria->add(WarehouseEntranceClaimReport::PRICE, $fields['price']);
     }
     if (isset($fields['landed_cost']) && !empty($fields['landed_cost'])) {
         $criteria->add(WarehouseEntranceClaimReport::LANDED_COST, $fields['landed_cost']);
     }
     if (isset($fields['indirect_costs']) && !empty($fields['indirect_costs'])) {
         $criteria->add(WarehouseEntranceClaimReport::INDIRECT_COSTS, $fields['indirect_costs']);
     }
     if (isset($fields['report_status']) && !empty($fields['report_status'])) {
         $criteria->add(WarehouseEntranceClaimReport::REPORT_STATUS, $fields['report_status']);
     }
     if (isset($fields['id_supplier']) && !empty($fields['id_supplier'])) {
         $criteria->add(WarehouseEntranceClaimReport::ID_SUPPLIER, $fields['id_supplier']);
     }
     if (isset($fields['id_currency']) && !empty($fields['id_currency'])) {
         $criteria->add(WarehouseEntranceClaimReport::ID_CURRENCY, $fields['id_currency']);
     }
     if (isset($fields['status']) && !empty($fields['status'])) {
         $criteria->add(WarehouseEntranceClaimReport::STATUS, $fields['status']);
     }
     if (isset($fields['comments']) && !empty($fields['comments'])) {
         $criteria->add(WarehouseEntranceClaimReport::COMMENTS, $fields['comments']);
     }
     if (isset($fields['reception_date']) && !empty($fields['reception_date'])) {
         $criteria->add(WarehouseEntranceClaimReport::RECEPTION_DATE, $fields['reception_date']);
     }
     if (isset($fields['doc_entry']) && !empty($fields['doc_entry'])) {
         $criteria->add(WarehouseEntranceClaimReport::DOC_ENTRY, $fields['doc_entry']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'TemporalSupplier')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['id_temporal_supplier']) && !empty($fields['id_temporal_supplier'])) {
         $criteria->add(TemporalSupplier::ID_TEMPORAL_SUPPLIER, $fields['id_temporal_supplier']);
     }
     if (isset($fields['id_temporal_sap']) && !empty($fields['id_temporal_sap'])) {
         $criteria->add(TemporalSupplier::ID_TEMPORAL_SAP, $fields['id_temporal_sap']);
     }
     if (isset($fields['name']) && !empty($fields['name'])) {
         $criteria->add(TemporalSupplier::NAME, $fields['name']);
     }
     if (isset($fields['id_currency']) && !empty($fields['id_currency'])) {
         $criteria->add(TemporalSupplier::ID_CURRENCY, $fields['id_currency']);
     }
     if (isset($fields['contact']) && !empty($fields['contact'])) {
         $criteria->add(TemporalSupplier::CONTACT, $fields['contact']);
     }
     if (isset($fields['telephone']) && !empty($fields['telephone'])) {
         $criteria->add(TemporalSupplier::TELEPHONE, $fields['telephone']);
     }
     if (isset($fields['status']) && !empty($fields['status'])) {
         $criteria->add(TemporalSupplier::STATUS, $fields['status']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'File')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['id_file']) && !empty($fields['id_file'])) {
         $criteria->add(File::ID_FILE, $fields['id_file']);
     }
     if (isset($fields['type']) && !empty($fields['type'])) {
         $criteria->add(File::TYPE, $fields['type']);
     }
     if (isset($fields['content']) && !empty($fields['content'])) {
         $criteria->add(File::CONTENT, $fields['content']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'ProformaInvoiceEntry')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['id_proforma_invoice_entry']) && !empty($fields['id_proforma_invoice_entry'])) {
         $criteria->add(ProformaInvoiceEntry::ID_PROFORMA_INVOICE_ENTRY, $fields['id_proforma_invoice_entry']);
     }
     if (isset($fields['id_proforma_invoice']) && !empty($fields['id_proforma_invoice'])) {
         $criteria->add(ProformaInvoiceEntry::ID_PROFORMA_INVOICE, $fields['id_proforma_invoice']);
     }
     if (isset($fields['line']) && !empty($fields['line'])) {
         $criteria->add(ProformaInvoiceEntry::LINE, $fields['line']);
     }
     if (isset($fields['vis_order']) && !empty($fields['vis_order'])) {
         $criteria->add(ProformaInvoiceEntry::VIS_ORDER, $fields['vis_order']);
     }
     if (isset($fields['tax_code']) && !empty($fields['tax_code'])) {
         $criteria->add(ProformaInvoiceEntry::TAX_CODE, $fields['tax_code']);
     }
     if (isset($fields['id_product']) && !empty($fields['id_product'])) {
         $criteria->add(ProformaInvoiceEntry::ID_PRODUCT, $fields['id_product']);
     }
     if (isset($fields['quantity']) && !empty($fields['quantity'])) {
         $criteria->add(ProformaInvoiceEntry::QUANTITY, $fields['quantity']);
     }
     if (isset($fields['open_quantity']) && !empty($fields['open_quantity'])) {
         $criteria->add(ProformaInvoiceEntry::OPEN_QUANTITY, $fields['open_quantity']);
     }
     if (isset($fields['price']) && !empty($fields['price'])) {
         $criteria->add(ProformaInvoiceEntry::PRICE, $fields['price']);
     }
     if (isset($fields['currency']) && !empty($fields['currency'])) {
         $criteria->add(ProformaInvoiceEntry::CURRENCY, $fields['currency']);
     }
     if (isset($fields['id_warehouse_store']) && !empty($fields['id_warehouse_store'])) {
         $criteria->add(ProformaInvoiceEntry::ID_WAREHOUSE_STORE, $fields['id_warehouse_store']);
     }
     if (isset($fields['lead_time']) && !empty($fields['lead_time'])) {
         $criteria->add(ProformaInvoiceEntry::LEAD_TIME, $fields['lead_time']);
     }
     if (isset($fields['status']) && !empty($fields['status'])) {
         $criteria->add(ProformaInvoiceEntry::STATUS, $fields['status']);
     }
     if (isset($fields['line_status']) && !empty($fields['line_status'])) {
         $criteria->add(ProformaInvoiceEntry::LINE_STATUS, $fields['line_status']);
     }
     if (isset($fields['requisition_ids']) && !empty($fields['requisition_ids'])) {
         $criteria->add(ProformaInvoiceEntry::REQUISITION_IDS, $fields['requisition_ids']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'ProformaInvoiceFile')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['id_proforma_invoice_file']) && !empty($fields['id_proforma_invoice_file'])) {
         $criteria->add(ProformaInvoiceFile::ID_PROFORMA_INVOICE_FILE, $fields['id_proforma_invoice_file']);
     }
     if (isset($fields['id_file']) && !empty($fields['id_file'])) {
         $criteria->add(ProformaInvoiceFile::ID_FILE, $fields['id_file']);
     }
     if (isset($fields['id_proforma_invoice']) && !empty($fields['id_proforma_invoice'])) {
         $criteria->add(ProformaInvoiceFile::ID_PROFORMA_INVOICE, $fields['id_proforma_invoice']);
     }
     if (isset($fields['type']) && !empty($fields['type'])) {
         $criteria->add(ProformaInvoiceFile::TYPE, $fields['type']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'OCRD')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['CardCode']) && !empty($fields['CardCode'])) {
         $criteria->add(SapSupplier::CARDCODE, $fields['CardCode']);
     }
     if (isset($fields['Cardname']) && !empty($fields['Cardname'])) {
         $criteria->add(SapSupplier::CARDNAME, $fields['Cardname']);
     }
     if (isset($fields['GroupCode']) && !empty($fields['GroupCode'])) {
         $criteria->add(SapSupplier::GROUPCODE, $fields['GroupCode']);
     }
     if (isset($fields['LicTradNum']) && !empty($fields['LicTradNum'])) {
         $criteria->add(SapSupplier::LICTRADNUM, $fields['LicTradNum']);
     }
     if (isset($fields['CmpPrivate']) && !empty($fields['CmpPrivate'])) {
         $criteria->add(SapSupplier::CMPPRIVATE, $fields['CmpPrivate']);
     }
     if (isset($fields['Groupnum']) && !empty($fields['Groupnum'])) {
         $criteria->add(SapSupplier::GROUPNUM, $fields['Groupnum']);
     }
     if (isset($fields['CardType']) && !empty($fields['CardType'])) {
         $criteria->add(SapSupplier::CARDTYPE, $fields['CardType']);
     }
     if (isset($fields['frozenFor']) && !empty($fields['frozenFor'])) {
         $criteria->add(SapSupplier::FROZEN_FOR, $fields['frozenFor']);
     }
     if (isset($fields['validFor']) && !empty($fields['validFor'])) {
         $criteria->add(SapSupplier::VALID_FOR, $fields['validFor']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'PriceListLog')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['id_price_list_log']) && !empty($fields['id_price_list_log'])) {
         $criteria->add(PriceListLog::ID_PRICE_LIST_LOG, $fields['id_price_list_log']);
     }
     if (isset($fields['id_price_list']) && !empty($fields['id_price_list'])) {
         $criteria->add(PriceListLog::ID_PRICE_LIST, $fields['id_price_list']);
     }
     if (isset($fields['id_user']) && !empty($fields['id_user'])) {
         $criteria->add(PriceListLog::ID_USER, $fields['id_user']);
     }
     if (isset($fields['date']) && !empty($fields['date'])) {
         $criteria->add(PriceListLog::DATE, $fields['date']);
     }
     if (isset($fields['event_type']) && !empty($fields['event_type'])) {
         $criteria->add(PriceListLog::EVENT_TYPE, $fields['event_type']);
     }
     $criteria->endPrefix();
 }

 /**
  * build fromArray
  * @param Query $query
  * @param array $fields
  * @param string $prefix
  */
 public static function build(Query $query, $fields, $prefix = 'WarehouseEntranceQuarantineRecoveryDeadline')
 {
     $criteria = $query->where();
     $criteria->prefix($prefix);
     if (isset($fields['id_warehouse_entrance_quarantine_recovery_deadline']) && !empty($fields['id_warehouse_entrance_quarantine_recovery_deadline'])) {
         $criteria->add(WarehouseEntranceQuarantineRecoveryDeadline::ID_WAREHOUSE_ENTRANCE_QUARANTINE_RECOVERY_DEADLINE, $fields['id_warehouse_entrance_quarantine_recovery_deadline']);
     }
     if (isset($fields['id_warehouse_entry']) && !empty($fields['id_warehouse_entry'])) {
         $criteria->add(WarehouseEntranceQuarantineRecoveryDeadline::ID_WAREHOUSE_ENTRANCE, $fields['id_warehouse_entry']);
     }
     if (isset($fields['id_warehouse_entry_line']) && !empty($fields['id_warehouse_entry_line'])) {
         $criteria->add(WarehouseEntranceQuarantineRecoveryDeadline::ID_WAREHOUSE_ENTRANCE_LINE, $fields['id_warehouse_entry_line']);
     }
     if (isset($fields['recovery_deadline']) && !empty($fields['recovery_deadline'])) {
         $criteria->add(WarehouseEntranceQuarantineRecoveryDeadline::RECOVERY_DEADLINE, $fields['recovery_deadline']);
     }
     $criteria->endPrefix();
 }