381 lines
17 KiB
PHP
381 lines
17 KiB
PHP
<?php
|
|
|
|
defined('BASEPATH') or exit('No direct script access allowed');
|
|
|
|
class Estimate_request_model extends App_Model {
|
|
public const STATUS_PROCESSING = 2;
|
|
|
|
public function __construct() {
|
|
parent::__construct();
|
|
}
|
|
|
|
public function update_request_assigned($data, $playground = false) {
|
|
$this->db->select('assigned');
|
|
$this->db->where('id', $data['requestid']);
|
|
$_old_assigned = $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests')->row();
|
|
$this->db->where('id', $data['requestid']);
|
|
$this->db->update(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests', ['assigned' => $data['assigned'], ]);
|
|
$this->db->select('assigned');
|
|
$this->db->where('id', $data['requestid']);
|
|
$_current_assigned = $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests')->row();
|
|
if ($this->db->affected_rows() > 0) {
|
|
if ($_current_assigned != $_old_assigned && $_old_assigned != '') {
|
|
hooks()->do_action('estimate_request_assigned_changed', ['estimate_request_id' => $data['requestid'], 'old_staff' => $_old_assigned, 'new_staff' => $_current_assigned, ]);
|
|
$this->load->model('staff_model');
|
|
log_activity(sprintf('Estimate Request Assigned to %s', $this->staff_model->get_staff_full_name($_current_assigned->assigned, $playground)) . ' [ID: ' . $data['requestid'] . ']');
|
|
}
|
|
if ($_current_assigned == $_old_assigned) {
|
|
return false;
|
|
}
|
|
$this->assigned_member_notification($data['requestid'], $_current_assigned->assigned, $playground);
|
|
return true;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
public function update_request_status($data, $playground = false) {
|
|
$this->db->select('status');
|
|
$this->db->where('id', $data['requestid']);
|
|
$_old = $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests')->row();
|
|
$old_status = '';
|
|
if ($_old) {
|
|
$old_status = $this->get_status($_old->status, $playground);
|
|
if ($old_status) {
|
|
$old_status = $old_status->name;
|
|
}
|
|
}
|
|
$affectedRows = 0;
|
|
$current_status = $this->get_status($data['status'], $playground)->name;
|
|
$this->db->where('id', $data['requestid']);
|
|
$this->db->update(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests', ['status' => $data['status'], ]);
|
|
$_log_message = '';
|
|
if ($this->db->affected_rows() > 0) {
|
|
$affectedRows++;
|
|
if ($current_status != $old_status && $old_status != '') {
|
|
$_log_message = 'not_estimate_request_activity_status_updated';
|
|
$this->load->model('staff_model');
|
|
$additional_data = serialize([$this->staff_model->get_staff_full_name('', $playground), $old_status, $current_status, ]);
|
|
hooks()->do_action('estimate_request_status_changed', ['estimate_request_id' => $data['requestid'], 'old_status' => $old_status, 'new_status' => $current_status, ]);
|
|
}
|
|
}
|
|
if ($affectedRows > 0) {
|
|
if ($_log_message == '') {
|
|
return true;
|
|
}
|
|
return true;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
/**
|
|
* Get estimate_request
|
|
*
|
|
* @param string $id Optional - estimate_requestid
|
|
* @param mixed $where
|
|
*
|
|
* @return mixed
|
|
*/
|
|
public function get($id = '', $where = [], $playground = false) {
|
|
$this->db->select('*,' . db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests.id,' . db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_status.name as status_name');
|
|
$this->db->join(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_status', db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_status.id=' . db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests.status', 'left');
|
|
$this->db->where($where);
|
|
if (is_numeric($id)) {
|
|
$this->db->where(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests.id', $id);
|
|
$request = $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests')->row();
|
|
if ($request) {
|
|
if ($request->from_form_id != 0) {
|
|
$request->form_data = $this->get_form(['id' => $request->from_form_id, ], $playground);
|
|
}
|
|
$request->attachments = $this->get_estimate_request_attachments($id, $playground);
|
|
}
|
|
return $request;
|
|
}
|
|
return $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests')->result_array();
|
|
}
|
|
|
|
public function get_forms($playground = false) {
|
|
return $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_forms')->result_array();
|
|
}
|
|
|
|
public function get_form($where, $playground = false) {
|
|
$this->db->where($where);
|
|
return $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_forms')->row();
|
|
}
|
|
|
|
public function add_form($data) {
|
|
$data = $this->_do_estimate_request_form_responsibles($data);
|
|
$data['success_submit_msg'] = nl2br($data['success_submit_msg']);
|
|
$data['form_key'] = app_generate_hash();
|
|
$data['dateadded'] = date('Y-m-d H:i:s');
|
|
$this->db->insert(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_forms', $data);
|
|
$insert_id = $this->db->insert_id();
|
|
if ($insert_id) {
|
|
log_activity('New Estimate Request Form Added [' . $data['name'] . ']');
|
|
return $insert_id;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
public function update_form($id, $data, $playground = false) {
|
|
$data = $this->_do_estimate_request_form_responsibles($data, $playground);
|
|
$data['success_submit_msg'] = nl2br($data['success_submit_msg']);
|
|
$this->db->where('id', $id);
|
|
$this->db->update(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_forms', $data);
|
|
return $this->db->affected_rows() > 0 ? true : false;
|
|
}
|
|
|
|
public function delete_form($id, $playground = false) {
|
|
$this->db->where('id', $id);
|
|
$this->db->delete(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_forms');
|
|
$this->db->where('from_form_id', $id);
|
|
$this->db->update(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests', ['from_form_id' => 0, ]);
|
|
if ($this->db->affected_rows() > 0) {
|
|
log_activity('Estimate Request Form Deleted [' . $id . ']');
|
|
return true;
|
|
}
|
|
return false;
|
|
}
|
|
private function _do_estimate_request_form_responsibles($data, $playground = false) {
|
|
if (isset($data['notify_request_submitted'])) {
|
|
$data['notify_request_submitted'] = 1;
|
|
} else {
|
|
$data['notify_request_submitted'] = 0;
|
|
}
|
|
if ($data['responsible'] == '') {
|
|
$data['responsible'] = 0;
|
|
}
|
|
if ($data['notify_request_submitted'] != 0) {
|
|
if ($data['notify_type'] == 'specific_staff') {
|
|
if (isset($data['notify_ids_staff'])) {
|
|
$data['notify_ids'] = serialize($data['notify_ids_staff']);
|
|
unset($data['notify_ids_staff']);
|
|
} else {
|
|
$data['notify_ids'] = serialize([]);
|
|
unset($data['notify_ids_staff']);
|
|
}
|
|
if (isset($data['notify_ids_roles'])) {
|
|
unset($data['notify_ids_roles']);
|
|
}
|
|
} else {
|
|
if (isset($data['notify_ids_roles'])) {
|
|
$data['notify_ids'] = serialize($data['notify_ids_roles']);
|
|
unset($data['notify_ids_roles']);
|
|
} else {
|
|
$data['notify_ids'] = serialize([]);
|
|
unset($data['notify_ids_roles']);
|
|
}
|
|
if (isset($data['notify_ids_staff'])) {
|
|
unset($data['notify_ids_staff']);
|
|
}
|
|
}
|
|
} else {
|
|
$data['notify_ids'] = serialize([]);
|
|
$data['notify_type'] = null;
|
|
if (isset($data['notify_ids_staff'])) {
|
|
unset($data['notify_ids_staff']);
|
|
}
|
|
if (isset($data['notify_ids_roles'])) {
|
|
unset($data['notify_ids_roles']);
|
|
}
|
|
}
|
|
return $data;
|
|
}
|
|
|
|
/**
|
|
* Delete estimate request from database and all connections
|
|
*
|
|
* @param mixed $id estimate request id
|
|
*
|
|
* @return bool
|
|
*/
|
|
public function delete($id, $playground = false) {
|
|
$affectedRows = 0;
|
|
hooks()->do_action('before_estimate_request_deleted', $id);
|
|
$this->db->where('id', $id);
|
|
$this->db->delete(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests');
|
|
if ($this->db->affected_rows() > 0) {
|
|
$this->load->model('staff_model');
|
|
log_activity('Estimate Request Deleted [Deleted by: ' . $this->staff_model->get_staff_full_name('', $playground) . ', ID: ' . $id . ']');
|
|
$attachments = $this->get_estimate_request_attachments($id, $playground);
|
|
foreach ($attachments as $attachment) {
|
|
$this->delete_estimate_request_attachment($attachment['id'], $playground);
|
|
}
|
|
// Delete the tags
|
|
$this->db->where('rel_type', 'estimate_request');
|
|
$this->db->where('rel_id', $id);
|
|
$this->db->delete(db_prefix() . ($playground ? 'playground_' : '') . 'taggables');
|
|
$affectedRows++;
|
|
}
|
|
return $affectedRows > 0;
|
|
}
|
|
|
|
// Statuses
|
|
|
|
/**
|
|
* Get estimate_request statuses
|
|
*
|
|
* @param mixed $id status id
|
|
* @param mixed $where
|
|
*
|
|
* @return mixed object if id passed else array
|
|
*/
|
|
public function get_status($id = '', $where = [], $playground = false) {
|
|
$this->db->where($where);
|
|
if (is_numeric($id)) {
|
|
$this->db->where('id', $id);
|
|
return $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_status')->row();
|
|
}
|
|
$statuses = $this->app_object_cache->get('estimate-request-all-statuses');
|
|
if (!$statuses) {
|
|
$this->db->order_by('statusorder', 'asc');
|
|
$statuses = $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_status')->result_array();
|
|
$this->app_object_cache->add('estimate-request-all-statuses', $statuses);
|
|
}
|
|
return $statuses;
|
|
}
|
|
|
|
/**
|
|
* Add new estimate_request status
|
|
*
|
|
* @param array $data estimate_request status data
|
|
*/
|
|
public function add_status($data, $playground = false) {
|
|
if (isset($data['color']) && $data['color'] == '') {
|
|
$data['color'] = hooks()->apply_filters('default_estimate_request_status_color', '#757575');
|
|
}
|
|
if (!isset($data['statusorder'])) {
|
|
$data['statusorder'] = total_rows(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_status') + 1;
|
|
}
|
|
$this->db->insert(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_status', $data);
|
|
$insert_id = $this->db->insert_id();
|
|
if ($insert_id) {
|
|
log_activity('New Estimate Request Status Added [StatusID: ' . $insert_id . ', Name: ' . $data['name'] . ']');
|
|
return $insert_id;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
/**
|
|
* Update statuses
|
|
*
|
|
* @param mixed $data
|
|
* @param mixed $id
|
|
*/
|
|
public function update_status($data, $id, $playground = false) {
|
|
$this->db->where('id', $id);
|
|
$this->db->update(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_status', $data);
|
|
if ($this->db->affected_rows() > 0) {
|
|
log_activity('Estimate Request Status Updated [StatusID: ' . $id . ', Name: ' . $data['name'] . ']');
|
|
return true;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
/**
|
|
* Delete estimate_request status from database
|
|
*
|
|
* @param mixed $id status id
|
|
*
|
|
* @return bool
|
|
*/
|
|
public function delete_status($id, $playground = false) {
|
|
$current = $this->get_status($id, $playground);
|
|
// Check if is already using in table
|
|
if (is_reference_in_table('status', db_prefix() . ($playground ? 'playground_' : '') . 'estimate_requests', $id)) {
|
|
return ['referenced' => true, ];
|
|
}
|
|
if ($current->flag != '') {
|
|
return ['flag' => true, ];
|
|
}
|
|
$this->db->where('id', $id);
|
|
$this->db->delete(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_status');
|
|
if ($this->db->affected_rows() > 0) {
|
|
log_activity('Estimate Request Status Deleted [StatusID: ' . $id . ']');
|
|
return true;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
/**
|
|
* Get estimate_request attachments
|
|
*
|
|
* @param mixed $id estimate_request id
|
|
* @param mixed $attachment_id
|
|
* @param mixed $where
|
|
*
|
|
* @return array
|
|
*
|
|
* @since Version 1.0.4
|
|
*/
|
|
public function get_estimate_request_attachments($id = '', $attachment_id = '', $where = [], $playground = false) {
|
|
$this->db->where($where);
|
|
$idIsHash = !is_numeric($attachment_id) && strlen($attachment_id) == 32;
|
|
if (is_numeric($attachment_id) || $idIsHash) {
|
|
$this->db->where($idIsHash ? 'attachment_key' : 'id', $attachment_id);
|
|
return $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'files')->row();
|
|
}
|
|
$this->db->where('rel_id', $id);
|
|
$this->db->where('rel_type', 'estimate_request');
|
|
$this->db->order_by('dateadded', 'DESC');
|
|
return $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'files')->result_array();
|
|
}
|
|
|
|
public function add_attachment_to_database($estimate_request_id, $attachment, $external = false, $playground = false) {
|
|
$this->load->model('misc_model');
|
|
$this->misc_model->add_attachment_to_database($estimate_request_id, 'estimate_request', $attachment, $external, $playground);
|
|
}
|
|
|
|
/**
|
|
* Delete estimate_request attachment
|
|
*
|
|
* @param mixed $id attachment id
|
|
*
|
|
* @return bool
|
|
*/
|
|
public function delete_estimate_request_attachment($id, $playground = false) {
|
|
$attachment = $this->get_estimate_request_attachments('', $id, $playground);
|
|
$deleted = false;
|
|
$this->load->model('misc_model');
|
|
if ($attachment) {
|
|
if (empty($attachment->external)) {
|
|
unlink($this->misc_model->get_upload_path_by_type('estimate_request', $playground) . $attachment->rel_id . '/' . $attachment->file_name);
|
|
}
|
|
$this->db->where('id', $attachment->id);
|
|
$this->db->delete(db_prefix() . ($playground ? 'playground_' : '') . 'files');
|
|
if ($this->db->affected_rows() > 0) {
|
|
$deleted = true;
|
|
log_activity('Estima Request Attachment Deleted [ID: ' . $attachment->rel_id . ']');
|
|
}
|
|
if (is_dir($this->misc_model->get_upload_path_by_type('estimate_request') . $attachment->rel_id)) {
|
|
// Check if no attachments left, so we can delete the folder also
|
|
$other_attachments = list_files($this->misc_model->get_upload_path_by_type('estimate_request', $playground) . $attachment->rel_id);
|
|
if (count($other_attachments) == 0) {
|
|
// okey only index.html so we can delete the folder also
|
|
delete_dir($this->misc_model->get_upload_path_by_type('estimate_request', $playground) . $attachment->rel_id);
|
|
}
|
|
}
|
|
}
|
|
return $deleted;
|
|
}
|
|
|
|
public function assigned_member_notification($estimate_request_id, $assigned, $playground = false) {
|
|
if ((!empty($assigned) && $assigned != 0)) {
|
|
$notified = add_notification(['description' => 'estimate_request_assigned_to_staff', 'touserid' => $assigned, 'additional_data' => serialize([]), 'link' => 'estimate_request/view/' . $estimate_request_id, ], $playground);
|
|
if ($notified) {
|
|
pusher_trigger_notification([$assigned]);
|
|
}
|
|
$this->db->select('email');
|
|
$this->db->where('staffid', $assigned);
|
|
$email = $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'staff')->row()->email;
|
|
send_mail_template('estimate_request_assigned', $estimate_request_id, $email);
|
|
return true;
|
|
}
|
|
return false;
|
|
}
|
|
|
|
public function get_status_by_flag($flag, $playground = false) {
|
|
$this->db->where('flag', $flag);
|
|
return $this->db->get(db_prefix() . ($playground ? 'playground_' : '') . 'estimate_request_status')->row();
|
|
}
|
|
}
|