Example #1
0
 public function adjust_invoice_number($invoice_id, $invoice_group_id)
 {
     $invoice = $this->mdl_invoices->get_by_id($invoice_id);
     if ($invoice->invoice_group_id != $invoice_group_id) {
         $group = parent::get_by_id($invoice_group_id);
         $invoice_number = '';
         $date_prefix = FALSE;
         if ($group->invoice_group_prefix_year) {
             $invoice_number .= date('Y');
             $date_prefix = TRUE;
         }
         if ($group->invoice_group_prefix_month) {
             $invoice_number .= date('m');
             $date_prefix = TRUE;
         }
         if ($date_prefix) {
             $invoice_number .= '-';
         }
         $invoice_number .= $group->invoice_group_prefix . str_pad($group->invoice_group_next_id, $group->invoice_group_left_pad, '0', STR_PAD_LEFT);
         /* Update the invoice group record with the incremented next invoice id */
         $this->db->set('invoice_group_next_id', $group->invoice_group_next_id + 1);
         $this->db->where('invoice_group_id', $group->invoice_group_id);
         $this->db->update('mcb_invoice_groups');
         /* Assign the invoice number to the invoice */
         $this->db->set('invoice_number', $invoice_number);
         $this->db->set('invoice_group_id', $invoice_group_id);
         $this->db->where('invoice_id', $invoice_id);
         $this->db->update('mcb_invoices');
     }
 }
Example #2
0
 /**
  * Get role by id
  * 
  * @param int $id
  * @return object resource
  */
 function get_by_id($id)
 {
     $row = parent::get_by_id($id);
     if ($row) {
         $row->parents = $this->get_parents($row->id);
     }
     return $row;
 }
Example #3
0
 /**
  *	Description: Gets  array of elements by any colum
  *	@param string column(Column name of the current table)
  *	@param any id (Any value of the column)
  *	@return Array of objects
  */
 public function get_by_id($column, $id)
 {
     $lesson_array = array($column => $id);
     $result = parent::get_by_id($lesson_array, false);
     return $result;
 }
Example #4
0
 public function get_by_id($primary_key_value, $fields = '')
 {
     $fields_hack = '*,(select brand_description from product_brands pb where pb.brand_id = products.product_brand_id) brand_name';
     return parent::get_by_id($primary_key_value, $fields_hack);
 }
Example #5
0
 /**
  * Get user by id
  * 
  * @param int $id
  * @return array|boolean
  */
 function get_by_id($id)
 {
     $this->db->select($this->table . '.*, ' . $this->role_table . '.name AS role_name')->join($this->role_table, $this->role_table . '.id = ' . $this->table . '.role_id', 'left');
     return parent::get_by_id($id);
 }