471 lines
18 KiB
PHP
471 lines
18 KiB
PHP
<?
|
|
namespace academy;
|
|
|
|
use academy\course\Section;
|
|
use academy\course\Lesson;
|
|
use academy\course\structure\eAcademyCourseType;
|
|
use common\Image;
|
|
use core\db\structure\Column as C;
|
|
use core\db\structure\Column;
|
|
use core\db\structure\eColumnType;
|
|
use ms\MS;
|
|
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 academy\course\structure\academyCourseLang as Vars;
|
|
use academy\course\Teacher as CourseTeacher;
|
|
use common\Review;
|
|
|
|
class Course extends msModuleTable {
|
|
static $self;
|
|
static $table_name = 'academyCorse';
|
|
static $controller = 'academy.course';
|
|
static $easy_left_joins = [];
|
|
|
|
static $ID = 'id';
|
|
static $NAME = 'name';
|
|
static $DESCR = 'descr';
|
|
static $BG = 'bg';
|
|
static $AVA = 'ava';
|
|
static $TEXT_ID = 'text_id';
|
|
static $PROJECT = 'project';
|
|
static $ACADEMY = 'academy';
|
|
static $POS = 'pos';
|
|
static $PROFILE = 'profile';
|
|
static $TYPE = 'type';
|
|
static $BEGIN = 'begin';
|
|
static $END = 'end';
|
|
static $ANNOTATION = 'annotation';
|
|
static $ACCOUNT = 'account';
|
|
static $CREATED = 'created';
|
|
static $UPDATED = 'updated';
|
|
static $VIS = 'vis';
|
|
|
|
public function __construct($install_id = null) {
|
|
parent::__construct($install_id);
|
|
static::$easy_left_joins = [
|
|
[[Image::$table_name,'bg' ],self::$BG ,Image::$ID],
|
|
[[Image::$table_name,'ava'],self::$AVA,Image::$ID],
|
|
];
|
|
}
|
|
|
|
public function _select($options, $collectToAssocArray = false) {
|
|
$select = [self::$table_name.'.*'];
|
|
$c = Image::getColumns();
|
|
/** @var Column $v */
|
|
foreach ($c as $v){
|
|
$name = $v->getName();
|
|
$select[] = 'bg.'.$name.' as bg_'.$name;
|
|
$select[] = 'ava.'.$name.' as ava_'.$name;
|
|
}
|
|
if(!$options[\Query::SELECT]) $options[\Query::SELECT] = implode(",",$select);
|
|
return parent::_select($options, $collectToAssocArray); // TODO: Change the autogenerated stub
|
|
}
|
|
|
|
|
|
static function getVisibleReviewsById($id,$count = 0, $page = 0,$isAssoc = true){
|
|
$id = intval($id);
|
|
return Review::select([
|
|
\Query::WHERE => new \Where(\Where::_and([
|
|
\Where::_operator(Review::$TO,'=',msTo::ACADEMY_COURSE),
|
|
\Where::_operator(Review::$OID,'=',$id),
|
|
\Where::_operator(Review::$VIS,'=',1),
|
|
])),
|
|
\Query::SORT => [self::$ID=>'DESC'],
|
|
\Query::COUNT => $count,
|
|
\Query::OFFSET => $count*$page,
|
|
],$isAssoc);
|
|
}
|
|
|
|
|
|
static function getMyAllTeachCourse(){
|
|
return self::select([
|
|
\Query::WHERE => new \Where(\Where::_operator(self::$PROFILE,'=',PID)),
|
|
]);
|
|
}
|
|
|
|
static function canIEdit($course){
|
|
return $course[Course::$PROFILE]==PID;
|
|
}
|
|
|
|
static function getBgImg($v,$width=600,$height=0,$o=100){
|
|
if($c = $v['bg_'.Image::$URL]) {
|
|
return Image::imageResize($c,$width,$height,$o);
|
|
} else return '';
|
|
}
|
|
static function getAvaImg($v,$width=600,$height=0,$o=100){
|
|
if($c = $v['ava_'.Image::$URL]) {
|
|
return Image::imageResize($c,$width,$height,$o);
|
|
} else return '';
|
|
}
|
|
static function getDescr($C){
|
|
return ($c = $C[self::$DESCR])?$c:'<p>Введите описание</p>';
|
|
}
|
|
|
|
|
|
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);
|
|
}
|
|
|
|
static function getTeachersCount($course_id){
|
|
$res = 0;
|
|
$course_id = intval($course_id);
|
|
if(!$course_id) return $res;
|
|
$res = CourseTeacher::select([
|
|
\Query::SELECT => 'COUNT('.CourseTeacher::$ID.') as cc',
|
|
\Query::WHERE => new \Where(\Where::_operator(CourseTeacher::$COURSE,'=',$course_id)),
|
|
],false);
|
|
$res = \DB::fetch($res);
|
|
return intval($res['cc']);
|
|
}
|
|
static function getTeachers($course_id){
|
|
$res = [];
|
|
$course_id = intval($course_id);
|
|
if(!$course_id) return $res;
|
|
$res = CourseTeacher::select([
|
|
\Query::WHERE => new \Where(\Where::_operator(CourseTeacher::$COURSE,'=',$course_id)),
|
|
\Query::SORT => [CourseTeacher::$POS],
|
|
],true);
|
|
return $res;
|
|
}
|
|
|
|
static function getLessons($course_id){
|
|
$res = ['sections'=>[],'lessons'=>[]];
|
|
$course_id = intval($course_id);
|
|
if(!$course_id) return $res;
|
|
|
|
|
|
$r = Section::select($query = [
|
|
\Query::WHERE => new \Where( \Where::_operator(Section::$COURSE,'=',$course_id) ),
|
|
\Query::SORT => [Section::$POS],
|
|
],false);
|
|
|
|
|
|
while($l = \DB::fetch($r)){
|
|
$section_id = $l[Section::$ID];
|
|
$res['sections'][$section_id] = $l;
|
|
}
|
|
|
|
$r = Lesson::select($query = [
|
|
\Query::SELECT => implode(",",[Lesson::$ID,Lesson::$NAME,Lesson::$POS,Lesson::$SETTINGS,Lesson::$COURSE,Lesson::$SECTION]),
|
|
\Query::WHERE => new \Where( \Where::_operator(Lesson::$COURSE,'=',$course_id) ),
|
|
\Query::SORT => [Lesson::$POS],
|
|
],false);
|
|
// Если уроков нет, то создадим первый
|
|
|
|
if(!\DB::numRows($r)){
|
|
if(!$res['sections']) {
|
|
$section = Section::insert($c = [
|
|
Section::$NAME => 'Первый раздел',
|
|
Section::$COURSE => $course_id,
|
|
Section::$POS => 1,
|
|
]);
|
|
$section_id = $section->id;
|
|
$res['sections'][$section_id] = $c;
|
|
} else {
|
|
$section_id = array_keys($res['sections'])[0];
|
|
}
|
|
Lesson::insert([
|
|
Lesson::$NAME => 'Первый урок',
|
|
Lesson::$COURSE => $course_id,
|
|
Lesson::$SECTION => $section_id,
|
|
Lesson::$POS => 1,
|
|
]);
|
|
$r = Lesson::select($query);
|
|
}
|
|
while($l = \DB::fetch($r)){
|
|
$section_id = $l[Lesson::$SECTION];
|
|
$lesson_id = $l[Lesson::$ID];
|
|
$res['sections'][$section_id]['lessons'][] = $lesson_id;
|
|
$res['lessons'][$lesson_id] = $l;
|
|
}
|
|
return $res;
|
|
}
|
|
|
|
static function getForm($values = [], $options = []) :array {
|
|
$academies = Academy::getNameList([
|
|
\Query::WHERE => new \Where(\Where::_operator(Academy::$ACCOUNT,'=',UID))
|
|
]);
|
|
return [
|
|
self::getCommonFormInputs(),
|
|
[
|
|
Form::VIEW=>Form::ROW,
|
|
Form::COLS => [
|
|
[
|
|
Form::VIEW => Form::INPUT,
|
|
Form::COL_CLASSES => 'c',
|
|
Form::KEY_VALUE => self::$AVA,
|
|
Form::TYPE => eInputType::IMAGE,
|
|
Form::INPUT_OPT => [
|
|
Input::PLACEHOLDER => $c = V::get(Vars::$AVA),
|
|
Input::LABEL => $c,
|
|
Input::SRC => ($c = $values[self::$AVA]) ? Image::imageResize(Image::getByID($c)[Image::$URL],600,0,100) : '',
|
|
],
|
|
],
|
|
]
|
|
],
|
|
[
|
|
Form::VIEW=>Form::ROW,
|
|
Form::COLS => [
|
|
[
|
|
Form::VIEW =>Form::INPUT,
|
|
Form::COL_CLASSES =>'c-1-3',
|
|
Form::KEY_VALUE =>self::$NAME,
|
|
Form::TYPE =>eInputType::TEXT,
|
|
Form::INPUT_OPT => [
|
|
Input::PLACEHOLDER => $c = V::get(Vars::$NAME),
|
|
Input::LABEL => $c,
|
|
],
|
|
],
|
|
[
|
|
Form::VIEW =>Form::INPUT,
|
|
Form::COL_CLASSES =>'c-1-3',
|
|
Form::KEY_VALUE =>self::$TEXT_ID,
|
|
Form::TYPE =>eInputType::TEXT,
|
|
Form::INPUT_OPT => [
|
|
Input::PLACEHOLDER => $c = V::get(Vars::$TEXT_ID),
|
|
Input::LABEL => $c,
|
|
Input::VALUE => ($c = $values[self::$TEXT_ID]) ? $c : 'course'.time()
|
|
],
|
|
],
|
|
[
|
|
Form::VIEW =>Form::INPUT,
|
|
Form::COL_CLASSES =>'c-1-3',
|
|
Form::KEY_VALUE =>self::$ACADEMY,
|
|
Form::TYPE =>eInputType::SELECT_SEARCH,
|
|
Form::INPUT_OPT => [
|
|
Input::PLACEHOLDER => $c = V::get(Vars::$ACADEMY),
|
|
Input::LABEL => $c,
|
|
Input::OPTIONS => $academies,
|
|
],
|
|
],
|
|
|
|
|
|
]
|
|
],
|
|
[
|
|
Form::VIEW=>Form::ROW,
|
|
Form::COLS => [
|
|
[
|
|
Form::VIEW =>Form::INPUT,
|
|
Form::COL_CLASSES =>'c-1-3',
|
|
Form::KEY_VALUE =>self::$VIS,
|
|
Form::TYPE =>eInputType::SWITCH_IOS,
|
|
Form::INPUT_OPT => [
|
|
Input::PLACEHOLDER => $c = V::get(Vars::$VIS),
|
|
Input::LABEL => ' ',
|
|
Input::OPTIONS => $academies,
|
|
Input::CHECKED => boolval($values[self::$VIS]),
|
|
Input::VALUE=>1,
|
|
],
|
|
],
|
|
[
|
|
Form::VIEW =>Form::INPUT,
|
|
Form::COL_CLASSES =>'c-1-3',
|
|
Form::KEY_VALUE =>self::$BEGIN,
|
|
Form::TYPE =>eInputType::DATE,
|
|
Form::INPUT_OPT => [
|
|
Input::PLACEHOLDER => $c = V::get(Vars::$BEGIN),
|
|
Input::LABEL => $c,
|
|
],
|
|
],
|
|
[
|
|
Form::VIEW =>Form::INPUT,
|
|
Form::COL_CLASSES =>'c-1-3',
|
|
Form::KEY_VALUE =>self::$END,
|
|
Form::TYPE =>eInputType::DATE,
|
|
Form::INPUT_OPT => [
|
|
Input::PLACEHOLDER => $c = V::get(Vars::$END),
|
|
Input::LABEL => $c,
|
|
],
|
|
],
|
|
]
|
|
],
|
|
[
|
|
Form::VIEW=>Form::ROW,
|
|
Form::COLS => [
|
|
[
|
|
Form::VIEW =>Form::INPUT,
|
|
Form::COL_CLASSES =>'c-100',
|
|
Form::KEY_VALUE =>self::$ANNOTATION,
|
|
Form::TYPE =>eInputType::TEXTAREA,
|
|
Form::INPUT_OPT => [
|
|
Input::PLACEHOLDER => $c = V::get(Vars::$ANNOTATION),
|
|
Input::LABEL => $c,
|
|
],
|
|
],
|
|
]
|
|
],
|
|
[
|
|
Form::VIEW=>Form::ROW,
|
|
Form::COLS => [
|
|
[
|
|
Form::VIEW =>Form::INPUT,
|
|
Form::COL_CLASSES =>'c-100',
|
|
Form::KEY_VALUE =>self::$DESCR,
|
|
Form::TYPE =>eInputType::TEXTAREA,
|
|
Form::INPUT_OPT => [
|
|
Input::PLACEHOLDER => $c = V::get(Vars::$DESCRIPTION),
|
|
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::$BG,
|
|
C::TYPE => eColumnType::INT,
|
|
C::DEFAULT => 0,
|
|
C::HIDDEN => true,
|
|
]),
|
|
new C([
|
|
C::VAR_NAME => &self::$AVA,
|
|
C::TYPE => eColumnType::INT,
|
|
C::DEFAULT => 0,
|
|
C::HIDDEN => true,
|
|
]),
|
|
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::$DESCR,
|
|
C::TYPE => eColumnType::TEXT,
|
|
//C::LENGTH => 1023,
|
|
//C::TH => V::get(Vars::$NAME),
|
|
C::HIDDEN => true,
|
|
]),
|
|
new C([
|
|
C::VAR_NAME => &self::$BEGIN,
|
|
C::TYPE => eColumnType::DATE,
|
|
//C::LENGTH => 1023,
|
|
C::TH => V::get(Vars::$BEGIN),
|
|
c::FUNC_VALUE_DATA => function($v){return self::formatDateString($v[self::$BEGIN]);},
|
|
]),
|
|
new C([
|
|
C::VAR_NAME => &self::$END,
|
|
C::TYPE => eColumnType::DATE,
|
|
//C::LENGTH => 1023,
|
|
C::TH => V::get(Vars::$END),
|
|
c::FUNC_VALUE_DATA => function($v){return self::formatDateString($v[self::$END]);},
|
|
]),
|
|
new C([
|
|
C::VAR_NAME => &self::$TEXT_ID,
|
|
C::TYPE => eColumnType::VARCHAR,
|
|
C::LENGTH => 63,
|
|
C::TH => V::get(Vars::$TEXT_ID),
|
|
]),
|
|
new C([
|
|
C::VAR_NAME => &self::$PROFILE,
|
|
C::TYPE => eColumnType::INT,
|
|
C::DEFAULT => PID,
|
|
C::HIDDEN => true,
|
|
//C::TH => V::get(Vars::$NAME),
|
|
]),
|
|
new C([
|
|
C::VAR_NAME => &self::$ACADEMY,
|
|
C::TYPE => eColumnType::INT,
|
|
C::DEFAULT => 0,
|
|
C::HIDDEN => true,
|
|
//C::TH => V::get(Vars::$NAME),
|
|
]),
|
|
new C([
|
|
C::VAR_NAME => &self::$ANNOTATION,
|
|
C::TYPE => eColumnType::TEXT,
|
|
C::DEFAULT => '',
|
|
C::HIDDEN => true,
|
|
//C::TH => V::get(Vars::$NAME),
|
|
]),
|
|
new C([
|
|
C::VAR_NAME => &self::$TYPE,
|
|
C::TYPE => eColumnType::TINYINT,
|
|
C::DEFAULT => eAcademyCourseType::FREE,
|
|
C::LENGTH => 1,
|
|
C::HIDDEN => true,
|
|
//C::TH => V::get(Vars::$NAME),
|
|
]),
|
|
new C([
|
|
C::VAR_NAME => &self::$PROJECT,
|
|
C::TYPE => eColumnType::INT,
|
|
C::DEFAULT => 0,
|
|
C::HIDDEN => true,
|
|
//C::TH => V::get(Vars::$NAME),
|
|
]),
|
|
new C([
|
|
C::VAR_NAME => &self::$VIS,
|
|
C::TYPE => eColumnType::TINYINT,
|
|
C::LENGTH => 1,
|
|
C::DEFAULT => 0,
|
|
C::TH => V::get(Vars::$VIS),
|
|
C::FUNC_VALUE_DATA => function($v){
|
|
return MS::getBoolValText($v[self::$VIS]);
|
|
}
|
|
]),
|
|
new C([
|
|
C::VAR_NAME => &self::$POS,
|
|
C::TYPE => eColumnType::INT,
|
|
C::DEFAULT => time(),
|
|
//C::TH => V::get(Vars::$NAME),
|
|
C::HIDDEN => true,
|
|
]),
|
|
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 Course();
|
|
|
|
|
|
///
|