Esempio n. 1
0
 function makeSell()
 {
     $date = "{$_POST['date']} 02:02:02";
     db("insert into sell (vendorIndex,vendor,memoNo,rawPrice,extraCost,extraCostDescr,shippingCost,commission,discount,totalPrice,paid,due,date,currDue,sellType) \n\t\t\tvalues ('{$this->clientIndex}','client','{$this->memoNo}','{$this->rawPrice}','{$this->extraCost}','{$this->extraCostDescr}','{$this->shippingCost}','{$this->commission}','{$this->discount}','{$this->totalPrice}','{$this->paid}','{$this->due}','{$date}','{$this->currDue}','clientPurchase')");
     for ($index = 0; $index < $this->productList; $index++) {
         $product = $this->product[$index];
         db("insert into sell_log\n\t\t\t(memoNo,pid,descr,qty,sp,cpDoz,date) values ('{$this->memoNo}','{$product->pid}','{$product->descr}','{$product->qty}','{$product->sp}','{$product->cpDoz}','{$date}')");
         Inventory::remove($product);
     }
 }
Esempio n. 2
0
 function makePurchaseReturn()
 {
     $date = "{$_POST['date']} 02:02:02";
     $this->purchaseType = "factoryReturn";
     //insert into sell and sellLog
     //vendorType = [factory, factory, staff, bank, addition]
     //
     //do this in distraction free mode shift+f11
     //first field name, then field value, type both at once first
     db("insert into purchase\n\t\t\t(vendorIndex,vendor,memoNo,rawPrice,paid,due,date,purchaseType)\n\t\t\tvalues\n\t\t\t('{$this->factoryIndex}','factory','{$this->memoNo}','{$this->rawPrice}','{$this->paid}','{$this->due}','{$date}','{$this->purchaseType}')\n\t\t\t");
     for ($index = 0; $index < $this->productList; $index++) {
         $product = $this->product[$index];
         //echo "('$this->memoNo','$product->pid','$product->descr','$product->qty','$product->sp','$product->cpDoz')";
         db("insert into purchase_log\n\t\t\t\t(memoNo,pid,descr,qty,sp,cpDoz,date)\n\t\t\t\tvalues\n\t\t\t\t('{$this->memoNo}','{$product->pid}','{$product->descr}','{$product->qty}','{$product->sp}','{$product->cpDoz}','{$date}')\n\t\t\t\t");
         Inventory::remove($product);
     }
 }