static function getDepartmentRows()
{
$table = self::_table("org_department");
$table_position = self::_table("org_position");
$sql = "select dep_id as `key`,dep_name,dep_pid as pid,dep_name as label,concat('d_',dep_id) as value from {$table}";
$rows = self::_db()->select_rows($sql);
if (empty($rows)) {
$row = array("dep_name" => "部门", "dep_pid" => 0);
self::_db()->insert($table, $row);
$rows = self::_db()->select_rows($sql);
}
$departments_rows = array();
$departments_pid_rows = array();
$positions = self::_db()->rows("select p.* from {$table_position} as p left join {$table} as d on d.dep_id = p.dep_id");
$_positions = array();
foreach ($positions as $position) {
$_positions[$position['dep_id']][] = $position;
}
foreach ($rows as &$row) {
$departments_rows[$row['key']] = $row['dep_name'];
$departments_pid_rows[$row['key']] = $row['pid'];
if (!empty($_positions[$row['key']])) {
$row['positions'] = $_positions[$row['key']];
}
}
$res = array("rows" => Utils::list_to_tree($rows, "key", "pid", "children"), "departments_rows" => $departments_rows, "departments_pid_rows" => $departments_pid_rows, "positions" => $_positions);
return $res;
}
static function getRows()
{
$pk = self::pk();
$table = self::table();
$sql = "select {$pk} as `key`,cat_name,cat_pid as pid,cat_name as label,concat('d_',{$pk}) as value from {$table}";
$rows = self::_db()->select_rows($sql);
if (empty($rows)) {
$row = array("cat_name" => "商品分类", "cat_pid" => 0);
self::_db()->insert($table, $row);
$rows = self::_db()->select_rows($sql);
}
$rows_key_name = array();
$rows_key_pid = array();
foreach ($rows as &$row) {
$rows_key_name[$row['key']] = $row['cat_name'];
$rows_key_pid[$row['key']] = $row['pid'];
}
$res = array("rows" => Utils::list_to_tree($rows, "key", "pid", "children"), "rows_key_name" => $rows_key_name, "rows_key_pid" => $rows_key_pid);
return $res;
}
