model->issues->get_one($defaults['issue']); // $this->coordinator = $issue->coordinator; // } else { // $this->coordinator = ''; // } // } // // public function __get($property) { // if ($property === 'coordinator') { // return $this->coordinator; // } // parent::__get($property); // } //} namespace dokuwiki\plugin\bez\mdl; use dokuwiki\plugin\bez\meta\Mailer; use dokuwiki\plugin\bez\meta\PermissionDeniedException; use dokuwiki\plugin\bez\meta\ValidationException; class Task extends Entity { protected $id; protected $original_poster, $assignee, $closed_by; protected $private, $lock; protected $state, $type; protected $create_date, $last_activity_date, $last_modification_date, $close_date; protected $cost, $plan_date, $all_day_event, $start_time, $finish_time; protected $content, $content_html; protected $thread_id, $thread_comment_id, $task_program_id; /** @var \dokuwiki\plugin\bez\mdl\Thread */ protected $thread; /** @var Thread_comment */ protected $thread_comment; //virtual protected $task_program_name; public static function get_columns() { return array('id', 'original_poster', 'assignee', 'closed_by', 'private', 'lock', 'state', 'type', 'create_date', 'last_activity_date', 'last_modification_date', 'close_date', 'cost', 'plan_date', 'all_day_event', 'start_time', 'finish_time', 'content', 'content_html', 'thread_id', 'thread_comment_id', 'task_program_id'); } public static function get_types() { return array('correction', 'corrective', 'preventive', 'program'); } public static function get_states() { return array('opened', 'done'); } public function __get($property) { if ($property == 'thread' || $property == 'thread_comment' || $property == 'task_program_name') { return $this->$property; } return parent::__get($property); } // private function state_string() { // switch($this->state) { // case '0': return 'task_opened'; // case '-outdated': return 'task_outdated'; // case '1': return 'task_done'; // case '2': return 'task_rejected'; // } // } // // private function action_string() { // switch($this->action) { // case '0': return 'correction'; // case '1': return 'corrective_action'; // case '2': return 'preventive_action'; // case '3': return 'programme'; // } // } // // public function cost_localized() { // if ($this->cost === '') { // return ''; // } // // return sprintf('%.2f', (float)$this->cost); // } // // private function update_virtual_columns() { // $this->state_string = $this->model->action->getLang($this->state_string()); // $this->action_string = $this->model->action->getLang($this->action_string()); // $this->tasktype_string = $this->model->tasktypes->get_one($this->tasktype)->type; // } // // public function user_is_executor() { // if ($this->executor === $this->model->user_nick || // $this->model->acl->get_level() >= BEZ_AUTH_ADMIN) { // return true; // } // } //by defaults you can set: cause, tasktype and issue //tasktype is required public function __construct($model, $defaults=array()) { parent::__construct($model, $defaults); //array(filter, NULL) $this->validator->set_rules(array( // 'reporter' => array(array('dw_user'), 'NOT NULL'), // 'date' => array(array('unix_timestamp'), 'NOT NULL'), // 'close_date' => array(array('unix_timestamp'), 'NULL'), // 'cause' => array(array('numeric'), 'NULL'), // 'executor' => array(array('dw_user'), 'NOT NULL'), // 'issue' => array(array('numeric'), 'NULL'), 'assignee' => array(array('dw_user'), 'NOT NULL'), 'cost' => array(array('numeric'), 'NULL'), 'plan_date' => array(array('iso_date'), 'NOT NULL'), 'all_day_event' => array(array('select', array('0', '1')), 'NOT NULL'), 'start_time' => array(array('time'), 'NULL'), 'finish_time' => array(array('time'), 'NULL'), 'content' => array(array('length', 10000), 'NOT NULL'), 'thread_comment_id' => array(array('numeric'), 'NULL'), 'task_program_id' => array(array('numeric'), 'NULL') // 'state' => array(array('select', array('0', '1', '2')), 'NULL'), // 'reason' => array(array('length', 10000), 'NULL'), // 'coordinator' => array(array('dw_user', array('-none')), 'NOT NULL'), )); //we've created empty object if ($this->id === NULL) { $this->original_poster = $this->model->user_nick; $this->create_date = date('c'); $this->last_activity_date = $this->create_date; $this->last_modification_date = $this->create_date; $this->state = 'opened'; if (isset($defaults['thread'])) { $this->thread = $defaults['thread']; $this->thread_id = $this->thread->id; $this->type = 'correction'; if (isset($defaults['thread_comment'])) { $this->thread_comment = $defaults['thread_comment']; $this->thread_comment_id = $this->thread_comment->id; if ($this->thread_comment->type == 'cause_real') { $this->type = 'corrective'; } else { $this->type = 'preventive'; } } } // //meta // $this->reporter = $this->model->user_nick; // $this->date = time(); // // $this->state = '0'; // $this->all_day_event = '1'; // // //throws ValidationException // $this->issue = $this->validator->validate_field('issue', $defaults['issue']); // // if ($this->issue !== '') { // $issue = $this->model->issues->get_one($defaults['issue']); // $this->coordinator = $issue->coordinator; // } else { // $this->coordinator = ''; // } // // //throws ValidationException // $this->validator->validate_field('cause', $defaults['cause']); // $this->cause = $defaults['cause']; // // //by default reporter is a executor // $this->executor = $this->reporter; //we get object form db } else { if ($this->thread_id != '') { if (isset($defaults['thread']) && $this->thread_id == $defaults['thread']->id) { $this->thread = $defaults['thread']; } elseif ($this->thread_id != null) { $this->thread = $this->model->threadFactory->get_one($this->thread_id); } if (isset($defaults['thread_comment']) && $this->thread_comment_id == $defaults['thread_comment']->id) { $this->thread_comment = $defaults['thread_comment']; } elseif ($this->thread_comment_id != null) { $this->thread_comment = $this->model->thread_commentFactory->get_one($this->thread_comment_id); } } } if ($this->thread_id == '') { $this->validator->set_rules(array( 'task_program_id' => array(array('numeric'), 'NOT NULL'), )); //this field is unused in program tasks $this->validator->delete_rule('thread_comment_id'); } // //close_date required // if ($this->state !== '0') { // $this->validator->set_rules(array( // 'close_date' => array(array('unix_timestamp'), 'NOT NULL') // )); // } //explode subscribents // if ($this->subscribents !== NULL) { // $exp_part = explode(',', $this->subscribents); // foreach ($exp_part as $subscribent) { // $this->subscribents_array[$subscribent] = $subscribent; // } // } // // //we've created empty object // if ($this->id === NULL) { // //throws ValidationException // $this->validator->validate_field('tasktype', $defaults['tasktype']); // $this->tasktype = $defaults['tasktype']; // } } public function set_data($post, $filter=NULL) { parent::set_data($post); $this->content_html = p_render('xhtml',p_get_instructions($this->content), $ignore); //update dates $this->last_modification_date = date('c'); $this->last_activity_date = $this->last_modification_date; //specjalne reguĊ‚y // if ($this->issue === '') { // $this->cause = ''; // } //set parsed // $this->task_cache = $this->helper->wiki_parse($this->task); // $this->reason_cache = $this->helper->wiki_parse($this->reason); //update virtuals //$this->update_virtual_columns(); return true; } public function set_state($state) { if ($this->acl_of('state') < BEZ_PERMISSION_CHANGE) { throw new PermissionDeniedException(); } if (!in_array($state, array('opened', 'done'))) { throw new ValidationException('task', array('sholud be opened or done')); } //nothing to do if ($state == $this->state) { return; } if ($state == 'done') { $this->model->sqlite->query("UPDATE {$this->get_table_name()} SET state=?, closed_by=?, close_date=? WHERE id=?", $state, $this->model->user_nick, date('c'), $this->id); //reopen the task } else { $this->model->sqlite->query("UPDATE {$this->get_table_name()} SET state=? WHERE id=?", $state, $this->id); } $this->state = $state; } public function update_last_activity() { $this->last_activity_date = date('c'); $this->model->sqlite->query('UPDATE task SET last_activity_date=? WHERE id=?', $this->last_activity_date, $this->id); } // public function update_cache() { // if ($this->model->acl->get_level() < BEZ_AUTH_ADMIN) { // return false; // } // $this->task_cache = $this->helper->wiki_parse($this->task); // $this->reason_cache = $this->helper->wiki_parse($this->reason); // } // // public function set_state($data) { // //reason is required while changing state // if ($data['state'] === '2') { // $this->validator->set_rules(array( // 'reason' => array(array('length', 10000), 'NOT NULL') // )); // } // // $val_data = $this->validator->validate($data, array('state', 'reason')); // if ($val_data === false) { // throw new ValidationException('tasks', $this->validator->get_errors()); // } // // //if state is changed // if ($this->state != $data['state']) { // $this->close_date = time(); // } // // $this->set_property_array($val_data); // $this->reason_cache = $this->helper->wiki_parse($this->reason); // // //update virtuals // $this->update_virtual_columns(); // // return true; // } // // public function get_meta_fields() { // return array('reporter', 'date', 'close_date'); // } // // public function set_meta($post) { // // if (isset($post['date'])) { // $unix = strtotime($post['date']); // //if $unix === false validator will catch it // if ($unix !== false) { // $post['date'] = (string)$unix; // } // } // // if (isset($post['close_date'])) { // $unix = strtotime($post['close_date']); // //if $unix === false validator will catch it // if ($unix !== false) { // $post['close_date'] = (string)$unix; // } // } // // parent::set_data($post, $this->get_meta_fields()); // } // // public function is_subscribent($user=NULL) { // if ($user === NULL) { // $user = $this->model->user_nick; // } // if (in_array($user, $this->subscribents_array)) { // return true; // } // return false; // } // // public function get_subscribents() { // return $this->subscribents_array; // } // // public function get_participants() { // $subscribents = array_merge(array($this->reporter, $this->executor), // $this->subscribents_array); // $full_names = array(); // foreach ($subscribents as $par) { // $name = $this->model->users->get_user_full_name($par); // if ($name == '') { // $full_names[$par] = $par; // } else { // $full_names[$par] = $name; // } // } // ksort($full_names); // return $full_names; // } // // public function remove_subscribent($subscribent) { // if ($subscribent !== $this->model->user_nick && // $this->acl_of('subscribents') < BEZ_PERMISSION_CHANGE) { // throw new PermissionDeniedException(); // } // // if ($this->issue != '') { // throw new ConsistencyViolationException('cannot modify subscribents from issue related tasks'); // } // // if (!isset($this->subscribents_array[$subscribent])) { // throw new ConsistencyViolationException('user '.$subscribent.' wasn\'t subscriber so cannot be removed'); // } // // unset($this->subscribents_array[$subscribent]); // $this->subscribents = implode(',', $this->subscribents_array); // } // // public function add_subscribent($subscribent) { // if ($subscribent !== $this->model->user_nick && // $this->acl_of('subscribents') < BEZ_PERMISSION_CHANGE) { // throw new PermissionDeniedException(); // } // // if ($this->issue != '') { // throw new ConsistencyViolationException('cannot add subscribents to issue related tasks'); // } // // if ($this->model->users->exists($subscribent) && // !in_array($subscribent, $this->subscribents_array)) { // $this->subscribents_array[$subscribent] = $subscribent; // $this->subscribents = implode(',', $this->subscribents_array); // // return true; // } // // return false; // } public function get_participants($filter='') { if ($this->acl_of('participants') < BEZ_PERMISSION_VIEW) { throw new PermissionDeniedException(); } if ($this->id === NULL) { return array(); } $sql = 'SELECT * FROM task_participant WHERE'; $possible_flags = array('original_poster', 'assignee', 'commentator', 'subscribent'); if ($filter != '') { if (!in_array($filter, $possible_flags)) { throw new \Exception("unknown flag $filter"); } $sql .= " $filter=1 AND"; } $sql .= ' task_id=? ORDER BY user_id'; $r = $this->model->sqlite->query($sql, $this->id); $pars = $this->model->sqlite->res2arr($r); $participants = array(); foreach ($pars as $par) { $participants[$par['user_id']] = $par; } return $participants; } public function get_participant($user_id) { if ($this->acl_of('participants') < BEZ_PERMISSION_VIEW) { throw new PermissionDeniedException(); } if ($this->id === NULL) { return array(); } $r = $this->model->sqlite->query('SELECT * FROM task_participant WHERE task_id=? AND user_id=?', $this->id, $user_id); $par = $this->model->sqlite->res2row($r); if (!is_array($par)) { return false; } return $par; } public function is_subscribent($user_id=null) { if ($user_id == null) { $user_id = $this->model->user_nick; } $par = $this->get_participant($user_id); if ($par['subscribent'] == 1) { return true; } return false; } public function remove_participant_flags($user_id, $flags) { if ($this->acl_of('participants') < BEZ_PERMISSION_CHANGE) { throw new PermissionDeniedException(); } //thread not saved yet if ($this->id === NULL) { throw new \Exception('cannot remove flags from not saved thread'); } $possible_flags = array('original_poster', 'assignee', 'commentator', 'subscribent'); if (array_intersect($flags, $possible_flags) != $flags) { throw new \Exception('unknown flags'); } $set = implode(',', array_map(function ($v) { return "$v=0"; }, $flags)); $sql = "UPDATE task_participant SET $set WHERE task_id=? AND user_id=?"; $this->model->sqlite->query($sql, $this->id, $user_id); } public function set_participant_flags($user_id, $flags=array()) { if ($this->acl_of('participants') < BEZ_PERMISSION_CHANGE) { throw new PermissionDeniedException(); } //thread not saved yet if ($this->id === NULL) { throw new \Exception('cannot add flags to not saved thread'); } //validate user if (!$this->model->userFactory->exists($user_id)) { throw new \Exception("$user_id isn't dokuwiki user"); } $possible_flags = array('original_poster', 'assignee', 'commentator', 'subscribent'); if (array_intersect($flags, $possible_flags) != $flags) { throw new \Exception('unknown flags'); } $participant = $this->get_participant($user_id); if ($participant == false) { $participant = array_fill_keys($possible_flags, 0); $participant['task_id'] = $this->id; $participant['user_id'] = $user_id; $participant['added_by'] = $this->model->user_nick; $participant['added_date'] = date('c'); } $values = array_merge($participant, array_fill_keys($flags, 1)); $keys = join(',', array_keys($values)); $vals = join(',', array_fill(0,count($values),'?')); $sql = "REPLACE INTO task_participant ($keys) VALUES ($vals)"; $this->model->sqlite->query($sql, array_values($values)); // if (! ( $this->user_is_coordinator() || // $participant === $this->model->user_nick || // $participant === $this->coordinator) //dodajemy nowego koordynatora // ) { // throw new PermissionDeniedException(); // } // if ($this->model->users->exists($participant)) { // $this->participants_array[$participant] = $participant; // $this->participants = implode(',', $this->participants_array); // } } public function invite($client) { $this->set_participant_flags($client, array('subscribent')); $this->mail_notify_invite($client); } private function mail_notify($replacements=array(), $users=false) { $plain = io_readFile($this->model->action->localFN('task-notification')); $html = io_readFile($this->model->action->localFN('task-notification', 'html')); $task_link = $this->model->action->url('task', 'tid', $this->id); $reps = array( 'task_id' => $this->id, 'task_link' => $task_link, 'who' => $this->original_poster ); //$replacements can override $reps $rep = array_merge($reps, $replacements); if (!isset($rep['who_full_name'])) { $rep['who_full_name'] = $this->model->userFactory->get_user_full_name($rep['who']); } //auto title if (!isset($rep['subject'])) { // if (isset($rep['content'])) { // $rep['subject'] = array_shift(explode('.', $rep['content'], 2)); // } $rep['subject'] = '#z'.$this->id. ' ' . $this->task_program_name; } //we must do it manually becouse Mailer uses htmlspecialchars() $html = str_replace('@TASK_TABLE@', $rep['task_table'], $html); $mailer = new Mailer(); $mailer->setBody($plain, $rep, $rep, $html, false); if ($users === FALSE) { $users = $this->get_participants('subscribent'); //don't notify current user unset($users[$this->model->user_nick]); } $emails = array_map(function($user) { return $this->model->userFactory->get_user_email($user); }, $users); $mailer->to($emails); $mailer->subject($rep['subject']); $send = $mailer->send(); if ($send === false) { //this may mean empty $emails //throw new Exception("can't send email"); } } protected function bez_html_array_to_style_list($arr) { $output = ''; foreach ($arr as $k => $v) { $output .= $k.': '. $v . ';'; } return $output; } protected function bez_html_irrtable($style) { $argv = func_get_args(); $argc = func_num_args(); if (isset($style['table'])) { $output = ''; } else { $output = '
'; } $tr_style = ''; if (isset($style['tr'])) { $tr_style = 'style="'.self::bez_html_array_to_style_list($style['tr']).'"'; } $td_style = ''; if (isset($style['td'])) { $td_style = 'style="'.self::bez_html_array_to_style_list($style['td']).'"'; } $row_max = 0; for ($i = 1; $i < $argc; $i++) { $row = $argv[$i]; $c = count($row); if ($c > $row_max) { $row_max = $c; } } for ($j = 1; $j < $argc; $j++) { $row = $argv[$j]; $output .= '' . NL; $c = count($row); for ($i = 0; $i < $c; $i++) { //last element if ($i === $c - 1 && $c < $row_max) { $output .= '' . NL; } $output .= '' . NL; } $output .= '
' . NL; } else { $output .= '' . NL; } $output .= $row[$i] . NL; $output .= '
' . NL; return $output; } public function mail_notify_task_box($users=false, $replacements=array()) { // if ($issue_obj !== NULL && $issue_obj->id !== $this->issue) { // throw new Exception('issue object id and task->issue does not match'); // } $top_row = array( ''.$this->model->action->getLang('executor').': ' . $this->model->userFactory->get_user_full_name($this->assignee), ''.$this->model->action->getLang('reporter').': ' . $this->model->userFactory->get_user_full_name($this->original_poster) ); if ($this->task_program_name != '') { $top_row[] = ''.$this->model->action->getLang('task_type').': ' . $this->task_program_name; } if ($this->cost != '') { $top_row[] = ''.$this->model->action->getLang('cost').': ' . $this->cost; } //BOTTOM ROW $bottom_row = array( ''.$this->model->action->getLang('plan_date').': ' . $this->plan_date ); if ($this->all_day_event == '0') { $bottom_row[] = ''.$this->model->action->getLang('start_time').': ' . $this->start_time; $bottom_row[] = ''.$this->model->action->getLang('finish_time').': ' . $this->finish_time; } $rep = array( 'content' => $this->content, 'content_html' => '

'. '' . '#z'.$this->id . ' ' . lcfirst($this->model->action->getLang('task_type_' . $this->type)) . ' ' . '(' . lcfirst($this->model->action->getLang('task_' . $this->state)) . ')' . '

' . self::bez_html_irrtable(array( 'table' => array( 'border-collapse' => 'collapse', 'font-size' => '0.8em', 'width' => '100%' ), 'td' => array( 'border-top' => '1px solid #8bbcbc', 'border-bottom' => '1px solid #8bbcbc', 'padding' => '.3em .5em' ) ), $top_row, $bottom_row) . $this->content_html, 'who' => $this->model->user_nick, 'when' => $this->create_date, 'custom_content' => true ); $rep['action_color'] = '#e4f4f4'; $rep['action_border_color'] = '#8bbcbc'; //$replacements can override $reps $rep = array_merge($rep, $replacements); // if ($this->thread == NULL) { // $this->mail_notify($rep, $users); // } else { // $this->thread->mail_notify($rep); // } $this->mail_notify($rep, $users); } public function mail_notify_subscribents($replacements=array()) { $this->mail_notify_task_box(false, $replacements); } public function mail_notify_add($users=false, $replacements=array()) { $replacements['action'] = $this->model->action->getLang('mail_task_added'); $this->mail_notify_task_box($users, $replacements); } public function mail_notify_remind($users=false) { $replacements = array(); $replacements['action'] = $this->model->action->getLang('mail_task_remind'); //we don't want any who $replacements['who_full_name'] = ''; //$users = array($this->executor); $this->mail_notify_task_box($users, $replacements); } public function mail_notify_invite($client) { $replacements = array(); $replacements['action'] = $this->model->action->getLang('mail_task_invite'); $users = array($client); $this->mail_notify_task_box($users, $replacements); } }