$sql = array('id_project_task_items' => $pk, 'status' => '1');
$fields = array('id_project_task_items', 'id_project_task');
$model = new ProjectTaskItems();
$model->fields = $fields;
$rs = $model->get($sql);
$rsItem = $rs[0];
$sql = array('id_project_task_items' => $rsItem['id_project_task_items'], 'status' => '1');
$fields = array('id_member');
$model = new ProjectTaskItemsMemberSet();
$model->fields = $fields;
$rsItemMembers = $model->get($sql);
$sql = array('id_project_task' => $rsItem['id_project_task'], 'status' => '1');
$fields = array('id_project');
$model = new ProjectTask();
$model->fields = $fields;
$rs = $model->get($sql);
$rs = $rs[0];
$sql = array('id_project' => $rs['id_project'], 'status' => '2');
$fields = array('id_member');
$model = new ProjectMemberSet();
$model->fields = $fields;
$rs = $model->get($sql);
?>
<div class="modal-content">
<div class="modal-header">
<button class="close" onclick="boss.removeClass('modal_dialog', 'active')">x</button>
<h3 class="modal-title font-open-sans">Adicionar membro a tarefa</h3>
</div>
<form action="/app/task/create_item_member/" method="post" target="iframesubmit">
<input type="hidden" id="pk" name="pk" value="<?php
echo $pk;
$fields = array("id_project_task", "title", "comment");
$model = new ProjectTaskItems();
$model->fields = $fields;
$rs = $model->get($sql);
$rs = $rs[0];
$sql = array('id_project_task' => $rs['id_project_task'], 'status' => 1);
$model = new ProjectTask();
$fields = array("title", "id_project");
$model->fields = $fields;
$rsTask = $model->get($sql);
$rsTask = $rsTask[0];
$sql = array('id_project' => $rsTask['id_project'], 'status' => 1);
$model = new ProjectTask();
$fields = array("title", "id_project", "id_project_task");
$model->fields = $fields;
$rsTask = $model->get($sql);
?>
<div class="modal-content">
<div class="modal-header">
<button class="close" onclick="boss.removeClass('modal_dialog', 'active')">x</button>
<h3 class="modal-title font-open-sans">Arquiva Tarefa</h3>
</div>
<form action="/app/task/move_item/" method="post" target="iframesubmit">
<input type="hidden" id="pk" name="pk" value="<?php
echo $pk;
?>
">
<input type="hidden" id="arquiva" name="arquiva" value="0">
<div class="modal-body">
<p class="font-open-sans bleed-bottom">Para mover a tarefa para uma lista especifica onde deseja arquiva suas tarefas, escolha um cartão e clique em "Mover tarefa", se não clique em "Arquiva".</p>
<div class="container">
$model->fields = array('status' => 0);
$update = $model->update($sql);
if ($update) {
$sql = array('id_project_task_items_comments' => $pk);
$model->fields = array('id_project_task_items');
$rsComments = $model->get($sql);
$rsComment = $rsComments[0];
$query = array("id_project_task_items" => $rsComment['id_project_task_items'], "status" => 1);
$project = new ProjectTaskItems();
$project->fields = array('id_project_task_items', 'id_project_task');
$rsItem = $project->get($query);
$rsItem = $rsItem[0];
$sql = array('id_project_task' => $rsItem['id_project_task'], 'status' => 1);
$project = new ProjectTask();
$project->fields = array('id_project');
$rs = $project->get($sql);
$rs = $rs[0];
?>
<script>
var timePopup = setTimeout(function(){
window.parent.boss.removeClass('modal_dialog', 'active');
window.parent.boss.ajax.load('/app/task/view_task/?pk=<?php
echo $rs["id_project"];
?>
', '#app_pane_body');
}, 100);
window.parent.$('#modal_window').empty();
window.parent.boss.ajax.load('/app/task/view_item/?pk=<?php
echo $rsItem["id_project_task_items"];
?>
', '#modal_window', 'active');
<?php
require_once 'init.php';
use Agil\View\View;
$request = View::route($_GET);
$pk = $request['pk'];
$sql = array("id_project" => $pk, "status" => 1);
$fields = array("id_project_task", "id_project", "title", "color");
$model = new ProjectTask();
$model->fields = $fields;
$tasks = $model->get($sql);
$agil = new ProjectMethod();
$count = $agil->count($sql);
if ($count == 1) {
$agil = $agil->get($sql);
$agil = $agil[0]['agil_method'];
}
?>
<div id="app_pane_body" class="app-pane-body" style="background-color:#F9F9F9;">
<div class="board-wrapper">
<div class="board-surface fancy-scrollbar">
<?php
if (count($tasks) > 0) {
$i = 1;
foreach ($tasks as $index => $task) {
?>
<div class="board-list">
<div class="board-list-content fancy-scrollbar btn-<?php
echo $task['color'];
?>
">
if ($request['METHOD'] == 'POST' && !empty($request['pk']) && Session::exist('logado') && (!empty($request['delete']) || !empty($request['title']) || !empty($request['comment']))) {
$title = $request['title'];
$comment = $request['comment'];
$pk = $request['pk'];
$delete = $request['delete'];
$model = new ProjectTaskItems();
$sql = array('id_project_task_items' => $pk, 'status' => '1');
$fields = array("id_project_task");
$model->fields = $fields;
$rs = $model->get($sql);
$rs = $rs[0];
$query = array('id_project_task' => $rs['id_project_task'], 'status' => '1');
$modelProject = new ProjectTask();
$fields = array("id_project");
$modelProject->fields = $fields;
$rs = $modelProject->get($query);
$rs = $rs[0];
if ($delete) {
$model->fields = array('status' => '0');
$update = $model->update($sql);
if ($update) {
?>
<script>
var timePopup = setTimeout(function(){
window.parent.boss.ajax.load('/app/task/view_task/?pk=<?php
echo $rs["id_project"];
?>
', '#app_pane_body');
window.parent.boss.removeClass('modal_dialog', 'active');
}, 100);
window.parent.boss.popup("Tarefa deletada com sucesso.");
window.parent.boss.popup("Esse(s) membro(s) já estão participando desta tarefa.");
</script>
<?php
die;
}
}
if ($project_task_items_member_set) {
$query = array('id_project_task_items' => $pk, 'status' => '1');
$project_task_items = new ProjectTaskItems();
$project_task_items->fields = array('id_project_task', 'id_project_task_items', 'title', 'comment');
$rsItem = $project_task_items->get($query, 'id_project_task_items DESC');
$rsItem = $rsItem[0];
$sql = array('id_project_task' => $rsItem['id_project_task'], 'status' => '1');
$projectTask = new ProjectTask();
$projectTask->fields = array('id_project');
$rsprojectTask = $projectTask->get($sql);
$rsprojectTask = $rsprojectTask[0];
?>
<script>
var timePopup = setTimeout(function(){
window.parent.boss.removeClass('modal_dialog', 'active');
}, 100);
window.parent.boss.ajax.load('/app/task/view_task/?pk=<?php
echo $rsprojectTask["id_project"];
?>
', '#app_pane_body');
window.parent.boss.popup("Membro(s) adicionados com sucesso.");
</script>
<?php
}
}
</div>
</div>
<div class="col-8 pull-left">
<div class="card">
<div class="card-content">
<h3 class="font-open-sans">Últimas tarefas</h3>
</div>
</div>
<?php
if ($count) {
foreach ($projects as $project) {
$sql = array("id_project" => $project['id_project'], "status" => 1);
$fields = array("id_project_task", "title", "color");
$model = new ProjectTask();
$model->fields = $fields;
$tasks = $model->get($sql, 'id_project_task ASC');
foreach ($tasks as $task) {
$query = array("id_project_task" => $task['id_project_task'], "status" => 1);
$fields = array("id_project_task_items", "title", "comment");
$model = new ProjectTaskItems();
$model->fields = $fields;
$items = $model->get($query, 'id_project_task_items DESC', '3');
foreach ($items as $item) {
$border = "border-left-" . $task['color'];
?>
<div class="card card-effect <?php
echo $border;
?>
" onclick="$('#modal_window').empty(); boss.ajax.load('/app/task/view_item/?pk=<?php
echo $item['id_project_task_items'];
?>
$count = $model->count($sql);
if ($count != 0) {
?>
<script>
var timePopup = setTimeout(function(){
window.parent.boss.removeClass('modal_dialog', 'active');
}, 100);
</script>
<?php
} else {
$query = array('id_project_task' => $card, 'status' => '1');
$sql = array('id_project_task_items' => $pk, 'status' => '1');
$modelTask = new ProjectTask();
$fields = array("id_project");
$modelTask->fields = $fields;
$rs = $modelTask->get($query);
$rs = $rs[0];
$model->fields = array('id_project_task' => $card);
$update = $model->update($sql);
if ($update) {
?>
<script>
var timePopup = setTimeout(function(){
window.parent.boss.ajax.load('/app/task/view_task/?pk=<?php
echo $rs["id_project"];
?>
', '#app_pane_body');
window.parent.boss.removeClass('modal_dialog', 'active');
}, 100);
window.parent.boss.popup("Sucesso ao atualizar tarefa.");
</script>
