API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 14th, 2020
150
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 33.93 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. /**
  4.  * @description api react for issue log
  5.  * @author Ilya Khalizov, Ilia Kovalenko
  6.  */
  7.  
  8. class issueLogController extends apiController
  9. {
  10.     /**
  11.      * equels issue id
  12.      */
  13.     private $_page_id;
  14.  
  15.     public function __construct()
  16.     {
  17.         parent::__construct();
  18.         require_once ROOT_DIR . '/plugins/function.imageurl.php';
  19.         if ($this->_input['data']) {
  20.             $data = json_decode($this->_input['data']);
  21.             $this->_page_id = (int)$data->page_id;
  22.         } else {
  23.             $this->_page_id = (int)$this->_input['page_id'];
  24.         }
  25.     }
  26.  
  27.     /**
  28.      * @description get issue's log
  29.      * @return object
  30.      */
  31.     public function listAction()
  32.     {
  33.         if ($this->_input['page_id'] > 0) {
  34.             $this->_result = IssueLog::findById($this->_input['page_id']);
  35.         } else {
  36.             $this->_result = IssueLog::findByFilterParams($this->_input);
  37.         }
  38.  
  39.         $this->_result['allow_change_filds'] = IssueLog::checkEditAccess($this->_input['page_id']);
  40.         $this->_result['allow_change_filds_creator'] = IssueLog::getAllowedToChangeIssueStatusIds(
  41.             $this->_loggedUser->get('username')
  42.         );
  43.         $this->_result['admin'] = $this->_loggedUser->get('admin');
  44.         $this->output();
  45.     }
  46.  
  47.     /**
  48.      * @description get issue's log on short format
  49.      * @return object
  50.      */
  51.     public function shortListAction()
  52.     {
  53.         $this->_result = IssueLog::findByFilterParamsShort($this->_input);
  54.         $this->_result['allow_change_filds'] = IssueLog::checkEditAccess($this->_input['page_id']);
  55.         $this->_result['allow_change_filds_creator'] = IssueLog::getAllowedToChangeIssueStatusIds(
  56.             $this->_loggedUser->get('username')
  57.         );
  58.         $this->_result['admin'] = $this->_loggedUser->get('admin');
  59.         $this->output();
  60.     }
  61.  
  62.     /**
  63.      * @description change responsible person
  64.      * @return json
  65.      *
  66.      * @var $this
  67.      * @var $query
  68.      * @var $page_id
  69.      * @var $resp_person
  70.      * @var $user
  71.      *
  72.      */
  73.     public function changeResponsibleAction()
  74.     {
  75.         $status = false;
  76.         if ($this->_input['resp_person']) {
  77.             $resp_person = mysql_real_escape_string($this->_input['resp_person']);
  78.             $issue = new IssueLog($this->_page_id);
  79.             $issue->set('resp_username', $resp_person);
  80.             $issue->update();
  81.             $user = $this->_dbr->getAssoc("SELECT username, `name` FROM users WHERE username = '$resp_person'");
  82.             $this->_result['resp_username'] = $user;
  83.             $this->_result['issuelog_id'] = $this->_page_id;
  84.             $this->sendAndLogEmail('responsible');
  85.             $status = true;
  86.         }
  87.         $this->_result['success'] = $status;
  88.         $this->output();
  89.     }
  90.  
  91.     /**
  92.      * @description change solving responsible person
  93.      * @return json
  94.      *
  95.      * @var $this
  96.      * @var $query
  97.      * @var $page_id
  98.      * @var $resp_person
  99.      * @var $user
  100.      *
  101.      */
  102.     public function changeSolvingResponsibleAction()
  103.     {
  104.         $status = false;
  105.         if (IssueLog::checkEditAccess($this->_input['page_id'])) {
  106.             if ($this->_input['solving_resp_person']) {
  107.                 $solving_resp_person = mysql_real_escape_string($this->_input['solving_resp_person']);
  108.                 $issue = new IssueLog($this->_page_id);
  109.                 $issue->set('solving_resp_username', $solving_resp_person);
  110.                 $issue->update();
  111.                 $user = $this->_dbr->getAssoc("SELECT username, `name` FROM users WHERE username = '$solving_resp_person'");
  112.                 $this->_result['resp_username'] = $user;
  113.                 $this->_result['issuelog_id'] = $this->_page_id;
  114.                 $this->sendAndLogEmail('solving');
  115.                 $status = true;
  116.             }
  117.         }
  118.         $this->_result['success'] = $status;
  119.         $this->output();
  120.     }
  121.  
  122.     /**
  123.      * @description change department
  124.      * @return json
  125.      *
  126.      * @var $this
  127.      * @var $query
  128.      * @var $departament
  129.      *
  130.      */
  131.     public function changeDepartmentAction()
  132.     {
  133.         $status = false;
  134.         if (IssueLog::checkEditAccess($this->_input['page_id']))
  135.         {
  136.             if (isset($this->_input['department']))
  137.             {
  138.                 $departments = $this->_input['department'];
  139.                 $issue = new IssueLog($this->_page_id);
  140.                 $this->_result['department_ids'] = $issue->saveDepartments($departments);
  141.                 $status = true;
  142.             }
  143.         }
  144.         $this->_result['success'] = $status;
  145.         $this->output();
  146.     }
  147.  
  148.     /**
  149.      * @description change issue description
  150.      * @return json
  151.      *
  152.      * @var $this
  153.      * @var $query
  154.      * @var $issueDescription
  155.      *
  156.      */
  157.     public function changeIssueDescriptionAction()
  158.     {
  159.         $status = false;
  160.         if (IssueLog::checkEditAccess($this->_input['page_id'])) {
  161.             $issueDescription = mysql_real_escape_string($this->_input['change_issue_description']);
  162.             $issue = new IssueLog($this->_page_id);
  163.             $issue->set('issue', $issueDescription);
  164.             $issue->update();
  165.             $status = true;
  166.         }
  167.         $this->_result['success'] = $status;
  168.         $this->output();
  169.     }
  170.  
  171.     /**
  172.      * set due date
  173.      * @var $due_date
  174.      * @var $this
  175.      */
  176.     public function setDueDateAction()
  177.     {
  178.         $due_date = mysql_real_escape_string($this->_input['due_date']);
  179.         $issue = new IssueLog($this->_page_id);
  180.         $issue->set('due_date', $due_date);
  181.         $issue->update();
  182.         $this->_result['success'] = true;
  183.         $this->output();
  184.     }
  185.  
  186.     /**
  187.      * delete due date
  188.      * @var $this
  189.      */
  190.     public function deleteDueDateAction()
  191.     {
  192.         $issue = new IssueLog($this->_page_id);
  193.         $issue->set('due_date', null);
  194.         $issue->update();
  195.         $this->_result['success'] = true;
  196.         $this->output();
  197.     }
  198.  
  199.     /**
  200.      * @description change type
  201.      * @return json
  202.      *
  203.      * @var $this
  204.      * @var $query
  205.      * @var $issue_type_id
  206.      *
  207.      */
  208.     public function changeIssueTypeAction()
  209.     {
  210.         //checkEditAccess - https://trello.com/c/cfqp58X0/4716-natalia-g-issue-list-small-change
  211.  
  212.         //if (IssueLog::checkEditAccess($this->_input['page_id'])) {
  213.             $issue_type_id = $this->_input['issue_type_id'];
  214.             $issue = new IssueLog($this->_page_id);
  215.             $issue->replaceIssueTypes($issue_type_id);
  216.             $this->_result['success'] = true;
  217.             $this->output();
  218.         //}
  219.     }
  220.  
  221.     /**
  222.      * @description save the issue images, files and videos
  223.      * @var $images
  224.      * @var $imgs_qty
  225.      * @var $file_name
  226.      * @var $file_extension
  227.      * @var $type
  228.      * @var $pic
  229.      * @var $md5
  230.      * @var $file
  231.      * @var $mime_type
  232.      */
  233.     public function saveImagesAction()
  234.     {
  235.         $images = $_FILES['imgs'] ? $_FILES['imgs'] : [];
  236.         if ($images) {
  237.             $imgs_qty = count($images['tmp_name'])-1;
  238.             if ($imgs_qty >= 0) {
  239.                 for(; $imgs_qty >= 0; $imgs_qty--) {
  240.                     $tmp_name = $images['tmp_name'][$imgs_qty];
  241.                     $file_name = $images['name'][$imgs_qty];
  242.                     $mime_type = $images['type'][$imgs_qty];
  243.                     $issue = new IssueLog($this->_page_id);
  244.                     $issue->addFile($file_name, $tmp_name, $mime_type);
  245.                 }
  246.             }
  247.         }
  248.         $this->getIssueImagesAction();
  249.     }
  250.  
  251.     /**
  252.      * @description delete the issue images and files
  253.      */
  254.     public function deleteImagesAction()
  255.     {
  256.         $images = $this->_input['images_delete'] ? $this->_input['images_delete'] : [];
  257.         foreach ($images as $image) {
  258.             $image_hash = $this->_dbr->getOne("SELECT `hash` FROM issue_pic WHERE id = $image");
  259.             (new UploadFiles())->delete($image_hash);
  260.            
  261. //            $image_path = set_file_path($image_hash);
  262. //            if (is_file($image_path)) {
  263. //                unlink($image_path);
  264. //            }
  265.             $this->_db->query("DELETE FROM issue_pic WHERE id = $image");
  266.         }
  267.         $this->getIssueImagesAction();
  268.     }
  269.  
  270.     /**
  271.      * @description get issue images
  272.      */
  273.     public function getIssueImagesAction()
  274.     {
  275.         $issue = new IssueLog($this->_page_id);
  276.         $this->_result['images'] = $issue->getFiles('pic');
  277.         $this->_result['files'] = $issue->getFiles('doc');
  278.         $this->_result['videos'] = $issue->getFiles('video');
  279.         $this->output();
  280.     }
  281.  
  282.     /**
  283.      * get issue types
  284.      */
  285.     public function getIssueTypesAction() {
  286.         $query = "SELECT `name`, inactive, id FROM issue_type";
  287.         $result = $this->_dbr->getAll($query);
  288.         $this->_result['issue_types'] = $result;
  289.         $default_issue_type = \Config::get('default_issue_type');
  290.         $this->_result['default_issue_type'] = $default_issue_type;
  291.         $this->output();
  292.     }
  293.  
  294.     /**
  295.      * set issue types
  296.      * @return object
  297.      */
  298.     public function setIssueTypesAction() {
  299.         if ($this->_input['name'] && !$this->_input['type_id']) {
  300.             $name = mysql_real_escape_string($this->_input['name']);
  301.             $this->_db->query("INSERT INTO issue_type (`name`) VALUES ('" . $name . "')");
  302.         }
  303.         if ($this->_input['name'] && $this->_input['type_id']) {
  304.             $name = mysql_real_escape_string($this->_input['name']);
  305.             $this->_db->query("UPDATE issue_type SET `name` = '$name' WHERE id = " . $this->_input['type_id']);
  306.         }
  307.         if ($this->_input['default']) {
  308.             \Config::set('default_issue_type', (int)$this->_input['default']);
  309.         }
  310.         if ($this->_input['inactive'] >= 0 && $this->_input['type_id']) {
  311.             $this->_db->query("UPDATE issue_type SET inactive = " . (int)$this->_input['inactive'] . " WHERE id = " . $this->_input['type_id']);
  312.         }
  313.         if ($this->_input['inspection'] >= 0 && $this->_input['type_id']) {
  314.             $this->_db->query("UPDATE issue_type SET inspection = " . (int)$this->_input['inspection'] . " WHERE id = " . $this->_input['type_id']);
  315.         }
  316.         $this->_result['success'] = true;
  317.         $this->getIssueTypesAction();
  318.     }
  319.  
  320.     /**
  321.      * @description send email and log it when choose new responsible person
  322.      */
  323.     private function sendAndLogEmail($type)
  324.     {
  325.         if ($type == 'responsible') {
  326.             $person = $this->_input['resp_person'];
  327.             $field = 'resp_username';
  328.         }
  329.         if ($type == 'solving') {
  330.             $person = $this->_input['solving_resp_person'];
  331.             $field = 'solving_resp_username';
  332.         }
  333.         global $siteURL;
  334.         $current_respuser= $this->_db->getOne("select " . $field . " from issuelog where id=" . $this->_page_id);
  335.         $newuser_email = $this->_db->getOne("select email from users where username='" . $person . "'");
  336.         if ($current_respuser != $resp_person) {
  337.             if (strlen($person)) {
  338.                 $ret = new stdClass;
  339.                 $ret->from = $this->_loggedUser->get('email');
  340.                 $ret->from_name = $this->_loggedUser->get('name');
  341.                 $user = new User($this->_db, $this->_dbr, $person);
  342.                 $ret->email_invoice = $newuser_email;
  343.                 $ret->saved_id = $this->_page_id;
  344.                 $ret->auction_number = $this->_page_id;
  345.                 $ret->txnid = 'issuelog';
  346.                 $ret->url = $siteURL . "react/logs/issue_logs/$this->_page_id/";
  347.                 standardEmail($this->_db, $this->_dbr, $ret, 'new_responsible_issue');
  348.             }
  349.         }
  350.     }
  351.  
  352.  
  353.     /**
  354.      * print checked issues
  355.      * @var $issue_ids
  356.      * @var $this
  357.      * @var $dompdf
  358.      * @var $smarty
  359.      * @var $content
  360.      * @var $html
  361.      */
  362.     public function issuesPrintAction()
  363.     {
  364.         global $smarty;
  365.         $issue_ids = $this->_input['issue_ids'];
  366.         $issue_ids = implode(',', $issue_ids);
  367.         $issues = $this->_dbr->getAll("
  368.            SELECT
  369.                GROUP_CONCAT(issue_type.`name` separator '<br>') issue_type
  370.                , issuelog.issue
  371.                , (
  372.                    SELECT Updated
  373.                    FROM total_log
  374.                    WHERE
  375.                        TableID = issuelog.id
  376.                        AND " . get_table_name('issuelog') . "
  377.                        AND " . get_field_name('id') . "
  378.                    ) AS added_time
  379.                , (
  380.                    SELECT users.`name`
  381.                    FROM total_log
  382.                    JOIN users ON users.id = total_log.username_id
  383.                    WHERE
  384.                        TableID = issuelog.id
  385.                        AND " . get_table_name('issuelog') . "
  386.                        AND " . get_field_name('id') . "
  387.                    ) AS added_person
  388.                , users.`name` solving_person
  389.                , empd.`name` departament
  390.                , issuelog.obj,
  391.                    CASE obj
  392.                        WHEN 'supplier' THEN CONCAT('Supplier: ', issuelog.obj_id)
  393.                        WHEN 'auction' THEN CONCAT('Auftrag: ',
  394.                            IF(auction.auction_number, auction.auction_number, issuelog.obj_id),
  395.                            IF(auction.txnid, CONCAT('/',auction.txnid), ''))
  396.                        WHEN 'rma' THEN CONCAT('Ticket: ', issuelog.obj_id)
  397.                        WHEN 'ww_order' THEN CONCAT('WWO: ', issuelog.obj_id)
  398.                        WHEN 'op_order' THEN CONCAT('OP Order: ', issuelog.obj_id)
  399.                        WHEN 'route' THEN CONCAT('Route: ', issuelog.obj_id)
  400.                        WHEN 'manual' THEN 'Manual'
  401.                        WHEN 'rating' CONCAT(THEN 'Rating: ', issuelog.obj_id)
  402.                        WHEN 'insurance' THEN CONCAT('Insurance: ', issuelog.obj_id)
  403.                        WHEN 'shippingInvoiceResults' THEN CONCAT('Shipping invoice: ', issuelog.obj_id)
  404.                        WHEN 'monitoredShippingPrices' THEN CONCAT('Monitored shipping price: ', issuelog.obj_id)
  405.                    END AS where_did
  406.            FROM issuelog
  407.            LEFT JOIN emp_department empd ON empd.id = issuelog.department_id
  408.            LEFT JOIN users ON users.username = issuelog.resp_username
  409.            LEFT JOIN users users_solving ON users_solving.username = issuelog.solving_resp_username
  410.            LEFT JOIN issue_type ON issue_type.id = issuelog.type_id
  411.            LEFT JOIN auction ON auction.id = issuelog.obj_id AND issuelog.obj = 'auction'
  412.            LEFT JOIN rma ON rma.rma_id = issuelog.obj_id AND issuelog.obj = 'rma'
  413.            LEFT JOIN auction auction_rma ON rma.auction_number = auction_rma.auction_number AND rma.txnid = auction_rma.txnid
  414.            LEFT JOIN orders ON auction.auction_number = orders.auction_number and auction.txnid = orders.txnid
  415.            LEFT JOIN orders orders_rma ON rma.auction_number = orders_rma.auction_number and rma.txnid = orders_rma.txnid
  416.            LEFT JOIN auction_par_varchar ON auction.auction_number = auction_par_varchar.auction_number AND auction.txnid = auction_par_varchar.txnid AND auction_par_varchar.`key` = 'country_shipping'
  417.            LEFT JOIN auction_par_varchar apv_rma ON rma.auction_number = apv_rma.auction_number AND rma.txnid = apv_rma.txnid AND apv_rma.`key` = 'country_shipping'
  418.            LEFT JOIN total_log tl ON
  419.                tl.TableID = issuelog.id
  420.                AND " . get_table_name('issuelog', 'tl') . "
  421.                AND " . get_field_name('id', 'tl') . "
  422.            LEFT JOIN issuelog_type ON issuelog_type.issuelog_id = issuelog.id
  423.            WHERE issuelog.id IN ($issue_ids)
  424.                GROUP BY added_time
  425.                ORDER BY added_time DESC
  426.        ");
  427.  
  428.         if ($issues) {
  429.             $smarty->assign('issues', $issues);
  430.             $html = $smarty->fetch('issues.tpl');
  431.             require_once("dompdf/dompdf_config.inc.php");
  432.             $dompdf = new DOMPDF();
  433.             $dompdf->set_paper('A4', 'landscape');
  434.             $dompdf->load_html($html);
  435.             $dompdf->render();
  436.             $content = $dompdf->output();
  437.             header("Content-type: application/pdf");
  438.             header("Content-disposition: inline; filename=issues.pdf");
  439.             echo $content;
  440.         }
  441.     }
  442.  
  443.  
  444.     /**
  445.      * @description Saving filter settings
  446.      */
  447.     public function saveFilterSettingsAction()
  448.     {
  449.         $filter = [];
  450.         $success = false;
  451.         $id = 0;
  452.         $options = [];
  453.  
  454.         $filter_id = intval($this->_input['filter_id']);
  455.  
  456.         if (isset($this->_input['settingName']))
  457.         {
  458.             $title = mysql_real_escape_string(trim($this->_input['settingName']));
  459.             //$title_exists = $this->_db->getOne("SELECT title FROM saved_filters WHERE title = '".$title."'");
  460.  
  461.             $filter_fields = [  'seller',
  462.                 'source_seller',
  463.                 'shipping_country',
  464.                 'shipping_method',
  465.                 'warehouse_shipped_from',
  466.                 'by_comment',
  467.                 'date_from',
  468.                 'date_to',
  469.                 'show_with_inactive',
  470.                 'status',
  471.                 'where_did',
  472.                 'issue_type',
  473.                 'added_person',
  474.                 'department_id',
  475.                 'resp_username',
  476.                 'solving_resp_username',
  477.                 'recurring',
  478.                 'supplier_id',
  479.             ];
  480.  
  481.             $input_fields = $this->_input['filters'];
  482.  
  483.             foreach ( $filter_fields as $filter_field ) {
  484.                 if (isset($input_fields[$filter_field])) {
  485.                     $filter[$filter_field] = mysql_real_escape_string($input_fields[$filter_field]);
  486.                 }
  487.             }
  488.             $filter_json = json_encode($filter);
  489.  
  490.             $id = IssueLog::saveFilterSettings($filter_id, $title, $filter_json);
  491.  
  492.             /*
  493.             if ($filter_id > 0) {
  494.                 // update filter
  495.                 $this->_db->query("UPDATE saved_filters
  496.                     SET `title` = '" . $title . "', `filter_set` = '" . $filter_json . "', `page` = 'issue_logs'
  497.                     WHERE id = " . $filter_id . "
  498.                 ");
  499.             } else {
  500.                 // save new filter
  501.                 $this->_db->query("INSERT INTO saved_filters (`title`, `filter_set`, `page` )
  502.                 VALUES ('" . $title . "', '" . $filter_json . "', 'issue_logs')");
  503.             }
  504.             $id = $this->_db->getOne('SELECT LAST_INSERT_ID()');
  505.             */
  506.  
  507.             if ($id > 0) {
  508.                 $q = "SELECT saved_filters.id, saved_filters.title, saved_filters.filter_set
  509.                       FROM saved_filters
  510.                      WHERE saved_filters.id = " . $id;
  511.                 $result = $this->_dbr->getAssoc($q);
  512.                 foreach ($result as &$item) {
  513.                     $item['filter_set'] = json_decode($item['filter_set']);
  514.                 }
  515.                 $success = true;
  516.             }
  517.         }
  518.  
  519.         if ($success && $id > 0) {
  520.             $this->_result['options']['issue_filter_settings'] = $result;
  521.         }
  522.  
  523.         $this->_result['success'] = $success;
  524.         $this->output();
  525.     }
  526.  
  527.     /**
  528.      * @description Deleting filter settings
  529.      */
  530.     public function deleteFilterSettingsAction()
  531.     {
  532.         $success = false;
  533.         $user_id = $this->_loggedUser->get('id');
  534.         $filter_id = intval($this->_input['filter_id']);
  535.         if ($filter_id > 0 && $user_id > 0) {
  536.             $q = "
  537.                DELETE saved_filters
  538.                FROM saved_filters
  539.                  JOIN total_log ON  " . get_table_name('saved_filters') . " AND
  540.                                     `total_log`.username_id = " . $user_id . " AND
  541.                                     `total_log`.TableID = saved_filters.id
  542.                WHERE saved_filters.id = " . $filter_id . "
  543.            ";
  544.             $this->_db->query($q);
  545.             $success = true;
  546.         }
  547.         $this->_result['filter_id'] = $filter_id;
  548.         $this->_result['success'] = $success;
  549.         $this->output();
  550.     }
  551.  
  552.     /**
  553.      * @description Adding/editing checkpoint
  554.      *
  555.      * @var $checkpoint_id
  556.      * @var $issue_id
  557.      * @var $description
  558.      * @var $ordering
  559.      * @var $done
  560.      */
  561.     public function saveCheckpointAction()
  562.     {
  563.         $success = false;
  564.         $checkpoint_info = [];
  565.         $issue_id = intval($this->_input['issue_id']);
  566.  
  567.         if ($issue_id > 0)
  568.         {
  569.             $issue = new IssueLog($issue_id);
  570.             $checkpoint_id = $issue->saveCheckpoint([
  571.                 'id' => intval($this->_input['checkpoint_id']),
  572.                 'issuelog_id' => $issue_id,
  573.                 'description' => mysql_real_escape_string($this->_input['description']),
  574.                 'ordering' => ($this->_input['ordering']) ? intval($this->_input['ordering']) : 0,
  575.                 'done' => ($this->_input['done'] > 0) ? 1 : 0
  576.             ]);
  577.  
  578.             if ($checkpoint_id > 0)
  579.             {
  580.                 $checkpoint_info = $issue->getCheckpoint($checkpoint_id);
  581.                 $success = true;
  582.             }
  583.         }
  584.  
  585.         $this->_result['checkpoint'] = $checkpoint_info;
  586.         $this->_result['success'] = $success;
  587.         $this->output();
  588.     }
  589.  
  590.  
  591.     /**
  592.      * @description Adding/editing checkpoints
  593.      */
  594.     public function saveCheckpointsAction()
  595.     {
  596.         $success = false;
  597.         $checkpoints_info = [];
  598.         $issue_id = intval($this->_input['issue_id']);
  599.         $checkpoints = $this->_input['checkpoints'];
  600.  
  601.         if (is_array($checkpoints) && $issue_id > 0)
  602.         {
  603.             $issue = new IssueLog($issue_id);
  604.             foreach ($checkpoints as $checkpoint)
  605.             {
  606.                 $checkpoint_id = $issue->saveCheckpoint([
  607.                     'id' => intval($checkpoint['checkpoint_id']),
  608.                     'issuelog_id' => $issue_id,
  609.                     'description' => mysql_real_escape_string($checkpoint['description']),
  610.                     'ordering' => (isset($checkpoint['ordering'])) ? intval($checkpoint['ordering']) : 0,
  611.                     'done' => ($checkpoint['done'] > 0) ? 1 : 0
  612.                 ]);
  613.                 if ($checkpoint_id > 0)
  614.                 {
  615.                     $checkpoints_info[] = $issue->getCheckpoint($checkpoint_id);
  616.                     $success = true;
  617.                 }
  618.             }
  619.         }
  620.  
  621.         $this->_result['checkpoints'] = $checkpoints_info;
  622.         $this->_result['success'] = $success;
  623.         $this->output();
  624.     }
  625.  
  626.  
  627.     /**
  628.      * @description Removing checkpoint
  629.      *
  630.      * @var $checkpoint_id
  631.      * @var $issue_id
  632.      *
  633.      */
  634.     public function removeCheckpointAction()
  635.     {
  636.         $issue_id = intval($this->_input['issue_id']);
  637.         $checkpoint_id = intval($this->_input['checkpoint_id']);
  638.  
  639.         if ($issue_id > 0 && $checkpoint_id > 0)
  640.         {
  641.             $q = "DELETE FROM issue_checkpoint WHERE
  642.                    issue_checkpoint.id = " . $checkpoint_id . " AND
  643.                    issue_checkpoint.issuelog_id = " . $issue_id;
  644.             $this->_db->query($q);
  645.         }
  646.  
  647.         $this->checklistAction();
  648.     }
  649.  
  650.     /**
  651.      * @description Getting checklist
  652.      *
  653.      * @var $issue_id
  654.      */
  655.     public function checklistAction()
  656.     {
  657.         $success = false;
  658.         $issue_id = intval($this->_input['issue_id']);
  659.         $checklist = array();
  660.         if ($issue_id > 0) {
  661.             $checklist = IssueLog::getChecklist($issue_id);
  662.             $success = true;
  663.         }
  664.         $this->_result['checklist'] = IssueLog::checklistReorder($issue_id, $checklist);
  665.         $this->_result['success'] = $success;
  666.         $this->output();
  667.     }
  668.  
  669.  
  670.     /**
  671.      * @description Adding/editing issue type fields
  672.      *
  673.      * @var $issue_type_fields - array of issue type fields
  674.      *      with data (issue_field_id, name, issue_type_id, show_in_popup)
  675.      */
  676.     public function saveIssueTypeFieldAction()
  677.     {
  678.         $success = false;
  679.         $results = [];
  680.         $issue_type_fields = $this->_input['issue_type_fields'];
  681.         /*
  682.         // test
  683.         $issue_type_fields = [
  684.             ['issue_field_id' => 2, 'name' => 'qwe10', 'issue_type_id' => 1, 'show_in_popup' => 0],
  685.             ['issue_field_id' => 5, 'name' => 'qwe11', 'issue_type_id' => 1, 'show_in_popup' => 0],
  686.             ['name' => 'qwe12', 'issue_type_id' => 1, 'show_in_popup' => 0]
  687.         ];
  688.         */
  689.         if (is_array($issue_type_fields) && count($issue_type_fields) > 0) {
  690.             foreach ($issue_type_fields as $issue_type_field) {
  691.                 /*
  692.                  *  Add or update issue type field
  693.                  */
  694.                 $result = IssueLog::saveIssueTypeField(
  695.                     intval($issue_type_field['field_id']),
  696.                     mysql_real_escape_string($issue_type_field['field_name']),
  697.                     intval($issue_type_field['issue_type_id']),
  698.                     ($issue_type_field['show_in_popup'] > 0) ? 1 : 0,
  699.                     ($issue_type_field['inactive'] > 0) ? 1 : 0
  700.                 );
  701.                 if ($result) {
  702.                     $success = true;
  703.                     $results[] = $result;
  704.                 } else {
  705.                     $success = false;
  706.                 }
  707.             }
  708.         }
  709.         $this->_result['issue_type_fields'] = $results;
  710.         $this->_result['success'] = $success;
  711.         $this->output();
  712.     }
  713.  
  714.     /**
  715.      * @description Getting issue type fieldlist
  716.      * @var $issue_type_id
  717.      */
  718.     public function issueTypeFieldlistAction()
  719.     {
  720.         $issue_type_id = intval($this->_input['issue_type_id']);
  721.         $show_in_popup = (isset($this->_input['show_in_popup'])) ? intval($this->_input['show_in_popup']) : -1;
  722.         $inactive = (isset($this->_input['inactive'])) ? intval($this->_input['inactive']) : -1;
  723.  
  724.         if ($issue_type_id > 0) {
  725.             $fieldlist = IssueLog::getIssueTypeFieldList([$issue_type_id], $show_in_popup, $inactive);
  726.         } else {
  727.             $fieldlist = IssueLog::getIssueTypeFieldList([], $show_in_popup, $inactive);
  728.         }
  729.         $this->_result['fieldlist'] = $fieldlist;
  730.         $this->_result['success'] = ($fieldlist) ? true : false;
  731.         $this->output();
  732.     }
  733.  
  734.     /**
  735.      * @description Save checklist ordering
  736.      *
  737.      * @var $issue_id
  738.      * @var $ordering - array of checkpoint ids and orderings
  739.      */
  740.     public function saveChecklistOrderingAction()
  741.     {
  742.         $success = false;
  743.         $ordering = $this->_input['ordering'];
  744.         $issue_id = intval($this->_input['issue_id']);
  745.  
  746.         if (is_array($ordering) && count($ordering) > 0) {
  747.             foreach ($ordering as $item) {
  748.                 if (isset($item['checkpoint_id']) && isset($item['ordering'])) {
  749.                     $q = "UPDATE issue_checkpoint
  750.                            SET ordering = " . intval($item['ordering']) . "
  751.                          WHERE issuelog_id = " . $issue_id . "
  752.                          AND id = " . $item['checkpoint_id'];
  753.                     $this->_db->query($q);
  754.                 }
  755.             }
  756.             $this->_result['ordering'] = $ordering;
  757.             $success = true;
  758.         }
  759.  
  760.         $checklist = array();
  761.         if ($issue_id > 0) {
  762.             $q = "SELECT * FROM issue_checkpoint WHERE issuelog_id = " . $issue_id . " ORDER BY ordering, id ASC";
  763.             $checklist = $this->_dbr->getAll($q);
  764.         }
  765.         $this->_result['checklist'] = $checklist;
  766.         $this->_result['success'] = $success;
  767.         $this->output();
  768.     }
  769.  
  770.     /**
  771.      * @description Set days for ping after no activity
  772.      * @var $days - after X days send email
  773.      *      via cron if no activity in issue
  774.      * @var $issue_id
  775.      */
  776.     public function setPingAfterNoActivityAction()
  777.     {
  778.         $success = false;
  779.         $days = $this->_input['days'];
  780.         $issue_id = $this->_input['issue_id'];
  781.         $user_id = $user_id = $this->_loggedUser->get('id');
  782.         if ($days >= 0 && $issue_id > 0 && $user_id > 0) {
  783.             IssueLog::savePingDays($issue_id, $user_id, $days);
  784.             $this->_result['ping_days'] = $days;
  785.             $success = true;
  786.         }
  787.         $this->_result['success'] = $success;
  788.         $this->output();
  789.     }
  790.  
  791.     /**
  792.      * @description Getting additional description fields
  793.      * @var $issue_id
  794.      */
  795.     public function additionalDescriptionFieldsAction()
  796.     {
  797.         $success = false;
  798.         $issue_id = $this->_input['issue_id'];
  799.         if ($issue_id > 0) {
  800.             $issue = new IssueLog($issue_id);
  801.             $this->_result['fields'] = $issue->getAdditionalFields();
  802.             $success = true;
  803.         }
  804.         $this->_result['success'] = $success;
  805.         $this->output();
  806.     }
  807.  
  808.     /**
  809.      * @description Getting additional description fields
  810.      * @var $issue_id
  811.      */
  812.     public function saveAdditionalFieldsAction()
  813.     {
  814.         $success = false;
  815.         $issue_id = $this->_input['issue_id'];
  816.         $fields = $this->_input['additional_fields'];
  817.  
  818.          //test
  819.         /*
  820.         $fields['additional_fields'] = array(
  821.             0 => array('field_id' => 27, 'value' => 'new field test value 1'),
  822.             1 => array('field_id' => 25, 'value' => 'new field test value 2'),
  823.             2 => array('field_id' => 26, 'value' => 'new field test value 3')
  824.         );
  825.         print_r($fields); die();
  826.         */
  827.  
  828.         if ($issue_id > 0 && count($fields) > 0) {
  829.             $issue = new IssueLog($issue_id);
  830.             foreach ($fields as $field) {
  831.                 $issue->saveAdditionalField( intval($field['field_id']), $field['value']);
  832.             }
  833.             $success = true;
  834.             $this->_result['fields'] = $issue->getAdditionalFields();
  835.         }
  836.         $this->_result['success'] = $success;
  837.         $this->output();
  838.     }
  839.  
  840.     /**
  841.      * @description Getting all checklist titles
  842.      */
  843.     public function getChecklistTitlesAction()
  844.     {
  845.         $q = "SELECT
  846.                  DISTINCT issue_checkpoint.issuelog_id as issue_id,
  847.                  COUNT(issue_checkpoint.id) as `checkpoints`,
  848.                  issuelog.checklist_title
  849.              FROM issue_checkpoint
  850.                  LEFT JOIN issuelog ON issuelog.id = issue_checkpoint.issuelog_id
  851.              WHERE 1
  852.              GROUP BY issue_checkpoint.issuelog_id";
  853.         $this->_result['titles'] = $this->_dbr->getAll($q);
  854.         $this->_result['success'] = true;
  855.         $this->output();
  856.     }
  857.  
  858.     /**
  859.      * @description Getting all checklist titles
  860.      */
  861.     public function importChecklistAction()
  862.     {
  863.         $success = false;
  864.         $issue_id_from = $this->_input['issue_id_from'];
  865.         $issue_id_to = $this->_input['issue_id_to'];
  866.         if ($issue_id_from > 0 && $issue_id_to > 0 && $issue_id_to != $issue_id_from) {
  867.             IssueLog::importChecklist($issue_id_from, $issue_id_to);
  868.             $success = true;
  869.         }
  870.         $checklist = IssueLog::getChecklist($issue_id_to);
  871.         $this->_result['checklist'] = IssueLog::checklistReorder($issue_id_to, $checklist);
  872.         $this->_result['success'] = $success;
  873.         $this->output();
  874.     }
  875.  
  876.  
  877.     /**
  878.      * @description Saving checklist title
  879.      * @var $title - checklist title
  880.      * @var $issue_id
  881.      */
  882.     public function saveChecklistTitleAction()
  883.     {
  884.         $success = false;
  885.         $issue_id = intval($this->_input['issue_id']);
  886.         $title = $this->_input['checklist_title'];
  887.         if ($issue_id > 0)
  888.         {
  889.             $issue = new IssueLog($issue_id);
  890.             $issue->set('checklist_title', $title);
  891.             $issue->update();
  892.             $success = true;
  893.         }
  894.         $this->_result['title'] = $title;
  895.         $this->_result['success'] = $success;
  896.         $this->output();
  897.     }
  898.  
  899.  
  900.     /**
  901.      * @description Duplicating the issue
  902.      */
  903.     public function duplicateIssueAction()
  904.     {
  905.         $success = false;
  906.         $issue_id = intval($this->_input['issue_id']);
  907.  
  908.         if ($issue_id > 0)
  909.         {
  910.             $new_issue_id = IssueLog::duplicateIssue($issue_id, [
  911.                 // What will we duplicate?
  912.                 'tags' => (isset($this->_input['tags'])) ? intval($this->_input['tags']) : 1,
  913.                 'details' => (isset($this->_input['details'])) ? intval($this->_input['details']) : 1,
  914.                 'description' => (isset($this->_input['description'])) ? intval($this->_input['description']) : 1,
  915.                 'comments' => (isset($this->_input['comments'])) ? intval($this->_input['comments']) : 1,
  916.                 'checklist' => (isset($this->_input['checklist'])) ? intval($this->_input['checklist']) : 1,
  917.                 'images' => (isset($this->_input['images'])) ? intval($this->_input['images']) : 1,
  918.                 'files' => (isset($this->_input['files'])) ? intval($this->_input['files']) : 1,
  919.                 'videos' => (isset($this->_input['videos'])) ? intval($this->_input['videos']) : 1
  920.             ]);
  921.             $this->_result['new_issue_id'] = $new_issue_id;
  922.  
  923.             $res = IssueLog::findByFilterParams(array('page_id' => $new_issue_id));
  924.             $this->_result['issue'] = $res['issue_list'][0];
  925.             $success = true;
  926.         }
  927.  
  928.         $this->_result['success'] = $success;
  929.         $this->output();
  930.     }
  931.  
  932.  
  933.     /**
  934.      * @description Set close_notif option
  935.      */
  936.     public function closeNotifAction()
  937.     {
  938.         $success = false;
  939.         $issue_id = intval($this->_input['issue_id']);
  940.         $username = $this->_loggedUser->get('username');
  941.  
  942.         if ($issue_id > 0 && $username)
  943.         {
  944.             $data = IssueLog::closeNotifToogle($issue_id, $username);
  945.             $this->_result['close_notif'] = $data;
  946.             $success = true;
  947.         }
  948.  
  949.         $this->_result['success'] = $success;
  950.         $this->output();
  951.     }
  952. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!