/**
* Return manager instance
*
* @access protected
* @param void
* @return TemplateParameters
*/
function manager() {
if(!($this->manager instanceof TemplateObjectProperties)) $this->manager = TemplateObjectProperties::instance();
return $this->manager;
} // manager
/**
* Delete this object and reset all relationship. This function will not delete any of related objec
*
* @access public
* @param void
* @return boolean
*/
function delete()
{
// permanently delete objects set as template (were created specifically for this template)
$objs = $this->getObjects();
foreach ($objs as $o) {
if ($o->isTemplate()) {
$o->delete();
}
}
$this->removeObjects();
TemplateParameters::deleteParametersByTemplate($this->getId());
TemplateObjectProperties::deletePropertiesByTemplate($this->getId());
parent::delete();
}
function instantiate()
{
$selected_members = array();
$id = get_id();
$template = COTemplates::findById($id);
if (!$template instanceof COTemplate) {
flash_error(lang("template dnx"));
ajx_current("empty");
return;
}
$parameters = TemplateParameters::getParametersByTemplate($id);
$parameterValues = array_var($_POST, 'parameterValues');
if (count($parameters) > 0 && !isset($parameterValues)) {
ajx_current("back");
return;
}
if (array_var($_POST, 'members')) {
$selected_members = json_decode(array_var($_POST, 'members'));
} else {
$context = active_context();
foreach ($context as $selection) {
if ($selection instanceof Member) {
$selected_members[] = $selection->getId();
}
}
}
$objects = $template->getObjects();
$controller = new ObjectController();
if (count($selected_members > 0)) {
$selected_members_instances = Members::findAll(array('conditions' => 'id IN (' . implode($selected_members) . ')'));
} else {
$selected_members_instances = array();
}
DB::beginWork();
$active_context = active_context();
foreach ($objects as $object) {
if (!$object instanceof ContentDataObject) {
continue;
}
// copy object
$copy = $object->copy();
if ($copy->columnExists('is_template')) {
$copy->setColumnValue('is_template', false);
}
if ($copy instanceof ProjectTask) {
// don't copy parent task and milestone
$copy->setMilestoneId(0);
$copy->setParentId(0);
}
$copy->save();
/* if (!can_write(logged_user(), $selected_members_instances, $copy->getObjectTypeId()) ) {
flash_error(lang('no context permissions to add', $copy instanceof ProjectTask ? lang("tasks") : ($copy instanceof ProjectMilestone ? lang('milestones') : '')));
DB::rollback();
ajx_current("empty");
return;
}*/
// Copy members from origial object, if it doesn't have then use active context members
/* $template_object_members = $object->getMemberIds();
if (count($template_object_members) == 0) {
$object_member_ids = active_context_members(false);
if (count($object_member_ids) > 0) {
$template_object_members = Members::findAll(array("id" => true, "conditions" => "id IN (".implode(",", $object_member_ids).")"));
}
}*/
/* Set instantiated object members:
* foreach dimension:
* if no member is active then the instantiated object is put in the same members as the original for current dimension
* if a member is selected in current dimension then the instantiated object will be put in that member
*/
$template_object_members = $object->getMembers();
$object_members = array();
foreach ($active_context as $selection) {
if ($selection instanceof Member) {
// member selected
$object_members[] = $selection->getId();
} else {
if ($selection instanceof Dimension) {
// no member selected
foreach ($template_object_members as $tom) {
if ($tom->getDimensionId() == $selection->getId()) {
$object_members[] = $tom->getId();
}
}
}
}
}
$controller->add_to_members($copy, $object_members);
// copy linked objects
$copy->copyLinkedObjectsFrom($object);
// copy subtasks if applicable
if ($copy instanceof ProjectTask) {
ProjectTasks::copySubTasks($object, $copy, false);
foreach ($copy->getOpenSubTasks(false) as $m_task) {
$controller->add_to_members($m_task, $object_members);
}
$manager = $copy->manager();
} else {
if ($copy instanceof ProjectMilestone) {
ProjectMilestones::copyTasks($object, $copy, false);
foreach ($copy->getTasks(false) as $m_task) {
$controller->add_to_members($m_task, $object_members);
}
$manager = $copy->manager();
}
}
// copy custom properties
$copy->copyCustomPropertiesFrom($object);
// set property values as defined in template
$objProp = TemplateObjectProperties::getPropertiesByTemplateObject($id, $object->getId());
foreach ($objProp as $property) {
$propName = $property->getProperty();
$value = $property->getValue();
if ($manager->getColumnType($propName) == DATA_TYPE_STRING || $manager->getColumnType($propName) == DATA_TYPE_INTEGER) {
if (is_array($parameterValues)) {
foreach ($parameterValues as $param => $val) {
if (strpos($value, '{' . $param . '}') !== FALSE) {
$value = str_replace('{' . $param . '}', $val, $value);
}
}
}
} else {
if ($manager->getColumnType($propName) == DATA_TYPE_DATE || $manager->getColumnType($propName) == DATA_TYPE_DATETIME) {
$operator = '+';
if (strpos($value, '+') === false) {
$operator = '-';
}
$opPos = strpos($value, $operator);
if ($opPos !== false) {
// Is parametric
$dateParam = substr($value, 1, strpos($value, '}') - 1);
$date = $parameterValues[$dateParam];
$dateUnit = substr($value, strlen($value) - 1);
// d, w or m (for days, weeks or months)
if ($dateUnit == 'm') {
$dateUnit = 'M';
// make month unit uppercase to call DateTimeValue::add with correct parameter
}
$dateNum = (int) substr($value, strpos($value, $operator), strlen($value) - 2);
$date = DateTimeValueLib::dateFromFormatAndString(user_config_option('date_format'), $date);
$date = new DateTimeValue($date->getTimestamp() - logged_user()->getTimezone() * 3600);
// set date to GMT 0
$value = $date->add($dateUnit, $dateNum);
} else {
$value = DateTimeValueLib::dateFromFormatAndString(user_config_option('date_format'), $value);
}
}
}
if ($value != '') {
if (!$copy->setColumnValue($propName, $value)) {
$copy->object->setColumnValue($propName, $value);
}
$copy->save();
}
}
// subscribe assigned to
if ($copy instanceof ProjectTask) {
foreach ($copy->getOpenSubTasks(false) as $m_task) {
if ($m_task->getAssignedTo() instanceof Contact) {
$m_task->subscribeUser($copy->getAssignedTo());
}
}
if ($copy->getAssignedTo() instanceof Contact) {
$copy->subscribeUser($copy->getAssignedTo());
}
} else {
if ($copy instanceof ProjectMilestone) {
foreach ($copy->getTasks(false) as $m_task) {
if ($m_task->getAssignedTo() instanceof Contact) {
$m_task->subscribeUser($copy->getAssignedTo());
}
}
}
}
// copy reminders
$reminders = ObjectReminders::getByObject($object);
foreach ($reminders as $reminder) {
$copy_reminder = new ObjectReminder();
$copy_reminder->setContext($reminder->getContext());
$reminder_date = $copy->getColumnValue($reminder->getContext());
if ($reminder_date instanceof DateTimeValue) {
$reminder_date = new DateTimeValue($reminder_date->getTimestamp());
$reminder_date->add('m', -$reminder->getMinutesBefore());
}
$copy_reminder->setDate($reminder_date);
$copy_reminder->setMinutesBefore($reminder->getMinutesBefore());
$copy_reminder->setObject($copy);
$copy_reminder->setType($reminder->getType());
$copy_reminder->setUserId($reminder->getUserId());
$copy_reminder->save();
}
}
DB::commit();
if (is_array($parameters) && count($parameters) > 0) {
ajx_current("back");
} else {
if (!$choose_ctx) {
ajx_current("back");
} else {
ajx_current("reload");
}
}
}
function edit()
{
if (!can_manage_templates(logged_user())) {
flash_error(lang("no access permissions"));
ajx_current("empty");
return;
}
$this->setTemplate('add');
$cotemplate = COTemplates::findById(get_id());
if (!$cotemplate instanceof COTemplate) {
flash_error(lang('template dnx'));
ajx_current("empty");
return;
}
// if
if (!$cotemplate->canEdit(logged_user())) {
flash_error(lang('no access permissions'));
ajx_current("empty");
return;
}
// if
$template_data = array_var($_POST, 'template');
$object_properties = array();
if (!is_array($template_data)) {
$template_data = array('name' => $cotemplate->getObjectName(), 'description' => $cotemplate->getDescription());
// array
foreach ($cotemplate->getObjects() as $obj) {
$object_properties[$obj->getObjectId()] = TemplateObjectProperties::getPropertiesByTemplateObject(get_id(), $obj->getObjectId());
}
//delete old temporaly template tasks
self::deleteOldTemporalyTemplateObj();
} else {
$cotemplate->setFromAttributes($template_data);
try {
$member_ids = json_decode(array_var($_POST, 'members'));
DB::beginWork();
$tmp_objects = $cotemplate->getObjects();
$cotemplate->removeObjects();
$cotemplate->save();
$objects = array_var($_POST, 'objects');
foreach ($objects as $objid) {
$object = Objects::findObject($objid);
$additional_attributes = array();
if ($object instanceof ProjectTask) {
$add_attr_milestones = array_var($_POST, "milestones");
if (is_array($add_attr_milestones)) {
$additional_attributes['milestone'] = array_var($add_attr_milestones, $objid);
}
}
$oid = $cotemplate->addObject($object, $additional_attributes);
$object_ids[$objid] = $oid;
}
TemplateObjectProperties::deletePropertiesByTemplate(get_id());
$objectPropertyValues = array_var($_POST, 'propValues');
$propValueParams = array_var($_POST, 'propValueParam');
$propValueOperation = array_var($_POST, 'propValueOperation');
$propValueAmount = array_var($_POST, 'propValueAmount');
$propValueUnit = array_var($_POST, 'propValueUnit');
if (is_array($objectPropertyValues)) {
foreach ($objectPropertyValues as $objInfo => $propertyValues) {
foreach ($propertyValues as $property => $value) {
if (!isset($object_ids[$objInfo])) {
$object_ids[$objInfo] = $objInfo;
}
$split = explode(":", $objInfo);
$templateObjPropValue = new TemplateObjectProperty();
$templateObjPropValue->setTemplateId($cotemplate->getId());
$templateObjPropValue->setObjectId($object_ids[$objInfo]);
$templateObjPropValue->setProperty($property);
$propValue = '';
if (isset($propValueParams[$objInfo][$property])) {
$param = $propValueParams[$objInfo][$property];
$operation = array_var($propValueOperation[$objInfo], $property);
$amount = array_var($propValueAmount[$objInfo], $property);
$unit = array_var($propValueUnit[$objInfo], $property);
$propValue = '{' . $param . '}' . $operation . $amount . $unit;
} else {
if (is_array($value)) {
$propValue = $value[0];
} else {
$propValue = $value;
}
}
$templateObjPropValue->setValue($propValue);
$templateObjPropValue->save();
}
}
}
TemplateParameters::deleteParametersByTemplate(get_id());
$parameters = array_var($_POST, 'parameters');
if (is_array($parameters)) {
foreach ($parameters as $parameter) {
$newTemplateParameter = new TemplateParameter();
$newTemplateParameter->setTemplateId($cotemplate->getId());
$newTemplateParameter->setName(rtrim($parameter['name'], " "));
$newTemplateParameter->setType($parameter['type']);
$newTemplateParameter->setDefaultValue(array_var($parameter, 'default_value'));
Hook::fire('template_parameter_default_value', array('parameter' => $parameter), $newTemplateParameter);
$newTemplateParameter->save();
}
}
//delete permanently objs
foreach ($tmp_objects as $obj) {
if (is_null($objects)) {
$objects = array();
}
if (!in_array($obj->getId(), $objects)) {
$obj->delete();
}
}
DB::commit();
ApplicationLogs::createLog($cotemplate, ApplicationLogs::ACTION_EDIT);
flash_success(lang("success edit template"));
ajx_current("back");
} catch (Exception $e) {
DB::rollback();
flash_error($e->getMessage());
ajx_current("empty");
}
}
$objects = $this->add_template_object_to_view($cotemplate->getId());
tpl_assign('object_properties', $object_properties);
tpl_assign('parameters', TemplateParameters::getParametersByTemplate(get_id()));
tpl_assign('objects', $objects);
tpl_assign('cotemplate', $cotemplate);
tpl_assign('template_data', $template_data);
}
function instantiate()
{
$id = get_id();
$template = COTemplates::findById($id);
if (!$template instanceof COTemplate) {
flash_error(lang("template dnx"));
ajx_current("empty");
return;
}
$parameters = TemplateParameters::getParametersByTemplate($id);
$parameterValues = array_var($_POST, 'parameterValues');
if (count($parameters) > 0 && !isset($parameterValues)) {
ajx_current("back");
return;
}
$objects = $template->getObjects();
foreach ($objects as $object) {
if (!$object instanceof ProjectDataObject) {
continue;
}
// copy object
$copy = $object->copy();
if ($copy->columnExists('is_template')) {
$copy->setColumnValue('is_template', false);
}
if ($copy instanceof ProjectTask) {
// don't copy parent task and milestone
$copy->setMilestoneId(0);
$copy->setParentId(0);
}
$copy->save();
$wsId = array_var($_POST, 'project_id', active_or_personal_project()->getId());
// if specified, set workspace
$workspace = Projects::findById($wsId);
if (!$workspace instanceof Project) {
$workspace = active_or_personal_project();
}
$copy->addToWorkspace($workspace);
// add object tags and specified tags
$tags = implode(',', $object->getTagNames());
$copy->setTagsFromCSV($tags . "," . array_var($_POST, 'tags'));
// copy linked objects
$copy->copyLinkedObjectsFrom($object);
// copy subtasks if applicable
if ($copy instanceof ProjectTask) {
ProjectTasks::copySubTasks($object, $copy, false);
$manager = new ProjectTask();
} else {
if ($copy instanceof ProjectMilestone) {
ProjectMilestones::copyTasks($object, $copy, false);
$manager = new ProjectMilestone();
}
}
// copy custom properties
$copy->copyCustomPropertiesFrom($object);
// set property values as defined in template
$objProp = TemplateObjectProperties::getPropertiesByTemplateObject($id, $object->getId());
foreach ($objProp as $property) {
$propName = $property->getProperty();
$value = $property->getValue();
if ($manager->getColumnType($propName) == DATA_TYPE_STRING) {
if (is_array($parameterValues)) {
foreach ($parameterValues as $param => $val) {
$value = str_replace('{' . $param . '}', $val, $value);
}
}
} else {
if ($manager->getColumnType($propName) == DATA_TYPE_DATE || $manager->getColumnType($propName) == DATA_TYPE_DATETIME) {
$operator = '+';
if (strpos($value, '+') === false) {
$operator = '-';
}
$opPos = strpos($value, $operator);
if ($opPos !== false) {
$dateParam = substr($value, 1, strpos($value, '}') - 1);
$dateUnit = substr($value, strlen($value) - 1);
// d, w or m (for days, weeks or months)
if ($dateUnit == 'm') {
$dateUnit = 'M';
// make month unit uppercase to call DateTimeValue::add with correct parameter
}
$dateNum = (int) substr($value, strpos($value, $operator), strlen($value) - 2);
$date = $parameterValues[$dateParam];
$date = DateTimeValueLib::dateFromFormatAndString(user_config_option('date_format'), $date);
$value = $date->add($dateUnit, $dateNum);
}
} else {
if ($manager->getColumnType($propName) == DATA_TYPE_INTEGER) {
if (is_array($parameterValues)) {
foreach ($parameterValues as $param => $val) {
$value = str_replace('{' . $param . '}', $val, $value);
}
}
}
}
}
if ($value != '') {
$copy->setColumnValue($propName, $value);
$copy->save();
}
}
//copy assigned to company if applicable
if ($copy->getAssignedToUserId() != 0) {
$copy->setAssignedToCompanyId($copy->getAssignedTo()->getCompanyId());
$copy->save();
}
// copy reminders
$reminders = ObjectReminders::getByObject($object);
foreach ($reminders as $reminder) {
$copy_reminder = new ObjectReminder();
$copy_reminder->setContext($reminder->getContext());
$reminder_date = $copy->getColumnValue($reminder->getContext());
if ($reminder_date instanceof DateTimeValue) {
$reminder_date = new DateTimeValue($reminder_date->getTimestamp());
$reminder_date->add('m', -$reminder->getMinutesBefore());
}
$copy_reminder->setDate($reminder_date);
$copy_reminder->setMinutesBefore($reminder->getMinutesBefore());
$copy_reminder->setObject($copy);
$copy_reminder->setType($reminder->getType());
$copy_reminder->setUserId($reminder->getUserId());
$copy_reminder->save();
}
}
if (is_array($parameters) && count($parameters) > 0) {
ajx_current("back");
} else {
ajx_current("reload");
}
}
/**
* This function will return paginated result. Result is an array where first element is
* array of returned object and second populated pagination object that can be used for
* obtaining and rendering pagination data using various helpers.
*
* Items and pagination array vars are indexed with 0 for items and 1 for pagination
* because you can't use associative indexing with list() construct
*
* @access public
* @param array $arguments Query argumens (@see find()) Limit and offset are ignored!
* @param integer $items_per_page Number of items per page
* @param integer $current_page Current page number
* @return array
*/
function paginate($arguments = null, $items_per_page = 10, $current_page = 1)
{
if (isset($this) && instance_of($this, 'TemplateObjectProperties')) {
return parent::paginate($arguments, $items_per_page, $current_page);
} else {
return TemplateObjectProperties::instance()->paginate($arguments, $items_per_page, $current_page);
}
// if
}
function instantiate_template_task_parameters(TemplateTask $object, ProjectTask $copy, $parameterValues = array())
{
$objProp = TemplateObjectProperties::getPropertiesByTemplateObject($object->getTemplateId(), $object->getId());
$manager = $copy->manager();
foreach ($objProp as $property) {
$propName = $property->getProperty();
$value = $property->getValue();
if ($manager->getColumnType($propName) == DATA_TYPE_STRING || $manager->getColumnType($propName) == DATA_TYPE_INTEGER) {
if (is_array($parameterValues)) {
$is_present = false;
foreach ($parameterValues as $param => $val) {
if (strpos($value, '{' . $param . '}') !== FALSE) {
$value = str_replace('{' . $param . '}', $val, $value);
$is_present = true;
}
}
// if parameter not present replace the parameter code with empty string
if (!$is_present) {
$value = preg_replace('/[{].*[}]/U', '', $value);
}
}
} else {
if ($manager->getColumnType($propName) == DATA_TYPE_DATE || $manager->getColumnType($propName) == DATA_TYPE_DATETIME) {
$operator = '+';
if (strpos($value, '+') === false) {
$operator = '-';
}
$opPos = strpos($value, $operator);
if ($opPos !== false) {
// Is parametric
$dateParam = substr($value, 1, strpos($value, '}') - 1);
if ($dateParam == 'task_creation') {
$date = DateTimeValueLib::now();
} else {
$date = getDateValue($parameterValues[$dateParam]);
if (!$date instanceof DateTimeValue) {
$date = DateTimeValueLib::now();
}
if ($copy instanceof ProjectTask && config_option('use_time_in_task_dates') && $propName == "due_date") {
$copy->setUseDueTime(1);
$hour_min = getTimeValue(user_config_option('work_day_end_time'));
$hour_min['hours'];
$hour_min['mins'];
$date->setHour($hour_min['hours']);
$date->setMinute($hour_min['mins']);
$date = $date->add('s', -logged_user()->getTimezone() * 3600);
}
if ($copy instanceof ProjectTask && config_option('use_time_in_task_dates') && $propName == "start_date") {
$copy->setUseStartTime(1);
$hour_min = getTimeValue(user_config_option('work_day_start_time'));
$hour_min['hours'];
$hour_min['mins'];
$date->setHour($hour_min['hours']);
$date->setMinute($hour_min['mins']);
$date = $date->add('s', -logged_user()->getTimezone() * 3600);
}
}
$dateUnit = substr($value, strlen($value) - 1);
// d, w or m (for days, weeks or months)
if ($dateUnit == 'm') {
$dateUnit = 'M';
// make month unit uppercase to call DateTimeValue::add with correct parameter
}
$dateNum = (int) substr($value, strpos($value, $operator), strlen($value) - 2);
//Hook::fire('template_param_date_calculation', array('op' => $operator, 'date' => $date, 'template_id' => $object->getTemplateId(), 'original' => $object, 'copy' => $copy), $dateNum);
$value = $date->add($dateUnit, $dateNum);
} else {
$value = DateTimeValueLib::dateFromFormatAndString(user_config_option('date_format'), $value);
}
}
}
if ($value != '') {
if (!$copy->setColumnValue($propName, $value)) {
$copy->object->setColumnValue($propName, $value);
}
if ($propName == 'text' && $copy->getTypeContent() == 'text') {
$copy->setText(html_to_text($copy->getText()));
}
$copy->save();
}
}
// Ensure that assigned user is subscribed
if ($copy instanceof ProjectTask && $copy->getAssignedTo() instanceof Contact) {
$copy->subscribeUser($copy->getAssignedTo());
}
$ret = null;
Hook::fire('after_template_object_param_instantiation', array('template_id' => $object->getTemplateId(), 'original' => $object, 'copy' => $copy, 'parameter_values' => $parameterValues), $ret);
}
