function translate_wo_status($progress = 0)
{
$wo_progress = wo_status_array();
if (isset($wo_progress[$progress])) {
return $wo_progress[$progress];
} else {
return __("Other");
}
}
private function showWorkOrder($message = "")
{
$system = System::getInstance();
$ui = Ui::getInstance();
$ui->createPage();
$back_href = "index.php?page=workorders&filter_status=0&filter_owner=" . $system->getConfig('id_user');
if ($this->id_workorder < 0) {
$title = __("Workorder");
} else {
$title = __("Workorder") . " #" . $this->id_workorder;
}
$ui->createDefaultHeader($title, $ui->createHeaderButton(array('icon' => 'back', 'pos' => 'left', 'text' => __('Back'), 'href' => $back_href)));
$ui->beginContent();
// Message popup
if ($message != "") {
$options = array('popup_id' => 'message_popup', 'popup_content' => $message);
$ui->addPopup($options);
$ui->contentAddHtml("<script type=\"text/javascript\">\n\t\t\t\t\t\t\t\t\t\t\$(document).on('pageshow', function() {\n\t\t\t\t\t\t\t\t\t\t\t\$(\"#message_popup\").popup(\"open\");\n\t\t\t\t\t\t\t\t\t\t});\n\t\t\t\t\t\t\t\t\t</script>");
}
$options = array('id' => 'form-workorder', 'action' => "index.php?page=workorder", 'method' => 'POST');
$ui->beginForm($options);
// Title
$options = array('name' => 'title', 'label' => __('Title'), 'value' => $this->title, 'placeholder' => __('Title'));
$ui->formAddInputText($options);
// Assigned user
$options = array('name' => 'assigned_user', 'id' => 'text-assigned_user', 'label' => __('Assigned user'), 'value' => $this->assigned_user, 'placeholder' => __('Assigned user'), 'autocomplete' => 'off');
$ui->formAddInputText($options);
// Assigned user autocompletion
// List
$ui->formAddHtml("<ul id=\"ul-autocomplete\" data-role=\"listview\" data-inset=\"true\"></ul>");
// Autocomplete binding
$ui->bindMobileAutocomplete("#text-assigned_user", "#ul-autocomplete");
// Status
$values = array();
if (get_db_value("need_external_validation", "ttodo", "id", $this->id_workorder)) {
$values = wo_status_array(0);
} else {
$values = wo_status_array(1);
}
$options = array('name' => 'status', 'title' => __('Status'), 'label' => __('Status'), 'items' => $values, 'selected' => $this->status);
$ui->formAddSelectBox($options);
// Priority
$values = array();
$values = get_priorities();
$options = array('name' => 'priority', 'title' => __('Priority'), 'label' => __('Priority'), 'items' => $values, 'selected' => $this->priority);
$ui->formAddSelectBox($options);
// Category
$workorders = get_db_all_rows_sql("SELECT id, name FROM two_category ORDER BY name");
$values = array();
if ($workorders) {
foreach ($workorders as $workorder) {
$values[$workorder[0]] = $workorder[1];
}
}
array_unshift($values, __('Any'));
$options = array('name' => 'category', 'title' => __('Category'), 'label' => __('Category'), 'items' => $values, 'selected' => $this->category);
$ui->formAddSelectBox($options);
// Task
$sql = "SELECT ttask.id, tproject.name, ttask.name\n\t\t\t\t\t\tFROM ttask, trole_people_task, tproject\n\t\t\t\t\t\tWHERE ttask.id_project = tproject.id\n\t\t\t\t\t\t\tAND tproject.disabled = 0\n\t\t\t\t\t\t\tAND ttask.id = trole_people_task.id_task\n\t\t\t\t\t\t\tAND trole_people_task.id_user = '******'id_user') . "'\n\t\t\t\t\t\tORDER BY tproject.name, ttask.name";
if (dame_admin($system->getConfig('id_user'))) {
$sql = "SELECT ttask.id, tproject.name, ttask.name \n\t\t\t\t\t\t\tFROM ttask, tproject\n\t\t\t\t\t\t\tWHERE ttask.id_project = tproject.id\n\t\t\t\t\t\t\t\tAND tproject.disabled = 0\n\t\t\t\t\t\t\tORDER BY tproject.name, ttask.name";
}
$tasks = get_db_all_rows_sql($sql);
$values = array();
$values[0] = __('N/A');
if ($tasks) {
foreach ($tasks as $task) {
$values[$task[0]] = array('optgroup' => $task[1], 'name' => $task[2]);
}
}
$selected = $this->id_task > 0 ? $this->id_task : 0;
$options = array('name' => 'id_task', 'title' => __('Task'), 'label' => __('Task'), 'items' => $values, 'selected' => $selected);
$ui->formAddSelectBox($options);
// Description
$options = array('name' => 'description', 'label' => __('Description'), 'value' => $this->description);
$ui->formAddHtml($ui->getTextarea($options));
// Hidden operation (insert or update+id)
if ($this->id_workorder < 0) {
$options = array('type' => 'hidden', 'name' => 'operation', 'value' => 'insert');
$ui->formAddInput($options);
// Submit button
$options = array('text' => __('Add'), 'data-icon' => 'plus');
$ui->formAddSubmitButton($options);
} else {
$options = array('type' => 'hidden', 'name' => 'operation', 'value' => 'update');
$ui->formAddInput($options);
$options = array('type' => 'hidden', 'name' => 'id_workorder', 'value' => $this->id_workorder);
$ui->formAddInput($options);
// Submit button
$options = array('text' => __('Update'), 'data-icon' => 'refresh');
$ui->formAddSubmitButton($options);
}
$ui->endForm();
$ui->endContent();
// Foooter buttons
// Add
if ($this->id_workorder < 0) {
$button_add = "<a onClick=\"\$('#form-workorder').submit();\" data-role='button' data-icon='plus'>" . __('Add') . "</a>\n";
} else {
$button_add = "<a onClick=\"\$('#form-workorder').submit();\" data-role='button' data-icon='refresh'>" . __('Update') . "</a>\n";
}
// Delete
$workorder_creator = get_db_value("created_by_user", "ttodo", "id", $this->id_workorder);
if ($this->id_workorder > 0 && (dame_admin($system->getConfig('id_user')) || $system->getConfig('id_user') == $workorder_creator)) {
$button_delete = "<a href='index.php?page=workorders&operation=delete&id_workorder=" . $this->id_workorder . "\n\t\t\t\t\t\t\t\t\t&filter_status=0&filter_owner=" . $system->getConfig('id_user') . "' data-ajax='false'\n\t\t\t\t\t\t\t\t\tdata-role='button' data-icon='delete'>" . __('Delete') . "</a>\n";
}
$ui->createFooter("<div data-type='horizontal' data-role='controlgroup'>{$button_add}" . "{$button_delete}</div>");
$ui->showFooter();
$ui->showPage();
}
$table->width = "100%";
$table->data[0][0] = print_input_text ("search_text", $search_text, "", 15, 100, true, __('Search'));
$table->data[0][1] = print_input_text_extended ('owner', $owner, 'text-user', '', 15, 30, false, '',
'', true, '', __('Owner'))
. print_help_tip (__("Type at least two characters to search"). ". " . __("Use '*' for get all values"), true);
$table->data[0][2] = print_input_text_extended ('creator', $creator, 'text-user2', '', 15, 30, false, '',
'', true, '', __('Submitter'))
. print_help_tip (__("Type at least two characters to search"), true);
$wo_status_values = wo_status_array ();
$table->data[1][0] = print_select ($wo_status_values, 'search_status', $search_status, '', __("Any"), -1, true, 0, false, __('WO Status') );
$priorities = get_priorities();
$table->data[1][1] = print_select ($priorities, 'search_priority', $search_priority, '', __("Any"), -1, true, 0, false, __('Priority') );
$avatar = get_db_value ('avatar', 'tusuario', 'id_usuario', $config["id_user"]);
if (!$avatar)
$avatar = "avatar1";
$table->data[1][2] = print_submit_button (__('Search'), "search_btn", false, 'class="sub search"', true);
$table->data[1][2] .= ' <a href="index.php?sec=projects&sec2=operation/workorders/wo&owner='
.$config["id_user"].'"><img src="images/avatars/'.$avatar.'.png" class="avatar_small" title="'.__('My WO\'s').'"></a>';
$table->data[1][2] .= ' <a href="index.php?sec=projects&sec2=operation/workorders/wo&creator='
.$config["id_user"].'"><img src="images/user_comment.png" title="'.__('My delegated WO\'s').'"></a>';
