File: //tmp/purchase_order_no_refs.txt
custom/Extension/modules/Schedulers/Ext/ScheduledTasks/TaskArchive/create_purchase_order.php:27: (`id`, `name`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `deleted`, `assigned_user_id`, `invoice_id`, `po_date`, `delivery_method`, `purchase_order_no` ) VALUES
custom/Extension/modules/Schedulers/Ext/ScheduledTasks/TaskArchive/create_purchase_order.php:51: WHERE spo.deleted = 0 AND spo.date_entered > '2022-12-08' AND alig.deleted = 0 AND spo.po_status = 'hold' AND spo.purchase_order_no = 'autoCreate'
custom/Extension/modules/Schedulers/Ext/ScheduledTasks/TaskArchive/create_purchase_order.php:100: WHERE apq.deleted = 0 AND spo.deleted = 0 AND spo.date_entered > '2022-12-08' AND alig.date_entered > DATE_SUB(Now(), INTERVAL 30 MINUTE) AND spo.purchase_order_no = 'autoCreate'
custom/Extension/modules/Schedulers/Ext/ScheduledTasks/TaskArchive/create_purchase_order.php:197: SET purchase_order_no = NULL, date_modified = Now()
custom/Extension/modules/Schedulers/Ext/ScheduledTasks/TaskArchive/create_purchase_order.php:198: WHERE deleted = 0 AND purchase_order_no = 'autoCreate'";
custom/modules/AOS_Invoices/createPOFromInvoiceLogicHook.php:84: * - purchase_order_no = 'autoCreate' (marker)
custom/modules/AOS_Invoices/createPOFromInvoiceLogicHook.php:92: assigned_user_id, invoice_id, po_date, po_date_received, po_status, delivery_method, purchase_order_no)
custom/modules/AOS_Invoices/createPOFromInvoiceLogicHook.php:310: SET purchase_order_no = NULL,
custom/modules/AOS_Invoices/createPOFromInvoiceLogicHook.php:314: AND purchase_order_no = 'autoCreate'
custom/modules/spg_purchase_orders/metadata/searchdefs.php:77: 'purchase_order_no' =>
custom/modules/spg_purchase_orders/metadata/searchdefs.php:83: 'name' => 'purchase_order_no',
custom/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/searchdefs.php:68: 'purchase_order_no' =>
custom/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/searchdefs.php:74: 'name' => 'purchase_order_no',
custom/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/editviewdefs.php:48: 'name' => 'purchase_order_no',
custom/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/detailviewdefs.php:70: 'name' => 'purchase_order_no',
custom/modules/spg_purchase_orders/metadata/editviewdefs.php:48: 'name' => 'purchase_order_no',
custom/modules/spg_purchase_orders/metadata/detailviewdefs.php:70: 'name' => 'purchase_order_no',
custom/modules/spg_purchase_orders/QBBillsIntegration.php:77: "DocNumber" => $bean->purchase_order_no,
custom/modules/Schedulers/Jobs/ProcessPoPdfParseQueue.php:287: $sets[] = "purchase_order_no = '".$db->quote($invoiceNo)."'";
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1765227440:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1629210734:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1602622388:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1563385054:74: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1629210747:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1630091463:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1630091463:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/editviewdefs.php_1681242123:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/detailviewdefs.php_1681242266:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/detailviewdefs.php_1681242123:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/editviewdefs.php_1681242266:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1563994664:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1633641573:68: 'purchase_order_no' =>
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1633641573:74: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1630091327:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1630091327:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1630093419:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1764977264:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1637356065:77: 'purchase_order_no' =>
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1637356065:83: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1637355998:68: 'purchase_order_no' =>
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1637355998:74: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1563385054:52: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1630093419:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1765227184:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1765227491:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1594308865:68: 'purchase_order_no' =>
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1594308865:74: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1594741233:68: 'purchase_order_no' =>
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1594741233:74: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1765227225:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1765227184:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1602622651:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1680209797:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1563994713:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1563994664:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1602622388:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1563994713:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1765227517:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1630091115:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1632034484:68: 'purchase_order_no' =>
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1632034484:74: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1650559213:77: 'purchase_order_no' =>
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1650559213:83: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1602622651:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1629210734:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1664318619:77: 'purchase_order_no' =>
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1664318619:83: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1594740665:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1594741440:68: 'purchase_order_no' =>
custom/history/modules/spg_purchase_orders/metadata/searchdefs.php_1594741440:74: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1690208108:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1594740665:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1680209797:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1765227517:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1765227225:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1765227491:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1690208108:48: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1630091115:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1629210747:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/detailviewdefs.php_1765227440:70: 'name' => 'purchase_order_no',
custom/history/modules/spg_purchase_orders/metadata/editviewdefs.php_1764977264:48: 'name' => 'purchase_order_no',
modules/spg_purchase_orders/metadata/editviewdefs.php:52: 'name' => 'purchase_order_no',
modules/spg_purchase_orders/metadata/detailviewdefs.php:74: 'name' => 'purchase_order_no',
modules/spg_purchase_orders/vardefs.php:47: 'purchase_order_no' =>
modules/spg_purchase_orders/vardefs.php:50: 'name' => 'purchase_order_no',
modules/spg_purchase_orders/spg_purchase_orders.php:69: public $purchase_order_no;
modules/spg_purchase_orders/spg_purchase_orders.php:98: // $this->number = $this->db->getOne("SELECT MAX(CAST(purchase_order_no as INT))+1 FROM spg_purchase_orders");
modules/spg_purchase_orders/spg_purchase_orders.php:100: // $this->number = $this->db->getOne("SELECT MAX(CAST(purchase_order_no as UNSIGNED))+1 FROM spg_purchase_orders");
modules/Extension/modules/Schedulers/Ext/ScheduledTasks/TaskArchive/create_purchase_order.php:27: (`id`, `name`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `deleted`, `assigned_user_id`, `invoice_id`, `po_date`, `delivery_method`, `purchase_order_no` ) VALUES
modules/Extension/modules/Schedulers/Ext/ScheduledTasks/TaskArchive/create_purchase_order.php:51: WHERE spo.deleted = 0 AND spo.date_entered > '2022-12-08' AND alig.deleted = 0 AND spo.po_status = 'hold' AND spo.purchase_order_no = 'autoCreate'
modules/Extension/modules/Schedulers/Ext/ScheduledTasks/TaskArchive/create_purchase_order.php:100: WHERE apq.deleted = 0 AND spo.deleted = 0 AND spo.date_entered > '2022-12-08' AND alig.date_entered > DATE_SUB(Now(), INTERVAL 30 MINUTE) AND spo.purchase_order_no = 'autoCreate'
modules/Extension/modules/Schedulers/Ext/ScheduledTasks/TaskArchive/create_purchase_order.php:197: SET purchase_order_no = NULL, date_modified = Now()
modules/Extension/modules/Schedulers/Ext/ScheduledTasks/TaskArchive/create_purchase_order.php:198: WHERE deleted = 0 AND purchase_order_no = 'autoCreate'";
modules/modules/AOS_Invoices/createPOFromInvoiceLogicHook.php:84: * - purchase_order_no = 'autoCreate' (marker)
modules/modules/AOS_Invoices/createPOFromInvoiceLogicHook.php:92: assigned_user_id, invoice_id, po_date, po_date_received, po_status, delivery_method, purchase_order_no)
modules/modules/AOS_Invoices/createPOFromInvoiceLogicHook.php:310: SET purchase_order_no = NULL,
modules/modules/AOS_Invoices/createPOFromInvoiceLogicHook.php:314: AND purchase_order_no = 'autoCreate'
modules/modules/spg_purchase_orders/metadata/searchdefs.php:77: 'purchase_order_no' =>
modules/modules/spg_purchase_orders/metadata/searchdefs.php:83: 'name' => 'purchase_order_no',
modules/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/searchdefs.php:68: 'purchase_order_no' =>
modules/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/searchdefs.php:74: 'name' => 'purchase_order_no',
modules/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/editviewdefs.php:48: 'name' => 'purchase_order_no',
modules/modules/spg_purchase_orders/metadata/110f7ff7-2a1c-bfbf-5151-5cfc4b8613ef/detailviewdefs.php:70: 'name' => 'purchase_order_no',
modules/modules/spg_purchase_orders/metadata/editviewdefs.php:48: 'name' => 'purchase_order_no',
modules/modules/spg_purchase_orders/metadata/detailviewdefs.php:70: 'name' => 'purchase_order_no',
modules/modules/spg_purchase_orders/QBBillsIntegration.php:77: "DocNumber" => $bean->purchase_order_no,