public function insert_product_warehouse($form)
{
$data = array();
$data['product_id'] = $form['product_id'];
$data['warehouse_cost'] = $form['product_cost'];
$data['warehouse_price'] = $form['product_price'];
$data['warehouse_quantity'] = $form['product_quantity'];
$data['warehouse_barcode'] = $form['product_barcode'];
$data['warehouse_qtytype'] = $form['p_qtytype'];
$data['warehouse_sp_bill'] = $form['sup_bill'];
$this->insert($this->table_name, $data);
$accounts = new accounts();
$products = new product();
// Create GL
$amount = $form['product_cost'] * $products->generate_item_quantity($form['product_id'], $form['p_qtytype'], $form['product_quantity']);
$type = 'debit';
$account = 'Purchase';
$account_type = 'Stock';
$date = $accounts->_date('Y-m-d H:i:s', date('d-m-Y'));
$results = $accounts->create_general_ledger($amount, $type, $account, $account_type, $date);
// Purchase
$product = $form['product_id'];
$cost = $form['product_cost'];
$quantity = $products->generate_item_quantity($form['product_id'], $form['p_qtytype'], $form['product_quantity']);
$date = $date;
$account = 'purchase';
$account_type = 'stock';
$results = $accounts->create_purchase($product, $cost, $quantity, $date, $account, $account_type);
return $this->row_count();
}
public function sale_insert($form)
{
$data = array();
$data['sale_bill_number'] = $form['bill_number'];
$data['sale_shift_number'] = $form['user_shift_number'];
$data['sale_terminal_number'] = $form['user_terminal_point_number'];
$data['sale_payment'] = $form['payment_mode'];
$data['sale_user_id'] = $form['user_id'];
$data['sale_date'] = $this->_date('Y-m-d H:i:s', date('d-m-Y'));
// Sales Insert in Sale Table
$this->insert($this->table_name, $data);
if ($this->row_count() > 0) {
$sale_id = $this->last_id();
} else {
return false;
}
// Sales Products Insert in Sale Products Table
if ($sale_id) {
foreach ($_SESSION['terminal_list'] as $key => $value) {
$val_array = array();
foreach ($value[key($value)] as $key_array => $value_array) {
$val_array[$key_array] = $value_array;
}
$product['salepro_product_id'] = $val_array['p_id'];
$product['salepro_product_price'] = $val_array['p_price'] - $val_array['discount_amount'];
$product['salepro_product_quantity'] = $val_array['quantity'];
$product['salepro_date'] = $this->_date('Y-m-d H:i:s', date('d-m-Y'));
$product['salepro_sale_id'] = $sale_id;
$this->insert('sale_product', $product);
// Account
$accounts = new accounts();
// Sale and revenue
$product_id = $val_array['p_id'];
$cost = $val_array['p_cost'];
$price = $val_array['p_price'] - $val_array['discount_amount'];
$quantity = $val_array['quantity'];
$total = $price * $quantity;
$date = $accounts->_date('Y-m-d H:i:s', date('d-m-Y'));
$accounts->create_sales($product_id, $cost, $price, $quantity, $total, $date);
// Profit and loss
$cost1 = $cost * $quantity;
$price1 = $price * $quantity;
$profit = $price1 - $cost1;
$results = $accounts->create_profitloss($product_id, $cost, $price, $quantity, $profit, $date);
}
return true;
} else {
return false;
}
}
<div class="clearfix" style="margin-bottom:10px;"></div>
<?php
$accounts = new accounts();
if (isset($_POST['show_report'])) {
$to_date = $_POST['to_date'];
$from_date = $_POST['from_date'];
$assets_type = $_POST['assets_type'];
if ($_POST['assets_type']) {
$assets_type = $_POST['assets_type'];
} else {
$assets_type = NULL;
}
if ($_POST['to_date']) {
$to_date = $_POST['to_date'];
$to_date = $accounts->_date('Y-m-d H:i:s', $to_date);
} else {
$to_date = NULL;
}
if ($_POST['from_date']) {
$from_date = $_POST['from_date'];
$from_date = $accounts->_date('Y-m-d H:i:s', $from_date);
} else {
$from_date = NULL;
}
// $results = $accounts->get_sales_report($assets_type, $to_date, $from_date);
$results = $accounts->get_assets_report($assets_type, $to_date, $from_date);
//print_f($results);
}
?>
<section>
<hr/>
<div class="container">
<div class="row">
<?php
$accounts = new accounts();
// Get Sales
if ($_GET['product_name']) {
$product_id = $_GET['product_name'];
} else {
$product_id = NULL;
}
if ($_GET['to_date']) {
$to_date = $_GET['to_date'];
$to_date = $accounts->_date('Y-m-d H:i:s', $to_date);
} else {
$to_date = NULL;
}
if ($_GET['from_date']) {
$from_date = $_GET['from_date'];
$from_date = $accounts->_date('Y-m-d H:i:s', $from_date);
} else {
$from_date = NULL;
}
$results = $accounts->get_sales_report($product_id, $to_date, $from_date);
?>
</div><!-- Row Close -->
</div><!-- Container Close -->
<div class="clearfix" style="margin-bottom:10px;"></div>
<?php
$accounts = new accounts();
if (isset($_POST['show_report'])) {
$to_date = $_POST['to_date'];
$from_date = $_POST['from_date'];
$product_name = $_POST['product_name'];
if ($_POST['product_name']) {
$product_id = $_POST['product_name'];
} else {
$product_id = NULL;
}
if ($_POST['to_date']) {
$to_date = $_POST['to_date'];
$to_date = $accounts->_date('Y-m-d H:i:s', $to_date);
} else {
$to_date = NULL;
}
if ($_POST['from_date']) {
$from_date = $_POST['from_date'];
$from_date = $accounts->_date('Y-m-d H:i:s', $from_date);
} else {
$from_date = NULL;
}
$results = $accounts->get_profitloss_report($product_id, $to_date, $from_date);
// print_f($results);
}
?>
<!-- Begin page heading -->
</div>
</div>
</div>
</form>
<div class="clearfix" style="margin-bottom:10px;"></div>
</div><!-- Box Close -->
<div class="clearfix" style="margin-bottom:10px;"></div>
<?php
$accounts = new accounts();
if (isset($_POST['show_report'])) {
$to_date = $_POST['to_date'];
$from_date = $_POST['from_date'];
if ($_POST['to_date']) {
$to_date = $_POST['to_date'];
$to_date = $accounts->_date('Y-m-d H:i:s', $to_date);
} else {
$to_date = NULL;
}
if ($_POST['from_date']) {
$from_date = $_POST['from_date'];
$from_date = $accounts->_date('Y-m-d H:i:s', $from_date);
} else {
$from_date = NULL;
}
$results = $accounts->get_capital_report($to_date, $from_date);
// print_f($results);
}
?>
