private function _pageEditTochuc()
{
$deptRoot = TochucHelper::getRoot();
//$deps = TochucHelper::collect('ins_dept', array('id AS value','name AS text'),array('type = 1','active = 1'),array('lft ASC'));
$option[] = array("value" => '', "text" => '');
$option[] = array("value" => $deptRoot['id'], "text" => $deptRoot['name']);
//$deps = array_merge($option, $deps);
// $inArray = TochucHelper::collect('ins_dept', array('id','parent_id','name',"IF((type = 1),'item','folder') AS type"));
// $outArray = array();
//TochucHelper::makeDataForTree(&$inArray, &$outArray);
//unset($inArray);
$inArray = TochucHelper::collect('ins_cap', array('id', 'parent_id', 'name', "IF((rgt-lft) = 1,'item','folder') AS type"), array('status = 1'));
//var_dump($inArray);
$tree_data_ins_cap = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_cap, TochucHelper::getRootCapTochuc());
unset($inArray);
$inArray = TochucHelper::collect('cb_goichucvu', array('id', 'parent_id', 'name', "IF((rgt-lft) = 1,'item','folder') AS type"), array('status = 1'));
//var_dump($inArray);exit;
$tree_data_ins_goichucvu = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_goichucvu, TochucHelper::getRootGoichucvu());
unset($inArray);
$inArray = TochucHelper::collect('cb_goiluong', array('id', 'parent_id', 'name', "IF((rgt-lft) = 1,'item','folder') AS type"), array('status = 1'));
$tree_data_ins_goiluong = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_goiluong, TochucHelper::getRootGoiLuong());
unset($inArray);
$inArray = TochucHelper::collect('cb_type_linhvuc', array('id', 'parent_id', 'name', "IF((rgt-lft) = 1,'item','folder') AS type"));
$tree_data_ins_linhvuc = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_linhvuc, TochucHelper::getRootLinhvucTochuc());
unset($inArray);
$inArray = TochucHelper::collect('ins_dept', array('id', 'parent_id', 'name', "IF((type = 1),'item','folder') AS type"), array('type IN (1,2,3)'), 'lft ASC');
$tree_data_ins_dept = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_dept);
unset($inArray);
// $model = JModelLegacy::getInstance('Tochuc','TochucModel');
$model = Core::model('Tochuc/Tochuc');
$dept_id = JRequest::getInt('id', 0);
$row = null;
$arr_ins_created = TochucHelper::collect('ins_dept', array('id AS value', 'name AS text'), array('type IN (1,3)'), 'lft ASC');
$arr_ins_created = array_merge(array(array('value' => '', 'text' => '')), $arr_ins_created);
if ((int) $dept_id > 0) {
$row = $model->read($dept_id);
}
if ($row->id == null) {
$vanban_created = array();
$trangthai = array();
$file_created = array();
$file_trangthai = array();
$row->active = 1;
$row->type = JRequest::getInt("type", 0);
$linhvuc = array();
} else {
$vanban_created = $model->getVanbanById($row->vanban_created);
$trangthai = $model->getVanbanById($row->vanban_active);
$file_created = $model->getFilebyIdVanban($row->vanban_created);
$file_trangthai = $model->getFilebyIdVanban($row->vanban_active);
$linhvuc = $model->getLinhvucByIdDept($row->id);
$row->type = JRequest::getInt("type", 0);
}
$caybaocao = $model->getCayBaocao();
$this->assignRef('caybaocao', $caybaocao);
//var_dump($linhvuc);
$this->assignRef('Itemid', JFactory::getApplication()->input->get('Itemid'));
//$this->assignRef('deps', $deps);
$this->assignRef('tree_data_ins_cap', json_encode($tree_data_ins_cap));
$this->assignRef('tree_data_ins_dept', json_encode($tree_data_ins_dept));
$this->assignRef('row', $row);
$this->assignRef('vanban_created', $vanban_created);
$this->assignRef('trangthai', $trangthai);
$this->assignRef('linhvuc', $linhvuc);
$this->assignRef('file_created', $file_created);
$this->assignRef('file_trangthai', $file_trangthai);
$this->assignRef('arr_ins_created', $arr_ins_created);
unset($tree_data_ins_cap);
unset($tree_data_ins_goichucvu);
unset($tree_data_ins_goiluong);
unset($tree_data_ins_linhvuc);
unset($tree_data_ins_dept);
unset($row);
unset($vanban_created);
unset($file_created);
unset($trangthai);
unset($file_trangthai);
}
private function _initEditPage()
{
$document = JFactory::getDocument();
$document->addCustomTag('<link href="' . JURI::base(true) . '/media/cbcc/css/jquery.fileupload.css" rel="stylesheet" />');
$document->addCustomTag('<link href="' . JURI::base(true) . '/media/cbcc/js/jstree/themes/default/style.css" rel="stylesheet" />');
$document->addScript(JURI::base(true) . '/media/cbcc/js/jquery/jquery.validate.min.js');
$document->addScript(JURI::base(true) . '/media/cbcc/js/jquery/jquery.validate.default.js');
$document->addScript(JURI::base(true) . '/media/cbcc/js/jstree/jquery.jstree.js');
$document->addScript(JURI::base(true) . '/media/cbcc/js/fuelux/fuelux.tree.min.js');
$document->addScript(JURI::base(true) . '/media/cbcc/js/jquery/chosen.jquery.min.js');
$document->addScript(JURI::base(true) . '/media/cbcc/js/jquery.maskedinput.min.js');
$document->addScript(JURI::base(true) . '/media/cbcc/js/jquery/upload/jquery.iframe-transport.js');
$document->addScript(JURI::base(true) . '/media/cbcc/js/jquery/upload/jquery.fileupload.js');
$deptRoot = TochucHelper::getRoot();
$deps = TochucHelper::collect('ins_dept', array('id AS value', 'name AS text'), array('type = 1', 'active = 1'), array('lft ASC'));
$option[] = array("value" => '', "text" => '');
$option[] = array("value" => $deptRoot['id'], "text" => $deptRoot['name']);
$deps = array_merge($option, $deps);
// $inArray = TochucHelper::collect('ins_dept', array('id','parent_id','name',"IF((type = 1),'item','folder') AS type"));
// $outArray = array();
//TochucHelper::makeDataForTree(&$inArray, &$outArray);
//unset($inArray);
$inArray = TochucHelper::collect('ins_cap', array('id', 'parent_id', 'name', "IF((rgt-lft) = 1,'item','folder') AS type"), array('status = 1'));
//var_dump($inArray);
$tree_data_ins_cap = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_cap, TochucHelper::getRootCapTochuc());
unset($inArray);
$inArray = TochucHelper::collect('ins_level', array('id', 'parent_id', 'name', "IF((rgt-lft) = 1,'item','folder') AS type"), array('status = 1'));
$tree_data_ins_level = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_level, 1);
unset($inArray);
$inArray = TochucHelper::collect('pos_system', array('id', 'parent_id', 'name', "IF((rgt-lft) = 1,'item','folder') AS type"), array('status = 1'));
$tree_data_ins_goichucvu = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_goichucvu, TochucHelper::getRootGoichucvu());
unset($inArray);
$inArray = TochucHelper::collect('cb_goiluong', array('id', 'parent_id', 'name', "IF((rgt-lft) = 1,'item','folder') AS type"), array('status = 1'));
$tree_data_ins_goiluong = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_goiluong, TochucHelper::getRootGoiLuong());
unset($inArray);
$inArray = TochucHelper::collect('cb_type_linhvuc', array('id', 'parent_id', 'name', "IF((rgt-lft) = 1,'item','folder') AS type"));
$tree_data_ins_linhvuc = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_linhvuc, TochucHelper::getRootLinhvucTochuc());
unset($inArray);
$inArray = TochucHelper::collect('ins_dept_loaihinh', array('id', 'parent_id', 'name', "IF((rgt-lft) = 1,'item','folder') AS type"));
$tree_data_ins_loaihinh = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_loaihinh, TochucHelper::getRootLoaihinh());
unset($inArray);
$inArray = TochucHelper::collect('ins_dept', array('id', 'parent_id', 'name', "IF((type = 1),'item','folder') AS type"), array('type IN (1,2,3)'), 'lft ASC');
$tree_data_ins_dept = array();
TochucHelper::makeDataForTree($inArray, $tree_data_ins_dept, $deptRoot['id']);
unset($inArray);
// $inArray = TochucHelper::getAllVoboc();
// $tree_data_ins_parent = array();
// TochucHelper::makeDataForTree($inArray, &$tree_data_ins_parent,$deps['id']);
//unset($inArray);
$this->assignRef('Itemid', JFactory::getApplication()->input->get('Itemid'));
$this->assignRef('deps', $deps);
$this->assignRef('tree_data_ins_cap', json_encode($tree_data_ins_cap));
$this->assignRef('tree_data_ins_level', json_encode($tree_data_ins_level));
$this->assignRef('tree_data_ins_goichucvu', json_encode($tree_data_ins_goichucvu));
$this->assignRef('tree_data_ins_goiluong', json_encode($tree_data_ins_goiluong));
$this->assignRef('tree_data_ins_linhvuc', json_encode($tree_data_ins_linhvuc));
$this->assignRef('tree_data_ins_loaihinh', json_encode($tree_data_ins_loaihinh));
$this->assignRef('tree_data_ins_dept', json_encode($tree_data_ins_dept));
// $model = JModelLegacy::getInstance('Tochuc','TochucModel');
$model = Core::model('Tochuc/Tochuc');
$dept_id = JRequest::getInt('id', 0);
$row = $model->read($dept_id);
$vanban_created = $model->getVanbanById($row->vanban_created);
$trangthai = $model->getVanbanById($row->vanban_active);
$file_created = $model->getFilebyIdVanban($row->vanban_created);
$file_trangthai = $model->getFilebyIdVanban($row->vanban_active);
$this->assignRef('row', $row);
$this->assignRef('vanban_created', $vanban_created);
$this->assignRef('trangthai', $trangthai);
$this->assignRef('file_created', $file_created);
$this->assignRef('file_trangthai', $file_trangthai);
unset($tree_data_ins_loaihinh);
unset($tree_data_ins_cap);
unset($tree_data_ins_level);
unset($tree_data_ins_goichucvu);
unset($tree_data_ins_goiluong);
unset($tree_data_ins_linhvuc);
unset($tree_data_ins_parent);
unset($tree_data_ins_dept);
unset($row);
unset($vanban_created);
unset($file_created);
unset($trangthai);
unset($file_trangthai);
}
