public function registerRegional()
{
$lang = Data::getLocale();
if ($lang != 'en') {
$langAsset = 'lang/' . $lang . '.js';
if (file_exists(Yii::getAlias($this->assetBundle->sourcePath . '/' . $langAsset))) {
$this->assetBundle->js[] = $langAsset;
$this->options['lang'] = $lang;
}
}
}
/**
* (null) getCodesByName1 : 通过classmark及name1获取相关参数编码
* @static
* @param $classmark : 参数类型
* @param $name1 : 参数名称
* @return string 参数编码
*/
public static function getCodesByName1($classmark, $name1)
{
self::$_classmark = $classmark;
self::$_name1 = $name1;
self::$_data = Data::cache(self::CACHE_KEY . self::$_classmark . '_ARRAYDATA_NAME1TOCODES', 3600, function () {
$result = [];
try {
foreach (parent::find()->where(['status' => self::STATUS_ACTIVE, 'classmark' => self::$_classmark])->all() as $preferences) {
$result[$preferences->classmark][$preferences->name1] = $preferences->codes;
}
} catch (\yii\db\Exception $e) {
}
return $result;
});
return isset(self::$_data[$classmark][$name1]) ? self::$_data[$classmark][$name1] : null;
}
public static function findAllActive()
{
// 1h 的缓存
return Data::cache(self::CACHE_KEY, 3600, function () {
$result = [];
try {
foreach (self::find()->where(['status' => self::STATUS_ON])->sort()->all() as $module) {
$module->trigger(self::EVENT_AFTER_FIND);
$result[$module->name] = (object) $module->attributes;
}
} catch (Exception $e) {
}
return $result;
});
}
/**
* (null) getColumnInfoByTablename : 通过表名返回 数组[英文字段名=>中文字段名]
* @static
* @param $tablename: 表名 eg：personal
* @return array
*/
public static function getColumnInfoByTablename($tablename)
{
//拼接SQL语句
self::$_sql = "SELECT CONCAT(pbc_tnam , '.', pbc_cnam) pbc_cnam, " . " CONCAT(CASE pbc_tnam WHEN 'personal' THEN '员工本人-' WHEN 'marry' THEN '配偶情况-' WHEN 'child' THEN '子女情况-'" . " WHEN 'jedt' THEN '避孕情况-' WHEN 'ycdt' THEN '孕产动态-' WHEN 'check1' THEN '妇检情况-' WHEN 'letter' THEN '联系函-'" . " WHEN 'holidays_data' THEN '休假情况-' WHEN 'xsb' THEN '亲属情况-' WHEN 'unit' THEN '单位情况-'" . " ELSE '' END,pbc_labl) pbc_labl FROM `col_table`" . " where status=:status and pbc_tnam=:pbc_tnam order by sort_no asc";
self::$_tablename = $tablename;
self::$_data = Data::cache(self::CACHE_KEY . self::$_tablename . '_ARRAYDATA', 3600, function () {
$result = [];
try {
$result[self::$_tablename] = ArrayHelper::map(parent::getDb()->createCommand(self::$_sql)->bindValues([':status' => self::STATUS_ACTIVE, ':pbc_tnam' => self::$_tablename])->queryAll(), 'pbc_cnam', 'pbc_labl');
} catch (\yii\db\Exception $e) {
}
return $result;
});
return isset(self::$_data[$tablename]) ? self::$_data[$tablename] : null;
}
