/home/edulekha/crm.edulekha.com/application/libraries/merge_fields/Tasks_merge_fields.php
<?php
defined('BASEPATH') or exit('No direct script access allowed');
class Tasks_merge_fields extends App_merge_fields
{
public function build()
{
return [
[
'name' => 'Staff/Contact who take action on task',
'key' => '{task_user_take_action}',
'available' => [
'tasks',
],
],
[
'name' => 'Task Link',
'key' => '{task_link}',
'available' => [
'tasks',
],
],
[
'name' => 'Comment Link',
'key' => '{comment_link}',
'available' => [
],
'templates' => [
'task-commented',
'task-commented-to-contacts',
],
],
[
'name' => 'Task Name',
'key' => '{task_name}',
'available' => [
'tasks',
],
],
[
'name' => 'Task Description',
'key' => '{task_description}',
'available' => [
'tasks',
],
],
[
'name' => 'Task Status',
'key' => '{task_status}',
'available' => [
'tasks',
],
],
[
'name' => 'Task Comment',
'key' => '{task_comment}',
'available' => [
],
'templates' => [
'task-commented',
'task-commented-to-contacts',
],
],
[
'name' => 'Task Priority',
'key' => '{task_priority}',
'available' => [
'tasks',
],
],
[
'name' => 'Task Start Date',
'key' => '{task_startdate}',
'available' => [
'tasks',
],
],
[
'name' => 'Task Due Date',
'key' => '{task_duedate}',
'available' => [
'tasks',
],
],
[
'name' => 'Related to',
'key' => '{task_related}',
'available' => [
'tasks',
],
],
];
}
/**
* Merge fields for tasks
* @param mixed $task_id task id
* @param boolean $client_template is client template or staff template
* @return array
*/
public function format($task_id, $client_template = false)
{
$fields = [];
$this->ci->db->where('id', $task_id);
$task = $this->ci->db->get(db_prefix() . 'tasks')->row();
if (!$task) {
return $fields;
}
// Client templateonly passed when sending to tasks related to project and sending email template to contacts
// Passed from tasks_model _send_task_responsible_users_notification function
if ($client_template == false) {
$fields['{task_link}'] = admin_url('tasks/view/' . $task_id);
} else {
$fields['{task_link}'] = site_url('clients/project/' . $task->rel_id . '?group=project_tasks&taskid=' . $task_id);
}
if (is_client_logged_in()) {
$fields['{task_user_take_action}'] = e(get_contact_full_name(get_contact_user_id()));
} else {
$fields['{task_user_take_action}'] = e(get_staff_full_name(get_staff_user_id()));
}
$fields['{task_comment}'] = '';
$fields['{task_related}'] = '';
$fields['{project_name}'] = '';
if ($task->rel_type == 'project') {
$this->ci->db->select('name, clientid');
$this->ci->db->from(db_prefix() . 'projects');
$this->ci->db->where('id', $task->rel_id);
$project = $this->ci->db->get()->row();
if ($project) {
$fields['{project_name}'] = e($project->name);
}
}
if (!empty($task->rel_id)) {
$rel_data = get_relation_data($task->rel_type, $task->rel_id);
$rel_values = get_relation_values($rel_data, $task->rel_type);
$fields['{task_related}'] = e($rel_values['name']);
}
$fields['{task_name}'] = e($task->name);
$fields['{task_description}'] = $task->description;
$languageChanged = false;
// The tasks status may not be translated if the client language is not loaded
if (!is_client_logged_in()
&& $task->rel_type == 'project'
&& $project
&& isset($GLOBALS['SENDING_EMAIL_TEMPLATE_CLASS'])
&& !$GLOBALS['SENDING_EMAIL_TEMPLATE_CLASS']->get_staff_id() // email to client
) {
load_client_language($project->clientid);
$languageChanged = true;
} else {
if (isset($GLOBALS['SENDING_EMAIL_TEMPLATE_CLASS'])) {
$sending_to_staff_id = $GLOBALS['SENDING_EMAIL_TEMPLATE_CLASS']->get_staff_id();
if ($sending_to_staff_id) {
load_admin_language($sending_to_staff_id);
$languageChanged = true;
}
}
}
$fields['{task_status}'] = e(format_task_status($task->status, false, true));
$fields['{task_priority}'] = e(task_priority($task->priority));
$custom_fields = get_custom_fields('tasks');
foreach ($custom_fields as $field) {
$fields['{' . $field['slug'] . '}'] = get_custom_field_value($task_id, $field['id'], 'tasks');
}
if (!is_client_logged_in() && $languageChanged) {
load_admin_language();
} elseif (is_client_logged_in() && $languageChanged) {
load_client_language();
}
$fields['{task_startdate}'] = e(_d($task->startdate));
$fields['{task_duedate}'] = e(_d($task->duedate));
$fields['{comment_link}'] = '';
$this->ci->db->where('taskid', $task_id);
$this->ci->db->limit(1);
$this->ci->db->order_by('dateadded', 'desc');
$comment = $this->ci->db->get(db_prefix() . 'task_comments')->row();
if ($comment) {
$fields['{task_comment}'] = $comment->content;
$fields['{comment_link}'] = $fields['{task_link}'] . '#comment_' . $comment->id;
}
return hooks()->apply_filters('task_merge_fields', $fields, [
'id' => $task_id,
'task' => $task,
'client_template' => $client_template,
]);
}
}