public function createAddPart()
{
if (isset($_POST['itemid']) && !empty($_POST['wid'])) {
$worksheet = Worksheet::find_by_id($_POST['wid']);
$myItem = Items::find_by_id($_POST['itemid']);
$propart = new Prodpart();
$propart->part_name = $myItem->item_name;
$propart->qty = $_POST['qty'];
$propart->works_id = $_POST['wid'];
$propart->prod_id = $worksheet->prod_id;
$propart->item_id = $_POST['itemid'];
$propart->date_changed = date("Y:m:d H:i:s");
$propart->desc = "";
$propart->unit_cost = $_POST['price'];
$propart->total_cost = (int) $_POST['price'] * (int) $_POST['qty'];
if ($propart->create()) {
return $propart;
} else {
return false;
}
}
}
public function createAddPart()
{
if (isset($_REQUEST['itemid']) && !empty($_REQUEST['wid'])) {
$worksheet = Worksheet::find_by_id($_REQUEST['wid']);
$myItem = Items::find_by_id($_REQUEST['itemid']);
$propart = new Prodpart();
$propart->part_name = $myItem->item_name;
$propart->qty = $_REQUEST['qty'];
$propart->works_id = $_REQUEST['wid'];
$propart->prod_id = $worksheet->prod_id;
$propart->item_id = $_REQUEST['itemid'];
$propart->datecreated = date("Y:m:d H:i:s");
$propart->des = "";
$propart->unit_cost = $_REQUEST['price'];
$propart->total_cost = (int) $_REQUEST['price'] * (int) $_REQUEST['qty'];
$Tlog = new Transaction();
$Tlog->com_id = $myItem->item_id;
$Tlog->trans_type = "WORKSHEET PART SUPPLY";
$Tlog->trans_description = "allocation of resources to worksheet";
$Tlog->datecreated = date("Y-m-d H:i:s");
$Tlog->user_id = $_SESSION['emp_ident'];
if ($propart->create()) {
$Tlog->create();
return $propart;
} else {
return false;
}
}
}
/**
* cart model to maitain items array
* in cart befor it is been posted to
* the purchases table
*/
public function doAddToCart()
{
$basket = new Cart();
$mcart = "";
$basket->addItem($_POST['ppid'], $_POST['ppname'], $_POST['pcatname'], $_POST['pqty'], $_POST['pprice']);
$myItems = $basket->getContents();
// the basket get arrays of items in the cart
$quantity = $_POST['pqty'];
$subTotal = $basket->getTotal();
// the basket gets the total of the items as subtotal
$vat = 0.05 * $subTotal;
// calculates the vat
$total = $subTotal + $vat;
$mcart .= "<table id='minicart-a' summary='Employee Pay Sheet'>\n <thead>\n \t<tr>\n <th width='10%' scope='col'>ItemID</th>\n \t<th width='35%' scope='col' >Description</th>\n <th width='20%' scope='col'>Qty</th>\n <th width='10%' scope='col'>Cost</th>\n <th width='10%' scope='col'>Total</th>\n \n </tr>\n </thead>\n <tbody>";
//print_r($item['itemName']);
$qt = 0;
foreach ($myItems as $item) {
$myproduct = Items::find_by_id($item['itemId']);
//print_r($myproduct);
$mcart .= "<tr>\n \n <td>" . $item['itemName'] . "</td>\n <td>" . $myproduct->item_description . "</td>\n <td><span>\n <input type='text' name='qty' id='qty" . $qt . "' value='" . $item['itemQuantity'] . "' style='width:40px; padding:2px; height:36px; text-align:center; ' />\n </span> <span><a href='#' class='modifyqty' prodid='" . $item['itemId'] . "' prodqty='" . $item['itemQuantity'] . "' tprice='" . $item['itemPrice'] . "' count ='" . $qt . "' ><img src='public/icons/Refresh16.png' width='18' height='18' /></a></span> <span><a href='#' class='deleteitem' prodid='" . $item['itemId'] . "' ><img src='public/icons/Delete16.png' width='18' height='18' /></a></span></td>\n <td>₦" . number_format($item['itemPrice'], 2, '.', ',') . "</td>\n <td>₦" . number_format($item['itemTotal'], 2, '.', ',') . "</td>\n </tr>";
$qt++;
}
/**
* foreach($myItems as $item){
* $mcart .="<tr>
* <td>".$item['itemQuantity']."</td>
* <td>".$item['itemName']."</td>
* <td>₦".$item['itemName']."</td>
* <td>".number_format($item['itemPrice'],2,'.',',')."</td>
* <td><span class='bold'>₦".number_format($item['itemTotal'],2,'.',',')."</span></td>
* <td><span class='bold'>x</span></td>
* </tr>
*
* ";
* }
*/
$mcart .= "<tr>\n \t<td> </td>\n <td> </td>\n <td> </td>\n <td> </td>\n <td> </td>\n </tr> \n\t <tr>\n <td> </td>\n <td colspan='3' align='right'><h3 class='black'>SubTotal:</h3></td>\n <td colspan='3' align='right'><span class='bold'>₦" . number_format($subTotal, 2, '.', ',') . "</span></td>\n </tr>\n <tr>\n <td> </td>\n <td colspan='3' align='right'><h3 class='black'>VAT(5%):</h3></td>\n <td colspan='3' align='right'><span class='bold'>₦" . number_format($vat, 2, '.', ',') . "</span></td>\n </tr>\n <tr>\n <td> </td>\n <td colspan='3' align='right'><h3><span class='black'>Total:</span></h3></td>\n <td colspan='3' align='right'><div class='divider'></div><h3 class='bold'>₦" . number_format($total, 2, '.', ',') . "</h3><div class='divider'></div><div class='divider'></div></td>\n </tr>\n <tr>\n \t<td> </td>\n <td colspan='3' align='right'><span style='margin:5px'><a href='#'>view cart</a></span></td>\n <td colspan='3'><span style='margin:5px'><a href='#'>Check out</a></span></td>\n </tr>\n </tbody>\n</table>";
print_r($mcart);
}
public function delete($id)
{
$article = Items::find_by_id($id);
if ($article->delete()) {
return true;
}
}
