435 lines
14 KiB
PHP
435 lines
14 KiB
PHP
<?php
|
|
|
|
namespace BRSystems\Core\Cms\cmsCountToClass\inc;
|
|
|
|
use BRSystems\Core\Cms\cmsOrders\inc\cmsOrdersController;
|
|
use BRSystems\Core\Library\cCore\cCore;
|
|
use BRSystems\Core\Library\cJSON\cJSON;
|
|
use BRSystems\Core\Library\cValidator\cValidator;
|
|
|
|
class cmsCountToClassController extends cCore
|
|
{
|
|
public $dir;
|
|
public $name;
|
|
public $module;
|
|
|
|
|
|
/**
|
|
* Class constructor
|
|
*/
|
|
public function __construct($uriData, $dir, $name)
|
|
{
|
|
$this->dir = $dir;
|
|
$this->name = $name;
|
|
|
|
parent:: __construct($uriData);
|
|
$this->module = new cmsCountToClassModule();
|
|
|
|
$this->oView->setTemplateDir($this->dir . "/tmpl/");
|
|
|
|
if (!$this->oView->cacheUsed()) {
|
|
$this->oView->setJs(getCurrentFolder($this->dir) . '/js/' . $this->name . '.js');
|
|
$this->oView->setCss(getCurrentFolder($this->dir) . '/css/' . $this->name . '.css');
|
|
}
|
|
|
|
// Set JS module init title
|
|
$this->oView->setAsJSON(cCore::JS_MOD, ucfirst($name));
|
|
}
|
|
|
|
public function run($initEditMode = false)
|
|
{
|
|
$this->oView->TABLE = true;
|
|
$this->oView->MODULE_TITLE = $this->gM("Count to classificators");
|
|
|
|
$this->oView->setAsJSON('initEdit', $initEditMode);
|
|
$this->oView->setAsJSON('baseUrl', $this->gL());
|
|
$this->oView->setAsJSON('gL', $this->getJsTranslationsForView());
|
|
$this->oView->setAsJSON('vcfg', $this->getJsValCfgForView());
|
|
|
|
$this->oView->display();
|
|
}
|
|
|
|
/**
|
|
* Function to create cms table & return for direct & ajax input
|
|
*
|
|
* @param int $page - page to display
|
|
* @param string $filter_json - (optional) filter json string
|
|
* @param bool $headers - flag whether to send header data or not
|
|
* @return array of data
|
|
* @author Aivars Žukovskis <keiss.mareks@gmail.com>
|
|
* @category cmsCountToClass Controller
|
|
* @version 1.1
|
|
*/
|
|
public function createCmsTable($page = 1, $filter_json = '', $headers = false)
|
|
{
|
|
$pages = 0;
|
|
$filter = ($filter_json ? cJSON::decode($filter_json, true) : []);
|
|
|
|
$this->oView->MODULE_TITLE = $this->gM("Product Count to Classificators / Orders / Storage");
|
|
if (!!$filter && is_array($filter)) {
|
|
$this->oView->DEFAULT_SEARCH_VALUES = prepForDisplayHtml($filter);
|
|
}
|
|
|
|
$vStatus = [
|
|
'' => [
|
|
'title' => $this->gM('Select'),
|
|
],
|
|
cmsOrdersController::PRODUCT_OPERATION_ORDER_SEND => [
|
|
'title' => $this->gM('Order send'),
|
|
],
|
|
cmsOrdersController::PRODUCT_OPERATION_BUYS_MODULE => [
|
|
'title' => $this->gM('Buys module'),
|
|
],
|
|
cmsOrdersController::PRODUCT_OPERATION_ORDER_DELETED => [
|
|
'title' => $this->gM('Order deleted'),
|
|
],
|
|
cmsOrdersController::PRODUCT_OPERATION_STORAGE_MODULE => [
|
|
'title' => $this->gM('Storage module'),
|
|
],
|
|
];
|
|
|
|
$this->oView->LIST_HEADER = reOrderTableFields(
|
|
$this->getTableFields($vStatus),
|
|
$this->oUser->oCfg->getTableProperty($this->name),
|
|
);
|
|
$this->oView->LIST_DATA = $this->getModuleData($page, $filter, $pages, $vStatus);
|
|
$this->oView->LIST_ACTIONS = $this->getTableActions();
|
|
$this->oView->LIST_BTN = true;
|
|
|
|
$data = [
|
|
'data' => $this->oView->genHelperView('cmsc/table/data-table'),
|
|
'pcount' => $pages,
|
|
'rlimit' => $this->cmsTableRecordsPerPage,
|
|
];
|
|
|
|
// Send data to client
|
|
if ($headers) {
|
|
$data['header'] = $this->oView->genHelperView('cmsc/table/data-table-search');
|
|
}
|
|
|
|
return $data;
|
|
}
|
|
|
|
/**
|
|
* Function to get module data
|
|
*
|
|
* @param int $page
|
|
* @param array $filter
|
|
* @param int $pages
|
|
* @param array $vStatus
|
|
* @return array of data
|
|
* @category cmsCountToClass Controller
|
|
* @author Aivars Žukovskis <keiss.mareks@gmail.com>
|
|
* @version 1.1
|
|
*/
|
|
public function getModuleData($page = 1, $filter = [], &$pages, $vStatus)
|
|
{
|
|
$tFields = $this->getTableFields($vStatus);
|
|
|
|
// Create sort by
|
|
$sortBy = getP('sortBy');
|
|
$sort = $sortBy ? $this->module->db->genOrderByQuery($sortBy, getP('sortWay'), $tFields) : "id DESC";
|
|
|
|
// Create where clause
|
|
$where = 'AND cc.id > 0 ';
|
|
if (count($filter)) {
|
|
$where .= $this->module->db->genSearchFieldQuery($filter, $tFields, true, true);
|
|
}
|
|
|
|
$offset = (($page ?: 1) - 1) * $this->cmsTableRecordsPerPage;
|
|
$data = $this->module->getModuleRecords($where, $sort, $offset, $this->cmsTableRecordsPerPage);
|
|
$rows = $this->module->db->getSelectedRecordsCount();
|
|
$pages = floor($rows / $this->cmsTableRecordsPerPage,) + ($rows % $this->cmsTableRecordsPerPage ? 1 : 0);
|
|
$this->oView->ROWS = $rows;
|
|
|
|
if (!empty($data) && is_array($data)) {
|
|
foreach ($data as $k => $v) {
|
|
$today = date('d-m-Y', $v['date']) == date('d-m-Y');
|
|
$format = $today ? $this->timeDateFormat : $this->CMSDateFormat;
|
|
|
|
$data[$k]['op_date'] = date($format, $v['op_date']);
|
|
$data[$k]['date'] = date($format, $v['date']);
|
|
if (isset($vStatus[$v['op_type']])) {
|
|
$data[$k]['op_type'] = $vStatus[$v['op_type']]['title'];
|
|
}
|
|
}
|
|
}
|
|
|
|
return $data;
|
|
}
|
|
|
|
/**
|
|
* Function to delete records marked in table
|
|
*
|
|
* @param string $rows - passed user ids in cJSON string
|
|
* @return mixed of data
|
|
* @author Mareks Keišs <keiss.mareks@gmail.com>
|
|
* @category cmsCountToClass Controller
|
|
*/
|
|
public function delete($rows)
|
|
{
|
|
if ($rows = cJSON::decode($rows, true)) {
|
|
if ($this->module->deleteRecords($this->module->db->prepData($rows))) {
|
|
return true;
|
|
} else {
|
|
cJSON::senderror();
|
|
}
|
|
}
|
|
}
|
|
|
|
/**
|
|
* Function to save Record data
|
|
*
|
|
* @param int $recordId - record id
|
|
* @param string $fields - param cJSON string
|
|
* @return array of data
|
|
* @category cmsCountToClass Controller
|
|
* @author Aivars Žukovskis <keiss.mareks@gmail.com>
|
|
*/
|
|
public function saveRecordData($recordId, $fields)
|
|
{
|
|
$fields = $this->getSubmittedDataAsArray($fields ?? '');
|
|
if (empty($recordId) || empty($fields)) {
|
|
cJSON::senderror(['data' => $this->gM("No data to save")]);
|
|
}
|
|
|
|
// Validate fields
|
|
$valid = new cValidator($this);
|
|
$errors = $valid->checkArray($fields, $this->getJsValCfgForView());
|
|
if ($errors !== true) {
|
|
cJSON::senderror(['data' => $errors]);
|
|
}
|
|
|
|
$fields['modified'] = time();
|
|
$fields['modified_by'] = $this->oUser->getUser();
|
|
$this->module->saveData($recordId, $fields);
|
|
}
|
|
|
|
/**
|
|
* Function to create table headers + search
|
|
*
|
|
* @param array $statusData - status array
|
|
* @return bool|array of data
|
|
* @author Aivars Žukovskis <keiss.mareks@gmail.com>
|
|
* @category cmsCountToClass Controller
|
|
* @version 1.1
|
|
*/
|
|
public function getTableFields($statusData)
|
|
{
|
|
if (!$this->oUser->chkPermission('CMS_APP_COUNT_TO_CLASS_SHOW_MANAGEMENT', false, false)) {
|
|
return false;
|
|
}
|
|
|
|
$tFields = [
|
|
"checkbox" => [
|
|
'sort' => false,
|
|
'title' => '',
|
|
'class' => 'w4 center rchk',
|
|
],
|
|
"id" => [
|
|
'sort' => true,
|
|
'search' => true,
|
|
'title' => $this->gM("CC id"),
|
|
'class' => 'w6 center sortdesc',
|
|
'db_field' => 'cc.id',
|
|
'type' => 'input',
|
|
],
|
|
"nr" => [
|
|
'sort' => true,
|
|
'search' => true,
|
|
'title' => $this->gM("Prod nr"),
|
|
'class' => 'w12 sortdesc',
|
|
'db_field' => 'mp.prod_nr',
|
|
'type' => 'input',
|
|
],
|
|
"prod_name" => [
|
|
'sort' => true,
|
|
'search' => true,
|
|
'title' => $this->gM("Product title"),
|
|
'class' => 'w30',
|
|
'db_field' => 'ii.prod_name',
|
|
'type' => 'input',
|
|
],
|
|
"cl1" => [
|
|
'sort' => true,
|
|
'search' => true,
|
|
'title' => $this->gM("Product cl1"),
|
|
'class' => 'w12',
|
|
'db_field' => ['tr.t_title', 'tr2.t_title'],
|
|
'db_link' => 'OR',
|
|
'type' => 'input',
|
|
],
|
|
"cl2" => [
|
|
'sort' => true,
|
|
'search' => true,
|
|
'title' => $this->gM("Product cl2"),
|
|
'class' => 'w12',
|
|
'db_field' => ['tr.t_title', 'tr2.t_title'],
|
|
'db_link' => 'OR',
|
|
'type' => 'input',
|
|
],
|
|
"count" => [
|
|
'sort' => true,
|
|
'search' => false,
|
|
'title' => $this->gM("Count"),
|
|
'class' => 'w8 right',
|
|
'db_field' => 'count',
|
|
'type' => 'date',
|
|
'edit' => true,
|
|
],
|
|
'p' => [
|
|
'sort' => true,
|
|
'search' => false,
|
|
'title' => $this->gM("Price"),
|
|
'class' => 'w8 right fright',
|
|
'db_field' => 'mcc.prod_price',
|
|
'type' => 'date',
|
|
],
|
|
'ip' => [
|
|
'sort' => true,
|
|
'search' => false,
|
|
'title' => $this->gM("Inc. Price"),
|
|
'class' => 'w8 right fright',
|
|
'db_field' => 'mcc.prod_incoming_price',
|
|
'type' => 'input',
|
|
],
|
|
'pv' => [
|
|
'sort' => true,
|
|
'search' => false,
|
|
'title' => $this->gM("Sold Price"),
|
|
'class' => 'w8 right fright',
|
|
'db_field' => 'cc.price_sold',
|
|
'type' => 'input',
|
|
],
|
|
'note' => [
|
|
'sort' => true,
|
|
'search' => true,
|
|
'title' => $this->gM("Note"),
|
|
'class' => 'w12',
|
|
'db_field' => 'cc.note',
|
|
'type' => 'input',
|
|
],
|
|
"op_date" => [
|
|
'sort' => true,
|
|
'search' => false,
|
|
'title' => $this->gM("Op. Date"),
|
|
'class' => 'w12 center',
|
|
'db_field' => 'cc.op_date',
|
|
'type' => 'date',
|
|
],
|
|
"date" => [
|
|
'sort' => true,
|
|
'search' => [
|
|
'input_class' => 'date',
|
|
'custom_title' => $this->gM("Date from"),
|
|
'db_field' => 'cc.date',
|
|
'db_between_2field' => 'op_user',
|
|
],
|
|
'title' => $this->gM("Date"),
|
|
'class' => 'w12 center',
|
|
'db_field' => 'cc.date',
|
|
'type' => 'date',
|
|
],
|
|
"op_user" => [
|
|
'sort' => true,
|
|
'search' => [
|
|
'input_class' => 'date',
|
|
'custom_title' => $this->gM("Date till"),
|
|
],
|
|
'title' => $this->gM("User"),
|
|
'class' => 'w12',
|
|
'db_field' => 'op_user',
|
|
'type' => 'input',
|
|
],
|
|
"op_type" => [
|
|
'sort' => false,
|
|
'search' => false,
|
|
'title' => $this->gM("Status"),
|
|
'class' => 'w12',
|
|
'db_field' => 'cc.op_type',
|
|
'type' => 'dropBox',
|
|
'data' => $statusData,
|
|
'default' => '',
|
|
],
|
|
"buttons" => [
|
|
'sort' => false,
|
|
'class' => 'w20',
|
|
'title' => $this->gM("Actions"),
|
|
'btnset' => [
|
|
'ldelete' => [
|
|
'title' => $this->gM("Delete"),
|
|
],
|
|
],
|
|
],
|
|
];
|
|
|
|
if (!$this->chkP('SYS_SHOW_TABLE_IDS')) {
|
|
unset($tFields['id']);
|
|
}
|
|
|
|
// Chk permission for edit
|
|
if (!$this->chkP('CMS_APP_COUNT_TO_CLASS_EDIT')) {
|
|
$tFields['count']['edit'] = false;
|
|
}
|
|
|
|
// Chk permission for delete
|
|
if (!$this->chkP('CMS_APP_COUNT_TO_CLASS_DELETE')) {
|
|
unset($tFields['buttons']['btnset']['ldelete']);
|
|
}
|
|
|
|
|
|
return $tFields;
|
|
}
|
|
|
|
public function getTableActions(): array
|
|
{
|
|
$data = [
|
|
'idelete' => [
|
|
'lbl' => $this->gM("Delete selected"),
|
|
'sepline' => false,
|
|
'icon' => 'nico-delete',
|
|
],
|
|
];
|
|
|
|
if (!$this->chkP('CMS_APP_COUNT_TO_CLASS_DELETE')) {
|
|
unset($data['idelete']);
|
|
}
|
|
|
|
// Reform drop down
|
|
reformatDropDown($data);
|
|
|
|
return $data;
|
|
}
|
|
|
|
public function getJsTranslationsForView(): array
|
|
{
|
|
return [
|
|
'yes' => $this->gM('Yes'),
|
|
'no' => $this->gM('No'),
|
|
'delTitle' => $this->gM('Delete record?'),
|
|
'delMessage' => $this->gM(
|
|
'Selected records will be permanently deleted and cannot be recovered. Confirm delete?',
|
|
),
|
|
'buttonYes' => $this->gM('Delete selected record'),
|
|
'buttonCancel' => $this->gM('Cancel operation'),
|
|
];
|
|
}
|
|
|
|
public function getJsValCfgForView($bPrepDataCfg = true): array
|
|
{
|
|
$valCfg = [
|
|
// Additional validation config
|
|
'cfg' => [
|
|
cValidator::CFG_BIND_FIELD => 'data-validator',
|
|
],
|
|
'count' => [
|
|
cValidator::P_TYPE => cValidator::TY_FLOAT,
|
|
cValidator::P_COMP => 1,
|
|
cValidator::P_TEST => [cValidator::CHK_NUM],
|
|
],
|
|
];
|
|
|
|
return ($bPrepDataCfg ? cValidator::prepValCfgForValidation($valCfg) : $valCfg);
|
|
}
|
|
}
|