249 lines
10 KiB
PHP
249 lines
10 KiB
PHP
|
<?
|
||
|
|
namespace common;
|
||
|
|
|
||
|
|
use common\client\Face;
|
||
|
|
use core\core\structure\eRowClick;
|
||
|
|
use core\db\structure\Column as C;
|
||
|
|
use core\db\structure\eColumnType;
|
||
|
|
use ms\ms\structure\eTab;
|
||
|
|
use ms\ms\structure\eTabType;
|
||
|
|
use ms\ms\structure\msTo;
|
||
|
|
use ui\form\structure\eInputType;
|
||
|
|
use ui\Form;
|
||
|
|
use ui\input\Input;
|
||
|
|
use core\lang\structure\LangVariable as V;
|
||
|
|
use ms\ms\structure\msModuleTable;
|
||
|
|
use common\client\structure\clientLang as Vars;
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
class Client extends msModuleTable {
|
||
|
|
static $self;
|
||
|
|
static $table_name = 'client';
|
||
|
|
static $controller = 'common.client';
|
||
|
|
|
||
|
|
static $ID = 'id';
|
||
|
|
static $NAME = 'name';
|
||
|
|
static $ACCOUNT = 'account';
|
||
|
|
static $CREATED = 'created';
|
||
|
|
static $UPDATED = 'updated';
|
||
|
|
|
||
|
|
|
||
|
|
static function getTitle(){return V::get(Vars::$MODULE_NAME);}
|
||
|
|
static function getSystemLangValues():array{ return Vars::getArray(); }
|
||
|
|
public function _update(\Where $w, array $values) {
|
||
|
|
$values[self::$UPDATED] = time();
|
||
|
|
return parent::_update($w, $values);
|
||
|
|
}
|
||
|
|
|
||
|
|
public static function getEditTabs($values=[]) {
|
||
|
|
$id = $values[self::$ID];
|
||
|
|
return
|
||
|
|
[
|
||
|
|
[
|
||
|
|
eTab::NAME=>'Редактировать',
|
||
|
|
eTab::TYPE=>eTabType::FORM,
|
||
|
|
eTab::CONTENT=>function($values=[]){
|
||
|
|
return self::_getForm($values, static::getFormOptions($values));
|
||
|
|
},
|
||
|
|
],
|
||
|
|
[
|
||
|
|
eTab::NAME=>'Задачи',
|
||
|
|
eTab::TYPE=>eTabType::TABLE,
|
||
|
|
eTab::CONTENT=>function($values=[]){
|
||
|
|
$id = $values[self::$ID];
|
||
|
|
$o = [
|
||
|
|
\ModuleTable::ROW_CLICK => eRowClick::CARD,
|
||
|
|
\Query::WHERE=>new \Where(
|
||
|
|
\Where::_and([
|
||
|
|
\Where::_operator(Task::$TO,'=',msTo::CLIENT),
|
||
|
|
\Where::_operator(Task::$OID,'=',$id),
|
||
|
|
])
|
||
|
|
|
||
|
|
),
|
||
|
|
\ModuleTable::FORM_INIT_DATA=>[
|
||
|
|
Task::$TO => msTo::CLIENT,
|
||
|
|
Task::$OID => $id,
|
||
|
|
],
|
||
|
|
\ModuleTable::TABLE_ID => self::$table_name.'_'.Task::$table_name.'_'.$id,
|
||
|
|
/*
|
||
|
|
\ModuleTable::COLUMN_RENDER => [
|
||
|
|
Face::$NAME => [
|
||
|
|
\ModuleTable::COLUMN_RENDER_LINK_ID => $link_id,
|
||
|
|
\ModuleTable::COLUMN_RENDER_LINK_CSS_CLASS => 'link',
|
||
|
|
//ModuleTable::COLUMN_RENDER_LINK_MODAL => true,
|
||
|
|
],
|
||
|
|
]
|
||
|
|
/**/
|
||
|
|
];
|
||
|
|
return $values['justData'] ? Task::getTableData( $o ) : Task::drawTable( $o );
|
||
|
|
},
|
||
|
|
],
|
||
|
|
[
|
||
|
|
eTab::NAME=>'Контакты',
|
||
|
|
eTab::TYPE=>eTabType::TABLE,
|
||
|
|
eTab::CONTENT=>function($values=[]){
|
||
|
|
$id = $values[self::$ID];
|
||
|
|
$o = [
|
||
|
|
\ModuleTable::ROW_CLICK => eRowClick::CARD,
|
||
|
|
\Query::WHERE=>new \Where(
|
||
|
|
\Where::_and([
|
||
|
|
\Where::_operator(Contact::$TO,'=',msTo::CLIENT),
|
||
|
|
\Where::_operator(Contact::$OID,'=',$id),
|
||
|
|
])
|
||
|
|
|
||
|
|
),
|
||
|
|
\ModuleTable::FORM_INIT_DATA=>[
|
||
|
|
Contact::$TO => msTo::CLIENT,
|
||
|
|
Contact::$OID => $id,
|
||
|
|
],
|
||
|
|
\ModuleTable::TABLE_ID => self::$table_name.'_'.Contact::$table_name.'_'.$id,
|
||
|
|
/*
|
||
|
|
\ModuleTable::COLUMN_RENDER => [
|
||
|
|
Face::$NAME => [
|
||
|
|
\ModuleTable::COLUMN_RENDER_LINK_ID => $link_id,
|
||
|
|
\ModuleTable::COLUMN_RENDER_LINK_CSS_CLASS => 'link',
|
||
|
|
//ModuleTable::COLUMN_RENDER_LINK_MODAL => true,
|
||
|
|
],
|
||
|
|
]
|
||
|
|
/**/
|
||
|
|
];
|
||
|
|
return $values['justData'] ? Contact::getTableData( $o ) : Contact::drawTable( $o );
|
||
|
|
},
|
||
|
|
],
|
||
|
|
[
|
||
|
|
eTab::NAME=>'Контактные лица',
|
||
|
|
eTab::TYPE=>eTabType::TABLE,
|
||
|
|
eTab::CONTENT=>function($values=[]){
|
||
|
|
$id = $values[self::$ID];
|
||
|
|
$link_id = '/project/clients/'.$id.'/';
|
||
|
|
$o = [
|
||
|
|
\ModuleTable::ROW_CLICK => eRowClick::CARD,
|
||
|
|
\Query::WHERE=>new \Where(
|
||
|
|
\Where::_and([
|
||
|
|
\Where::_operator(Face::$TO,'=',msTo::CLIENT),
|
||
|
|
\Where::_operator(Face::$OID,'=',$id),
|
||
|
|
])
|
||
|
|
),
|
||
|
|
\ModuleTable::FORM_INIT_DATA=>[
|
||
|
|
Face::$TO => msTo::CLIENT,
|
||
|
|
Face::$OID => $id,
|
||
|
|
],
|
||
|
|
\ModuleTable::TABLE_ID => self::$table_name.'_'.Face::$table_name.'_'.$id,
|
||
|
|
\ModuleTable::COLUMN_RENDER => [
|
||
|
|
Face::$NAME => [
|
||
|
|
\ModuleTable::COLUMN_RENDER_LINK_ID => $link_id,
|
||
|
|
\ModuleTable::COLUMN_RENDER_LINK_CSS_CLASS => 'link',
|
||
|
|
//ModuleTable::COLUMN_RENDER_LINK_MODAL => true,
|
||
|
|
],
|
||
|
|
]
|
||
|
|
] ;
|
||
|
|
return $values['justData'] ? Face::getTableData( $o ) : Face::drawTable( $o );
|
||
|
|
},
|
||
|
|
],
|
||
|
|
[
|
||
|
|
eTab::NAME=>'Заметки',
|
||
|
|
eTab::TYPE=>eTabType::TABLE,
|
||
|
|
eTab::CONTENT=>function($values=[]){
|
||
|
|
$id = $values[self::$ID];
|
||
|
|
$o = [
|
||
|
|
\ModuleTable::ROW_CLICK => eRowClick::CARD,
|
||
|
|
\Query::WHERE=>new \Where(
|
||
|
|
\Where::_and([
|
||
|
|
\Where::_operator(Note::$TO,'=',msTo::CLIENT),
|
||
|
|
\Where::_operator(Note::$OID,'=',$id),
|
||
|
|
])
|
||
|
|
|
||
|
|
),
|
||
|
|
\ModuleTable::FORM_INIT_DATA=>[
|
||
|
|
Note::$TO => msTo::CLIENT,
|
||
|
|
Note::$OID => $id,
|
||
|
|
],
|
||
|
|
\ModuleTable::TABLE_ID => self::$table_name.'_'.Note::$table_name.'_'.$id
|
||
|
|
];
|
||
|
|
return $values['justData'] ? Note::getTableData( $o ) : Note::drawTable( $o );
|
||
|
|
},
|
||
|
|
],
|
||
|
|
];
|
||
|
|
}
|
||
|
|
|
||
|
|
static function getForm($values = [], $options = []) :array {
|
||
|
|
return [
|
||
|
|
self::getCommonFormInputs(),
|
||
|
|
[
|
||
|
|
Form::VIEW=>Form::ROW,
|
||
|
|
Form::COLS => [
|
||
|
|
[
|
||
|
|
Form::VIEW =>Form::INPUT,
|
||
|
|
Form::COL_CLASSES =>'col-12',
|
||
|
|
Form::KEY_VALUE =>self::$NAME,
|
||
|
|
Form::TYPE =>eInputType::TEXT,
|
||
|
|
Form::INPUT_OPT => [
|
||
|
|
Input::PLACEHOLDER => $c = V::get(Vars::$NAME),
|
||
|
|
Input::LABEL => $c,
|
||
|
|
],
|
||
|
|
],
|
||
|
|
]
|
||
|
|
],
|
||
|
|
self::getCommonFormSubmits($values),
|
||
|
|
];
|
||
|
|
}
|
||
|
|
|
||
|
|
static function columnInfo() : array {
|
||
|
|
return [
|
||
|
|
new C([
|
||
|
|
C::VAR_NAME =>&self::$ID,
|
||
|
|
C::TYPE =>eColumnType::INT,
|
||
|
|
C::AUTO_INCREMENT =>true,
|
||
|
|
C::PRIMARY =>true,
|
||
|
|
C::DEFAULT =>0,
|
||
|
|
C::HIDDEN =>true,
|
||
|
|
C::TH =>V::get(Vars::$ID),
|
||
|
|
]),
|
||
|
|
new C([
|
||
|
|
C::VAR_NAME => &self::$NAME,
|
||
|
|
C::TYPE => eColumnType::VARCHAR,
|
||
|
|
C::LENGTH => 1023,
|
||
|
|
C::TH => V::get(Vars::$NAME),
|
||
|
|
]),
|
||
|
|
new C([
|
||
|
|
C::VAR_NAME => &self::$ACCOUNT,
|
||
|
|
C::TYPE => eColumnType::INT,
|
||
|
|
C::LENGTH => 11,
|
||
|
|
C::TH => V::get(Vars::$ACCOUNT),
|
||
|
|
C::DEFAULT => intval(UID),
|
||
|
|
c::HIDDEN=>true,
|
||
|
|
c::FUNC_VALUE => function($v){
|
||
|
|
if($id = $v[self::$ACCOUNT]) {
|
||
|
|
return \Account::getName( \Account::getByID($id) );
|
||
|
|
} else return '-';
|
||
|
|
},
|
||
|
|
]),
|
||
|
|
new C([
|
||
|
|
C::VAR_NAME => &self::$CREATED,
|
||
|
|
C::TYPE => eColumnType::INT,
|
||
|
|
C::LENGTH => 11,
|
||
|
|
C::TH => V::get(Vars::$CREATED),
|
||
|
|
C::DEFAULT => time(),
|
||
|
|
c::FUNC_VALUE => function($v){return self::formatDate($v[self::$CREATED]);},
|
||
|
|
c::HIDDEN=>true,
|
||
|
|
]),
|
||
|
|
new C([
|
||
|
|
C::VAR_NAME => &self::$UPDATED,
|
||
|
|
C::TYPE => eColumnType::INT,
|
||
|
|
C::DEFAULT => time(),
|
||
|
|
C::TH => V::get(Vars::$UPDATED),
|
||
|
|
c::FUNC_VALUE => function($v){return self::formatDate($v[self::$UPDATED]);},
|
||
|
|
c::HIDDEN=>true,
|
||
|
|
]),
|
||
|
|
];
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
new Client();
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|