public function add_company($input)
{
$input['created_on'] = curr_timestamp();
$this->db->insert("companies", $input);
$primary_key = $this->db->insert_id();
if (gtzero_integer($primary_key)) {
_delete_cache('', CACHE_KEY_COMPANY_DDL_LIST);
return to_int($primary_key);
}
return 0;
}
public function add_note($input)
{
if (empty($input['note'])) {
return 0;
}
$input['created_on'] = curr_timestamp();
$this->db->insert('notes', $input);
$primary_key = $this->db->insert_id();
if (gtzero_integer($primary_key)) {
return to_int($primary_key);
}
return 0;
}
public function add_product($input)
{
$input['created_on'] = curr_timestamp();
$this->db->insert("products", $input);
$primary_key = $this->db->insert_id();
if (gtzero_integer($primary_key)) {
return to_int($primary_key);
}
return 0;
}
public function sfstatus($pkey, $method = "echo")
{
_has_user_access_permission(TRUE, array('admin'));
$params = ($params = unserialize_object($pkey)) && is_array($params) ? $params : array();
$company_id = in_array($this->current_user->group_id, array(GROUP_ADMIN, GROUP_STAFF, GROUP_ENGINEER)) ? $this->_post_args('company_id', ARGS_TYPE_INT, array_key_exists(SYS_COMPANY_ID, $params) && gtzero_integer($params[SYS_COMPANY_ID]) ? to_int($params[SYS_COMPANY_ID]) : 0) : $this->current_user->company_id;
$site_form_id = isset($params[SYS_SITE_FORM_ID]) && gtzero_integer($params[SYS_SITE_FORM_ID]) ? to_int($params[SYS_SITE_FORM_ID]) : 0;
$site_id = isset($params[SYS_SITE_ID]) && gtzero_integer($params[SYS_SITE_ID]) ? to_int($params[SYS_SITE_ID]) : 0;
$form_type_id = isset($params[SYS_FORM_TYPE_ID]) && gtzero_integer($params[SYS_FORM_TYPE_ID]) ? to_int($params[SYS_FORM_TYPE_ID]) : 0;
$redirect_url = $this->_post_args('redirect_url', ARGS_TYPE_STRING, $this->agent->referrer());
$doc_key = $this->input->post('doc_key') ? $this->input->post('doc_key') : keygen();
$csrf = _get_csrf_nonce();
$site_info = $this->site_m->details($site_id, $company_id);
$site_form_info = $this->site_m->site_form_detail($site_form_id);
if (!$site_info || _has_company_group_access($this->current_user->group_id) && $site_info->company_id != $this->current_user->company_id) {
$this->show_permission_denied_error($method);
}
$company_id = in_array($this->current_user->group_id, array(GROUP_ADMIN, GROUP_STAFF, GROUP_ENGINEER)) ? $this->_post_args('company_id', ARGS_TYPE_INT, $site_info->company_id) : $this->current_user->company_id;
$this->form_validation->set_rules('confirm', 'confirm', 'trim|required');
$output = array('message' => "", 'status' => "");
if ($this->form_validation->run() == TRUE) {
$is_record_updated = $this->site_m->update_site_form(array('completed_on' => curr_timestamp(), 'completed_by' => $this->current_user->user_id, 'status' => 3), $site_form_id, $site_id, $form_type_id);
if ($is_record_updated) {
$output['message'] = sprintf('The site form "%s" for site "%s" has been marked as completed.', $site_form_info->form_name, $site_info->site_code);
$output['status'] = SUCCESS_MESSAGE;
$output['site_form_info'] = $site_form_info;
} else {
$output['message'] = sprintf('Unable to mark form "%s" for site "%s" as completed. Please report the issue to %s', $site_form_info->form_name, $site_info->site_code, $this->cfg->contact_email);
$output['status'] = ERROR_MESSAGE;
}
$this->_output_request($output, $redirect_url);
} else {
if (validation_errors()) {
$output['message'] = validation_errors();
$output['status'] = ERROR_MESSAGE;
}
}
$csrf = _get_csrf_nonce();
$data = array('form_action' => site_url('sites/sfstatus/' . $pkey), 'cancel_url' => $redirect_url, 'page' => 'sites/delete', 'title' => $site_info->site_code . '(' . $site_form_info->form_name . ')', "display_message" => sprintf('Are you sure you want mark form "%s" for site "%s" as completed?', $site_form_info->form_name, $site_info->site_code), "display_heading" => sprintf($site_info->site_code . '(' . $site_form_info->form_name . ')'), "submit_btn_text" => "Save Changes", 'hiddenvars' => array_merge($csrf, array('redirect_url' => $redirect_url, 'confirm' => 1)));
if ($this->input->is_ajax_request()) {
$html = $this->template->raw_view('pages/sites/delete_modal', $data, TRUE);
if ($method == "ajax") {
$output['html'] = $html;
$this->_output_request($output, $redirect_url);
} else {
echo $html;
}
} else {
if (!empty($output['status'])) {
set_flash_data($output['status'], $output['message'], FALSE);
}
$this->template->load('default', $data);
}
}
public function add($input)
{
$flag = FALSE;
foreach (array('first_name', 'last_name', 'address', 'postcode', 'email', 'phone', 'mobile', 'fax') as $key) {
if (array_key_exists($key, $input) && !empty($input[$key])) {
$flag = TRUE;
}
}
if (!$flag) {
return 0;
}
$input['created_on'] = curr_timestamp();
$this->db->insert('contacts', $input);
$primary_key = $this->db->insert_id();
if (gtzero_integer($primary_key)) {
return to_int($primary_key);
}
return 0;
}
