public function postEditlang()
{
User::onlyHas('lang-view');
$oper = Input::get('oper');
$id = Input::get('id');
if ($id == 1) {
Log::error("Editing lang #{$id} disabled");
return [];
}
$jqgrid = new jQgrid('apl_lang');
$result = $jqgrid->operation(array('name' => Input::get('name'), 'ext' => Input::get('ext'), 'enabled' => Input::get('enabled')));
$this->layout = null;
if ($oper == 'add') {
Event::fire('language_created', $result);
Post::addLang($result);
VarLangModel::addLang($result);
}
if ($oper == 'del') {
Event::fire('language_deleted', $id);
Post::removeLang($id);
VarLangModel::removeLang($id);
}
Log::info("Lang operation {$oper} #{$id}");
}
public static function prepareQuery()
{
return VarModel::join(VarLangModel::getTableName(), VarLangModel::getField('var_key'), '=', VarModel::getField('key'))->select(VarLangModel::getField('*'), DB::raw(VarModel::getField('id') . " as vid"), VarModel::getField('parent_key'), VarModel::getField('key'))->where(VarLangModel::getField('lang_id'), \WebAPL\Language::getId());
}
/**
* Load Vars
*/
protected static function loadVars()
{
$vars = \VarModel::prepareQuery()->select(\VarModel::getField('key'), \VarLangModel::getField('value'))->get();
$tmpv = array();
foreach ($vars as $var) {
$tmpv[$var->key] = $var->value;
}
static::$vars = $tmpv;
}
public static function removeLang($lang_id)
{
VarLangModel::where('lang_id', $lang_id)->delete();
}
public function getImport()
{
return [];
$xsdstring = $_SERVER['DOCUMENT_ROOT'] . "/vars.xml";
$excel = new XML2003Parser($xsdstring);
$table = $excel->getTableData();
$ids = [];
foreach ($table["table_contents"] as $row) {
if (isset($row["row_contents"][2]) && isset($row["row_contents"][0])) {
$id = $row["row_contents"][0]['value'];
if ($id && in_array($id, [84]) === FALSE) {
$value = htmlspecialchars_decode($row["row_contents"][2]['value']);
$varlang = VarLangModel::find($id);
if ($varlang) {
$varlang->value = $value;
if ($varlang->value !== $value && strlen(trim($varlang->value)) > 0) {
echo "DIFF [{$varlang->lang_id}] [{$varlang->id}] [[{$varlang->value}]] [[{$value}]]<br>\n";
}
if ($varlang->value !== $value && strlen(trim($varlang->value)) == 0) {
echo "CLEAR [{$varlang->lang_id}] [{$varlang->id}] [[{$varlang->value}]] [[{$value}]]<br>\n";
}
$varlang->save();
} else {
echo "interzis [{$varlang->lang_id}] {$id} {$varlang} <br>\n";
}
} else {
echo "clear<br>\n";
}
}
}
return [];
}
