/pos/is4c/fannie/batches/addItems.php

https://github.com/maxolasersquad/FLOSS-POS · PHP · 93 lines · 73 code · 15 blank · 5 comment · 8 complexity · 45aa418921407937c7b644a8bb476b69 MD5 · raw file 

    

  1. <html>

    2. 

  2. <head>

    3. 

  3. <link rel="stylesheet" href="../style.css" type="text/css" />

    4. 

  4. </head>

    5. 

  5. <body>

    6. 

  6. <?

    7. 

  7. include_once('../src/funct1Mem.php');

    8. 

  8. 

    9. 

  9. foreach ($_POST AS $key => $value) {

    10. 

  10.     $$key = $value;

    11. 

  11.     //echo $key . ': '. $$key . "<br>";

    12. 

  12. }

    13. 

  13. 

    14. 

  14. $db = mysql_connect('localhost','root');

    15. 

  15. mysql_select_db('is4c_op',$db);

    16. 

  16. 

    17. 

  17. $maxBatchIDQ = "SELECT MAX(batchID) FROM batches";

    18. 

  18. $maxBatchIDR = mysql_query($maxBatchIDQ);

    19. 

  19. $maxBatchIDW = mysql_fetch_array($maxBatchIDR);

    20. 

  20. 

    21. 

  21. $batchID = $maxBatchIDW[0];

    22. 

  22. 

    23. 

  23. $batchInfoQ = "SELECT * FROM batches WHERE batchID = $batchID";

    24. 

  24. $batchInfoR = mysql_query($batchInfoQ);

    25. 

  25. $batchInfoW = mysql_fetch_row($batchInfoR);

    26. 

  26.  

    27. 

  27. //$batchID = 1;

    28. 

  28. if(isset($_GET['batchID'])){

    29. 

  29.    $batchID = $_GET['batchID'];

    30. 

  30. }

    31. 

  31. 

    32. 

  32. if(isset($_GET['submit'])){

    33. 

  33.    $upc = $upc =str_pad($_GET['upc'],13,0,STR_PAD_LEFT);

    34. 

  34.    $salePrice = $_GET['saleprice'];

    35. 

  35.    if(isset($_GET['delete'])){

    36. 

  36.       $del = $_GET['delete'];

    37. 

  37.    }

    38. 

  38.    ;

    39. 

  39. ?>   <script language="javascript">

    40. 

  40.     parent.frames[1].location.reload();

    41. 

  41.     </script>

    42. 

  42. <?

    43. 

  43. } else {

    44. 

  44. 	$upc = '';

    45. 

  45. 	$salePrice = '';

    46. 

  46. 	$del = 0;

    47. 

  47. }

    48. 

  48. 

    49. 

  49. 

    50. 

  50. echo "<form action=addItems.php action=GET>";

    51. 

  51. echo "<table border=0><tr><td><b>Sale Price: </b><input type=text name=saleprice size=6></td>";

    52. 

  52. echo "<td><b>UPC: </b><input type=text name=upc></td>";

    53. 

  53. echo "<input type=hidden name=batchID value=$batchID>";

    54. 

  54. echo "<td><b>Delete</b><input type=checkbox name=delete value=1>";

    55. 

  55. echo "<td><input type=submit name=submit value=submit></td></tr></table>";

    56. 

  56. 

    57. 

  57. //echo "this is upc" . $upc;

    58. 

  58. 

    59. 

  59. $selBListQ = "SELECT * FROM batchList WHERE upc = $upc 

    60. 

  60.               AND batchID = $batchID";

    61. 

  61. $selBListR = mysql_query($selBListQ);

    62. 

  62. $selBListN = mysql_num_rows($selBListR);

    63. 

  63. 

    64. 

  64. $startDate = $batchInfoW[1];

    65. 

  65. $endDate = $batchInfoW[2];

    66. 

  66. 

    67. 

  67. $checkItemQ = "SELECT l.* FROM batchList AS l JOIN batches AS b ON b.batchID = l.batchID

    68. 

  68.                where upc = $upc and b.endDate >= '$startDate'";

    69. 

  69. $checkItemR = mysql_query($checkItemQ);

    70. 

  70. $checkItemN = mysql_num_rows($checkItemR);

    71. 

  71. $checkItemW = mysql_fetch_row($checkItemR);

    72. 

  72. 

    73. 

  73. 

    74. 

  74. if($del == 1){

    75. 

  75.    $delBListQ = "DELETE FROM batchList WHERE upc = $upc AND

    76. 

  76.                 batchID = $batchID";

    77. 

  77.    $delBListR = mysql_query($delBListQ);

    78. 

  78. }else{

    79. 

  79.       if($selBListN == 0){

    80. 

  80.          $insBItemQ = "INSERT INTO batchList(upc,batchID,salePrice)

    81. 

  81.                    VALUES('$upc',$batchID,$salePrice)";

    82. 

  82.          //echo $insBItemQ;

    83. 

  83.          $insBItemR = mysql_query($insBItemQ);

    84. 

  84.       }else{

    85. 

  85.          $upBItemQ = "UPDATE batchList SET salePrice=$salePrice WHERE upc = '$upc' 

    86. 

  86.                    AND batchID = $batchID";

    87. 

  87.          //echo $upBItemQ;

    88. 

  88.          $upBItemR = mysql_query($upBItemQ);

    89. 

  89.       }

    90. 

  90. }

    91. 

  91. ?>

    92. 

  92. </body>

    93. 

  93. </html>
    94.