colonymech / docs / www / colonyscout / internal / inventory_add_csv.php @ f59acf11
History | View | Annotate | Download (1.32 KB)
1 | f59acf11 | Dan Shope | <?php
|
---|---|---|---|
2 | |||
3 | include_once(getenv("DOCUMENT_ROOT")."/internal/do_login.php"); |
||
4 | include_once("inventoryFunctions.php"); |
||
5 | doDB("colony_scout");
|
||
6 | |||
7 | //temp script to parse output from the unified EE BOM (ONLY)
|
||
8 | |||
9 | $row = 1; |
||
10 | if (($handle = fopen("eeBOM.csv", "r")) !== FALSE) { |
||
11 | while (($d= fgetcsv($handle, 1000, ",")) !== FALSE) { |
||
12 | |||
13 | $vendorID = getVendorID($d[5]); |
||
14 | if($vendorID==-1) { |
||
15 | $vendorID = getVendorID("Unknown"); //placeholder |
||
16 | } |
||
17 | |||
18 | for ($c=11; $c < 16; $c++) { |
||
19 | if($d[$c]==""){ |
||
20 | $d[$c]=0; |
||
21 | } |
||
22 | } |
||
23 | |||
24 | $add_item_sql = "INSERT INTO inventory (name,manufacturername,manufacturerpartno,dateadded,active, |
||
25 | tags,qty,vendorid,vendorpartno,cost_1,cost_10,cost_25,cost_50,cost_100,description)
|
||
26 | VALUES ('".$d[2]."','".$d[1]."','".$d[3]."',now(),true,'".$d[0]."',".$d[16].",".$vendorID.",'". |
||
27 | $d[6]."',".$d[11].",".$d[12].",".$d[13].",".$d[14].",".$d[15].",'".$d[4]."');"; |
||
28 | |||
29 | echo $add_item_sql."<br/><br/>"; |
||
30 | |||
31 | $add_item_res = mysqli_query($mysqli, $add_item_sql) or die(mysqli_error($mysqli)); |
||
32 | } |
||
33 | fclose($handle); |
||
34 | } |
||
35 | |||
36 | //close connection to MySQL
|
||
37 | mysqli_close($mysqli);
|
||
38 | |||
39 | /* column order
|
||
40 | 0 - tags
|
||
41 | 1 - manufact
|
||
42 | 2 - part name
|
||
43 | 3 - manufact num
|
||
44 | 4 - description
|
||
45 | 5 - Look up in vendor table
|
||
46 | 6 - vendor part num
|
||
47 | 11 - price/1
|
||
48 | 12 - price/10
|
||
49 | 13 - price/25
|
||
50 | 14 - price/50
|
||
51 | 15 - price/100
|
||
52 | 16 - qty
|
||
53 |
|
||
54 | header("Location:/index/");
|
||
55 | |||
56 | */
|
||
57 | ?> |