function add_product_serial_number($array) { $ci =& get_instance(); $query = get_product_serial_number($array); if ($query) { return 0; } else { $ci->db->insert('product_serials', $array); return $query = $ci->db->insert_id(); } }
</div> <!-- /.row --> </div><!-- /#product card --> <!-- serial --> <div class="tab-pane fade in" id="serial_box"> <?php if (isset($_POST['add_serial_number'])) { $serial['status'] = '1'; $serial['product_id'] = $product_id; $serial['serial'] = $this->input->post('serial_number'); $is_serial = get_product_serial_number($serial); if ($is_serial == 0) { $serial_id = add_product_serial_number($serial); if ($serial_id > 0) { alertbox('alert-success', get_lang('Data Added')); } } else { alertbox('alert-warning', '[' . $serial['serial'] . '] ' . get_lang('The serial number exists in the database.')); } echo '<script>$("#tab_serial_click").click(); $("#serial_number").click();</script>'; } if (isset($_GET['delete_serial'])) { $serial_id = $_GET['serial_id']; $this->db->where('id', $serial_id); $this->db->update('product_serials', array('status' => '0')); if ($this->db->affected_rows() > 0) {
$data['product_id'] = $product['id']; $data['account_id'] = $invoice['account_id']; $data['title'] = get_lang('Product Added'); if ($invoice['in_out'] == 0) { $data['description'] = get_lang('Product purchase.'); } else { $data['description'] = get_lang('Product sales.'); } add_log($data); alertbox('alert-success', get_lang('Add a successful product.')); calc_invoice_items($invoice['id']); // serial control if ($product['serial'] == 1) { $serial['serial'] = $this->input->post('serial'); if ($serial > 0) { $is_serial = get_product_serial_number(array('status' => '1', 'product_id' => $product['id'], 'serial' => $serial['serial'])); if ($is_serial > 0) { $this->db->where('id', $is_serial['id']); $this->db->update('product_serials', array('invoice_id' => $invoice_id)); // update item serial number $this->db->where('id', $item_id); $this->db->update('invoice_items', array('product_serial_id' => $is_serial['id'])); } else { add_product_serial_number(array('status' => 1, 'product_id' => $product['id'], 'serial' => $serial['serial'], 'invoice_id' => $invoice['id'])); // update item serial number $this->db->where('id', $item_id); $this->db->update('invoice_items', array('product_serial_id' => $is_serial['id'])); } } } }