Search options

# Any line where the first character is a hash is a comment
# FA-ITEM-CODE,QUANTITY,TOTAL PRICE
ITEM0001,2,7.00
ITEM0002,1,2.45

# Any line where the first character is a hash is a comment
# FA-ITEM-CODE,QUANTITY,TOTAL PRICE
ITEM0001,1,3.00
ITEM0001,1,4.00
ITEM0002,1,2.45

        $cancelorder = _("Cancel Order");
        $porder = _("Place Order");
        $corder = _("Commit Order Changes");
}
start_form();

hidden('cart_id');
$customer_error = display_order_header($_SESSION['Items'],
        ($_SESSION['Items']->any_already_delivered() == 0), $idate);

        $cancelorder = _("Cancel Order");
        $porder = _("Place Order");
        $corder = _("Commit Order Changes");
}

// Add the import CSV file
include_once($path_to_root . "/sales/includes/ui/import_csv_ui.inc");

start_form();

hidden('cart_id');
$customer_error = display_order_header($_SESSION['Items'],
        ($_SESSION['Items']->any_already_delivered() == 0), $idate);

<?php
/**********************************************************************
    Author: arad85
        Released under the terms of the GNU General Public License, GPL,
        as published by the Free Software Foundation, either version 3
        of the License, or (at your option) any later version.
    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
if (isset($_POST['ImportFile'])) {
  if (isset($_FILES['imp']) && ($_FILES['imp']['name'] != ''))
    {
      $filename = $_FILES['imp']['tmp_name'];
      $fp = @fopen($filename, "r");
      if (!$fp)
        {
          display_error("Error opening file $filename");
        } else
        {
          while ($data = fgetcsv($fp))
            {
              // Skip blank lines
              if (count($data) == 1) continue;

              // Skip lines beginning with a # - comment lines
              if ($data[0][0] == "#") continue;

              // Parse the row of data; Format: stock_id, quantity, price
              list($stock_id, $quantity, $price) = $data;

              // Is this actually an item or not?
              $item = db_fetch(get_item_kit($stock_id));

              // if not, report an error and move to the next line
              if (empty($item))
                {
                  display_error(_("ERROR: item ").$stock_id. " "
                                  . _("does not exist in the inventory database. Please check your import file"));
                  continue;
                }

              // Convert price to a units price rather than total value
              $price = round(($price/$quantity), 2);

              // Find out what we should be selling this for
              $std_price = get_kit_price($stock_id, $_SESSION['Items']->customer_currency,
                $_SESSION['Items']->sales_type, $_SESSION['Items']->price_factor, get_post('OrderDate'), true);

              // If we don't have a price set, just assume sales price = actual price
              if ($std_price == 0)
                $std_price = $price;

              // Calculate the discount
              $discount = round(($std_price - $price) / $std_price, 3);

              // And add the item to the order
              add_to_order($_SESSION['Items'], $stock_id, $quantity, $std_price, $discount);
            }
        }

      @fclose($fp);

      page_modified();
      line_start_focus();
    }

    else
      display_error("No file selected for import");
}

//- Add the import box here
start_form(true);
start_table(TABLESTYLE2, "width=80%");
echo "<tr><td colspan=3 align='center' class='label'><b>Import CSV file</b></td></tr>";
label_cells("File to import:", "<input type='file' id='imp' name='imp'>", "class='label'");
submit_cells('ImportFile', _("Perform Import"), "align='center' valign='bottom'", _('Import CSV file of sales'));
end_table(1);
end_form();

?>