public function get($model = '', $id = '')
{
if ($id) {
$this->db->where($this->table_name . '.' . $this->primary_key, $id);
}
$mlist = $model->orderby($this->left_column)->get();
echo $this->db->last_query();
for ($i = 0; $i < count($mlist); $i++) {
$model_lang = new Language_Model();
$list_lang = $model_lang->get_with_active();
for ($j = 0; $j < count($list_lang); $j++) {
$model_cat = new Menu_category_description_Model();
$list = $model_cat->get($mlist[$i][$this->primary_key], $list_lang[$j][$this->col_language_id]);
if ($list) {
$list = array_merge($mlist[$i], $list[0]);
} else {
$list = $mlist[$i];
}
$list_lang[$j] = $list;
}
$mlist[$i]['languages'] = $list_lang;
}
return $mlist;
}
<?php
$model_lang = new Language_Model();
$list = $model_lang->get_with_active();
$lang = array();
for ($i = 0; $i < count($list); $i++) {
$lang['txt_name' . $list[$i]['languages_id']] = array('required' => '[' . $list[$i]['languages_name'] . '] Tên được yêu cầu.', 'alpha' => '[' . $list[$i]['languages_name'] . '] Chỉ những ký tự Alphabe được chấp nhận.', 'length' => '[' . $list[$i]['languages_name'] . '] Tên phải từ 3-20 chữ.', 'default' => '[' . $list[$i]['languages_name'] . '] Giá trị nhập không hợp lệ.');
}
private function _save_categories_desc($hd_id, $record)
{
//status = 1 'new', = 2 'edit'
$model_lang = new Language_Model();
$list = $model_lang->get_with_active();
for ($i = 0; $i < count($list); $i++) {
$query = $this->db->query("SELECT * FROM menu_categories_description WHERE menu_categories_id=" . $hd_id . ' AND languages_id =' . $list[$i]['languages_id']);
if ($query->count() > 0) {
$this->db->update('menu_categories_description', array('menu_categories_name' => $record['txt_name' . $list[$i]['languages_id']], 'menu_categories_description' => $record['txt_description' . $list[$i]['languages_id']]), array('menu_categories_id' => $hd_id, 'languages_id' => $list[$i]['languages_id']));
} else {
$this->db->insert('menu_categories_description', array('menu_categories_id' => $hd_id, 'languages_id' => $list[$i]['languages_id'], 'menu_categories_name' => $record['txt_name' . $list[$i]['languages_id']], 'menu_categories_description' => $record['txt_description' . $list[$i]['languages_id']]));
}
}
}
