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']])); } } }