public function store()
{
$q = new DBQuery();
if ($this->task_log_id) {
$this->task_log_updated = $q->dbfnNow();
} else {
$this->task_log_created = $q->dbfnNow();
$this->task_log_updated = $q->dbfnNow();
}
parent::store();
$this->updateHoursWorked($this->task_log_task);
}
function addHistory($table, $id, $action = 'modify', $description = '', $project_id = 0)
{
global $AppUI;
/*
* TODO:
* 1) description should be something like:
* command(arg1, arg2...)
* The command should be as module_action
* for example:
* forums_new('Forum Name', 'URL')
*
* This way, the history module will be able to display descriptions
* using locale definitions:
* "forums_new" -> "New forum '%s' was created" -> "Se ha creado un nuevo foro llamado '%s'"
*
* 2) project_id and module_id should be provided in order to filter history entries
*
*/
if (!w2PgetConfig('log_changes')) {
return;
}
$description = str_replace("'", "\\'", $description);
$q = new DBQuery();
$q->addTable('modules');
$q->addWhere('mod_name = \'History\' and mod_active = 1');
$qid = $q->exec();
if (!$qid || db_num_rows($qid) == 0) {
$AppUI->setMsg('History module is not loaded, but your config file has requested that changes be logged. You must either change the config file or install and activate the history module to log changes.', UI_MSG_ALERT);
$q->clear();
return;
}
$q->clear();
$q->addTable('history');
$q->addInsert('history_action', $action);
$q->addInsert('history_item', $id);
$q->addInsert('history_description', $description);
$q->addInsert('history_user', $AppUI->user_id);
$q->addInsert('history_date', $q->dbfnNow(), false, true);
$q->addInsert('history_project', $project_id);
$q->addInsert('history_table', $table);
$q->exec();
echo db_error();
$q->clear();
}
public function store(CAppUI $AppUI)
{
$perms = $AppUI->acl();
$stored = false;
$errorMsgArray = $this->check();
if (count($errorMsgArray) > 0) {
return $errorMsgArray;
}
if ($this->link_id && $perms->checkModuleItem('links', 'edit', $this->link_id)) {
$q = new DBQuery();
$this->link_date = $q->dbfnNow();
if ($msg = parent::store()) {
return $msg;
}
addHistory('links', $this->link_id, 'update', $this->link_name, $this->link_id);
$stored = true;
}
if (0 == $this->link_id && $perms->checkModuleItem('links', 'add')) {
$q = new DBQuery();
$this->link_date = $q->dbfnNow();
if ($msg = parent::store()) {
return $msg;
}
addHistory('links', $this->link_id, 'add', $this->link_name, $this->link_id);
$stored = true;
}
return $stored;
}
/**
*@Function for update table user_acces_log in field date_time_lost_action
*/
public function updateLastAction($last_insert_id)
{
$q = new DBQuery();
$q->addTable('user_access_log');
$q->addUpdate('date_time_last_action', $q->dbfnNow(), false, true);
$q->addWhere('user_access_log_id = ' . $last_insert_id);
if ($last_insert_id > 0) {
$q->exec();
$q->clear();
}
}
public function getCalendarEvents($userId, $days = 30)
{
/*
* This list of fields - id, name, description, startDate, endDate,
* updatedDate - are named specifically for the iCal creation.
* If you change them, it's probably going to break. So don't do that.
*/
$q = new DBQuery();
$q->addQuery('e.event_id as id');
$q->addQuery('event_title as name');
$q->addQuery('event_description as description');
$q->addQuery('event_start_date as startDate');
$q->addQuery('event_end_date as endDate');
$q->addQuery($q->dbfnNow() . ' as updatedDate');
$q->addQuery('CONCAT(\'' . W2P_BASE_URL . '/index.php?m=calendar&a=view&event_id=' . '\', e.event_id) as url');
$q->addQuery('projects.project_id, projects.project_name');
$q->addTable('events', 'e');
$q->leftJoin('projects', 'projects', 'e.event_project = projects.project_id');
$q->addWhere('(event_start_date > ' . $q->dbfnNow() . ' OR event_end_date > ' . $q->dbfnNow() . ')');
$q->addWhere('(event_start_date < ' . $q->dbfnDateAdd($q->dbfnNow(), $days, 'DAY') . ' OR event_end_date < ' . $q->dbfnDateAdd($q->dbfnNow(), $days, 'DAY') . ')');
$q->innerJoin('user_events', 'ue', 'ue.event_id = e.event_id');
$q->addWhere('ue.user_id = ' . $userId);
$q->addOrder('event_start_date');
return $q->loadList();
}
$q->exec();
echo db_error();
$q->clear();
}
}
$AppUI->savePlace();
$proj = new CProject();
$tobj = new CTask();
$allowedProjects = $proj->getAllowedSQL($AppUI->user_id, 'pr.project_id');
$allowedTasks = $tobj->getAllowedSQL($AppUI->user_id, 'ta.task_id');
// query my sub-tasks (ignoring task parents)
$q = new DBQuery();
$q->addQuery('ta.*');
$q->addQuery('project_name, pr.project_id, project_color_identifier');
$q->addQuery('tp.task_pinned');
$dateDiffString = $q->dbfnDateDiff('ta.task_end_date', $q->dbfnNow()) . ' AS task_due_in';
$q->addQuery($dateDiffString);
$q->addTable('projects', 'pr');
$q->addTable('tasks', 'ta');
$q->addTable('user_tasks', 'ut');
$q->leftJoin('user_task_pin', 'tp', 'tp.task_id = ta.task_id and tp.user_id = ' . (int) $user_id);
$q->leftJoin('project_departments', 'project_departments', 'pr.project_id = project_departments.project_id OR project_departments.project_id IS NULL');
$q->leftJoin('departments', 'departments', 'departments.dept_id = project_departments.department_id OR dept_id IS NULL');
$q->addWhere('ut.task_id = ta.task_id');
$q->addWhere('ut.user_id = ' . (int) $user_id);
$q->addWhere('( ta.task_percent_complete < 100 or ta.task_percent_complete is null)');
$q->addWhere('ta.task_status = 0');
$q->addWhere('pr.project_id = ta.task_project');
if (!$showArcProjs) {
$q->addWhere('project_active = 1');
if (($template_status = w2PgetConfig('template_projects_status_id')) != '') {
public function store(CAppUI $AppUI = null)
{
global $AppUI;
$errorMsgArray = $this->check();
$this->contact_company = (int) $this->contact_company;
$this->contact_department = (int) $this->contact_department;
if (count($errorMsgArray) > 0) {
return $errorMsgArray;
}
/*
* This validates that any Contact saved will have a Display Name as
* required by various dropdowns, etc throughout the system. This is
* mostly required when Contacts are generated via programatic methods and
* not through the add/edit UI.
*/
if (mb_strlen($this->contact_order_by) <= 1 || $this->contact_order_by == null) {
//TODO: this should use the USERFORMAT to determine how display names are generated
if ($this->contact_first_name == null && $this->contact_last_name == null) {
$this->contact_order_by = $this->contact_email;
} else {
$this->contact_order_by = mb_trim($this->contact_first_name . ' ' . $this->contact_last_name);
}
}
if ($this->contact_first_name == null) {
$this->contact_first_name = '';
}
if ($this->contact_last_name == null) {
$this->contact_last_name = '';
}
if ($this->contact_birthday == '') {
$this->contact_birthday = null;
}
$q = new DBQuery();
$this->contact_lastupdate = $q->dbfnNow();
addHistory('contacts', $this->contact_id, 'store', $this->contact_first_name . ' ' . $this->contact_last_name, $this->contact_id);
parent::store();
}
public function store(CAppUI $AppUI = null)
{
global $AppUI;
$perms = $AppUI->acl();
$stored = false;
$this->w2PTrimAll();
$this->project_target_budget = str_replace(',', '', $this->project_target_budget);
// ensure changes of state in checkboxes is captured
$this->project_active = (int) $this->project_active;
$this->project_private = (int) $this->project_private;
$this->project_target_budget = $this->project_target_budget ? $this->project_target_budget : 0.0;
$this->project_actual_budget = $this->project_actual_budget ? $this->project_actual_budget : 0.0;
// Make sure project_short_name is the right size (issue for languages with encoded characters)
if (mb_strlen($this->project_short_name) > 10) {
$this->project_short_name = mb_substr($this->project_short_name, 0, 10);
}
if (empty($this->project_end_date)) {
$this->project_end_date = null;
}
$errorMsgArray = $this->check();
if (count($errorMsgArray) > 0) {
return $errorMsgArray;
}
$this->project_id = (int) $this->project_id;
// convert dates to SQL format first
if ($this->project_start_date) {
$date = new CDate($this->project_start_date);
$this->project_start_date = $date->format(FMT_DATETIME_MYSQL);
}
if ($this->project_end_date) {
$date = new CDate($this->project_end_date);
$date->setTime(23, 59, 59);
$this->project_end_date = $date->format(FMT_DATETIME_MYSQL);
}
if ($this->project_actual_end_date) {
$date = new CDate($this->project_actual_end_date);
$this->project_actual_end_date = $date->format(FMT_DATETIME_MYSQL);
}
// let's check if there are some assigned departments to project
if ('' != $this->project_actual_end_date) {
$obj->project_departments = implode(',', w2PgetParam($_POST, 'dept_ids', array()));
}
// check project parents and reset them to self if they do not exist
if (!$this->project_parent) {
$this->project_parent = $this->project_id;
$this->project_original_parent = $this->project_id;
} else {
$parent_project = new CProject();
$parent_project->load($this->project_parent);
$this->project_original_parent = $parent_project->project_original_parent;
}
if (!$this->project_original_parent) {
$this->project_original_parent = $this->project_id;
}
/*
* TODO: I don't like the duplication on each of these two branches, but I
* don't have a good idea on how to fix it at the moment...
*/
if ($this->project_id && $perms->checkModuleItem('projects', 'edit', $this->company_id)) {
$q = new DBQuery();
$this->project_updated = $q->dbfnNow();
if ($msg = parent::store()) {
return $msg;
}
addHistory('projects', $this->project_id, 'update', $this->project_name, $this->project_id);
$stored = true;
}
if (0 == $this->project_id && $perms->checkModuleItem('projects', 'add')) {
$q = new DBQuery();
$this->project_updated = $q->dbfnNow();
$this->project_created = $q->dbfnNow();
if ($msg = parent::store()) {
return $msg;
}
if (0 == $this->project_parent || 0 == $this->project_original_parent) {
$this->project_parent = $this->project_id;
$this->project_original_parent = $this->project_id;
if ($msg = parent::store()) {
return $msg;
}
}
addHistory('projects', $this->project_id, 'add', $this->project_name, $this->project_id);
$stored = true;
}
//split out related departments and store them seperatly.
$q = new DBQuery();
$q->setDelete('project_departments');
$q->addWhere('project_id=' . (int) $this->project_id);
$q->exec();
$q->clear();
if ($this->project_departments) {
$departments = explode(',', $this->project_departments);
foreach ($departments as $department) {
$q->addTable('project_departments');
$q->addInsert('project_id', $this->project_id);
$q->addInsert('department_id', $department);
$q->exec();
$q->clear();
}
}
//split out related contacts and store them seperatly.
$q->setDelete('project_contacts');
$q->addWhere('project_id=' . (int) $this->project_id);
$q->exec();
$q->clear();
if ($this->project_contacts) {
$contacts = explode(',', $this->project_contacts);
foreach ($contacts as $contact) {
if ($contact) {
$q->addTable('project_contacts');
$q->addInsert('project_id', $this->project_id);
$q->addInsert('contact_id', $contact);
$q->exec();
$q->clear();
}
}
}
if ($stored) {
$custom_fields = new CustomFields('projects', 'addedit', $this->project_id, 'edit');
$custom_fields->bind($_POST);
$sql = $custom_fields->store($this->project_id);
// Store Custom Fields
}
return $stored;
}