public function db_array()
{
$db_array = parent::db_array();
$date = new DateTime();
$db_array['client_note_date'] = $date->format('Y-m-d');
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
$db_array['task_finish_date'] = date_to_mysql($db_array['task_finish_date']);
$db_array['task_price'] = standardize_amount($db_array['task_price']);
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
if (!isset($db_array['client_active'])) {
$db_array['client_active'] = 0;
}
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
$db_array['product_price'] = empty($db_array['product_price']) ? null : standardize_amount($db_array['product_price']);
$db_array['purchase_price'] = empty($db_array['purchase_price']) ? null : standardize_amount($db_array['purchase_price']);
$db_array['family_id'] = empty($db_array['family_id']) ? null : $db_array['family_id'];
$db_array['tax_rate_id'] = empty($db_array['tax_rate_id']) ? null : $db_array['tax_rate_id'];
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
if (isset($db_array['user_password'])) {
unset($db_array['user_passwordv']);
$db_array['user_password'] = md5($db_array['user_password']);
}
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
$db_array['recur_start_date'] = date_to_mysql($db_array['recur_start_date']);
$db_array['recur_next_date'] = $db_array['recur_start_date'];
if ($db_array['recur_end_date']) {
$db_array['recur_end_date'] = date_to_mysql($db_array['recur_end_date']);
} else {
$db_array['recur_end_date'] = '0000-00-00';
}
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
if (isset($db_array['user_password'])) {
unset($db_array['user_passwordv']);
$this->load->library('crypt');
$user_psalt = $this->crypt->salt();
$db_array['user_psalt'] = $user_psalt;
$db_array['user_password'] = $this->crypt->generate_password($db_array['user_password'], $user_psalt);
}
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
// Get the client id for the submitted invoice
$this->load->model('clients/mdl_clients');
$db_array['client_id'] = $this->mdl_clients->client_lookup($db_array['client_name']);
unset($db_array['client_name']);
$db_array['invoice_date_created'] = date_to_mysql($db_array['invoice_date_created']);
// Calculate the invoice date due
$invoice_due_date = new DateTime($db_array['invoice_date_created']);
$invoice_due_date->add(new DateInterval('P' . $this->mdl_settings->setting('invoices_due_after') . 'D'));
$db_array['invoice_date_due'] = $invoice_due_date->format('Y-m-d');
// Get the next invoice number for the selected invoice group
$this->load->model('invoice_groups/mdl_invoice_groups');
$db_array['invoice_number'] = $this->mdl_invoice_groups->generate_invoice_number($db_array['invoice_group_id']);
$db_array['invoice_terms'] = $this->mdl_settings->setting('default_invoice_terms');
// Generate the unique url key
$db_array['invoice_url_key'] = $this->get_url_key();
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
// Get the client id for the submitted invoice
$this->load->model('clients/mdl_clients');
$db_array['client_id'] = $this->mdl_clients->client_lookup($db_array['client_name']);
unset($db_array['client_name']);
$db_array['invoice_date_created'] = date_to_mysql($db_array['invoice_date_created']);
$db_array['invoice_date_due'] = $this->get_date_due($db_array['invoice_date_created']);
$db_array['invoice_number'] = $this->get_invoice_number($db_array['invoice_group_id']);
$db_array['invoice_terms'] = $this->mdl_settings->setting('default_invoice_terms');
if (!isset($db_array['invoice_status_id'])) {
$db_array['invoice_status_id'] = 1;
}
// Generate the unique url key
$db_array['invoice_url_key'] = $this->get_url_key();
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
$db_array['payment_date'] = date_to_mysql($db_array['payment_date']);
$db_array['payment_amount'] = standardize_amount($db_array['payment_amount']);
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
// Get the client id for the submitted quote
$this->load->model('clients/mdl_clients');
$db_array['client_id'] = $this->mdl_clients->client_lookup($db_array['client_name']);
unset($db_array['client_name']);
$db_array['quote_date_created'] = date_to_mysql($db_array['quote_date_created']);
$db_array['quote_date_expires'] = $this->get_date_due($db_array['quote_date_created']);
$db_array['notes'] = $this->mdl_settings->setting('default_quote_notes');
if (!isset($db_array['quote_status_id'])) {
$db_array['quote_status_id'] = 1;
}
$generate_quote_number = $this->mdl_settings->setting('generate_quote_number_for_draft');
if ($db_array['quote_status_id'] === 1 && $generate_quote_number == 1) {
$db_array['quote_number'] = $this->get_quote_number($db_array['invoice_group_id']);
} elseif ($db_array['quote_status_id'] != 1) {
$db_array['quote_number'] = $this->get_quote_number($db_array['invoice_group_id']);
} else {
$db_array['quote_number'] = '';
}
// Generate the unique url key
$db_array['quote_url_key'] = $this->get_url_key();
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
$db_array['note_date'] = date('Y-m-d');
return $db_array;
}
public function db_array()
{
$db_array = parent::db_array();
$db_array['payment_date'] = date_to_mysql($db_array['payment_date']);
return $db_array;
}
