$orderRows = array(); // grab the packages $sql = "\n\tSELECT \n\t\t distinct p.package_id\n\t\t, p.customer_id\n\tFROM \n\t\tpackages p\n\t\tjoin packages_orders po on po.package_id = p.package_id\n\t\tjoin orders o on o.order_id = po.order_id\n\tWHERE \n\t\tp.sent is null\n\t\tand p.fulfillment_id = ?i\n\t\tAND FIND_IN_SET('test', `o`.`flags`)=0 "; $packages = $msql->getInd('package_id', $sql, $fulfillmentModel->fulfillment_id); foreach ($packages as $p) { $package = new Package(); $package->loadFullPackage($p['package_id']); $orderRows = array_merge($orderRows, $package->getPackageCustom($fulfillmentModel, $firstRow)); unset($package); $firstRow = false; } //var_dump($orderRows); exit; if (!$orderRows) { continue; } $filePath = Csv::saveCsvCustom($orderRows, $fulfillmentModel); echo $filePath . '<br>'; // do we need to zip the file? if ($fulfillmentModel->fulfillment_zip) { $phpFilePath = AF::path('zip', array('files', 'csv')); $fp = AF::path('', array('files', 'csv')); system('/usr/bin/php-cli ' . $phpFilePath . ' ' . $fulfillmentModel->csvFileName . ' ' . $fp . ' > /home/pinnacle/er4.txt'); $filePath = $fp . $fulfillmentModel->csvFileName . '.zip'; echo $filePath . '<br>'; } // M.Scully - disabled this by passing ?test in the url if (!isset($_GET['test'])) { $fulfillmentModel->filePath = $filePath; if ($fulfillmentModel->uploadToFulfillment()) { foreach ($packages as $p) { $package = new Package();