"; echo "

Debug Information

"; echo "

Working List ID: " . ($workinglistid ? $workinglistid : 'Not found') . "

"; echo "

Auto-populate: " . ($autopopulate ? 'Yes' : 'No') . "

"; if ($workinglistid && $autopopulate) { echo "

Auto-populate starting for workinglistid=$workinglistid

"; $singleCopyResult = false; $singleCount = 0; $sql = "INSERT INTO supplier_prices_workingdb (workinglistid, hostcompanyid, companyid, stkref, breakqty, price, currencyid, status) SELECT ?, ?, ?, stock_ref, 1, rawprice, CASE WHEN currenyid > 0 THEN currenyid ELSE 1 END, status FROM viamed_customer_stock_references WHERE companyid = ? AND status = '2'"; try { $stmt = pdoquery($sql, array($workinglistid, $hostcompanyid, $companyid, $companyid)); $singleCopyResult = ($stmt !== false); $singleCount = $stmt->rowCount(); } catch (Exception $e) { echo "

Error copying single prices: " . $e->getMessage() . "

"; $singleCopyResult = false; } echo "

Single prices: " . $singleCopyResult . " (estimated rows: " . $singleCount . ")

"; $breaksCopyResult = false; $breaksCount = 0; $sql = "INSERT INTO supplier_prices_workingdb (workinglistid, hostcompanyid, companyid, stkref, breakqty, price, currencyid, status) SELECT ?, ?, ?, stkref, breakqty, price, currencyid, status FROM viamedquote_orders_price_breaks WHERE hostcompanyid = ? AND companyid = ?"; try { $stmt = pdoquery($sql, array($workinglistid, $hostcompanyid, $companyid, $hostcompanyid, $companyid)); $breaksCopyResult = ($stmt !== false); $breaksCount = $stmt->rowCount(); } catch (Exception $e) { echo "

Error copying price breaks: " . $e->getMessage() . "

"; $breaksCopyResult = false; } echo "

Price breaks: " . $breaksCopyResult . " (estimated rows: " . $breaksCount . ")

"; echo "

Auto-populate result: " . ($singleCopyResult && $breaksCopyResult ? 'Success' : 'Partial/Failed') . "

"; } else { echo "

Auto-populate NOT executed (autopopulate value: " . $autopopulate . ")

"; } echo "

Continue to Details Page

"; echo "