';
if (is_array($v['update'])) {
$result[$k] = '
';
}
} elseif (!$col && isset($v['class'])) {
# 分割线
$v['name'] = $this->value($v['name'], array('test' => 1));
if (isset($v['right'])) {
$this->card_right = true;
}
$this->card = true;
$result[$k] = Html::hr($v);
}
}
if (Dever::input('ajax') == 1) {
return implode('', $result);
}
return $result;
}
public function card()
{
if (isset($this->card_right)) {
return 'layui-col-md6';
}
return 'layui-col-md12';
}
public function layui_card()
{
if (isset($this->card)) {
return false;
}
return true;
}
/**
* update_class
*
* @return string
*/
public function update_class($name, $param, $prefix = '', $data = array())
{
$class = '';
$key = 'show';
if (isset($param[$key]) && $param[$key]) {
$parent = array();
$child = array();
if (is_string($param[$key])) {
parse_str($param[$key], $param[$key]);
}
if (is_array($param[$key])) {
foreach ($param[$key] as $k => $v) {
if ($k == 'no') {
$child[$k . '_' . $v] = $key . '_no';
} elseif (strstr($v, '/')) {
$parent[$k] = $key . '_' . $k;
$k = $k . '_ajax';
$value = '';
if (isset($data[$name])) {
$value = $data[$name];
}
$v = str_replace('?', '?key='.$name.'&value='.$value.'&source='.$this->name.'&', $v);
$child[$k] = $key . '_' . $k .'" dever-ajax="'.Dever::url($v).'"';
} else {
if (strpos($v, ',')) {
$temp = explode(',', $v);
foreach ($temp as $v1) {
$show = $k . '_' . $v1;
if ($prefix) {
$k = str_replace($name, $k, $prefix);
$show = str_replace($name, $show, $prefix);
}
$parent[$k] = $key . '_' . $k;
$child[$show] = $key . '_' . $show;
}
} else {
$show = $k . '_' . $v;
if ($prefix) {
$k = str_replace($name, $k, $prefix);
$show = str_replace($name, $show, $prefix);
}
$parent[$k] = $key . '_' . $k;
$child[$show] = $key . '_' . $show;
}
}
}
}
$class = implode(' ', $parent) . ' ' . implode(' ', $child);
}
if (isset($param['control'])) {
$class .= ' ' . $key . '_input';
}
if (isset($param['control_url'])) {
$class .= ' control_url';
}
return $class;
}
/**
* update_html
*
* @return string
*/
public function create_update_html($key, $value, $data = array(), $index = false, $prefix = '')
{
$result = '';
$this->update_key($key, $value);
$value['ext'] = $value['col'] = $key;
$value['update'] = $value['update'] ? $value['update'] : 'text';
if (is_string($value['update']) && strpos($value['update'], 'copy.') !== false) {
$value['value'] = $value['update'];
$value['update'] = 'hidden';
}
if (!$index) {
$index = $key;
}
$this->update_html($value, $key, $index, $data, $result, $prefix);
return $result;
}
private function update_key(&$key, &$value)
{
$value['source_key'] = $key;
if (strstr($key, '/')) {
if (strstr($key, '-')) {
$temp = explode('-', $key);
$value['api'] = $temp[0];
$value['method'] = $temp[1];
} else {
$value['api'] = $key;
}
$key = str_replace('/', '--', $key);
}
}
/**
* update_html
*
* @return string
*/
public function update_html($param, $key, $index, $data, &$result, $prefix = '', $ext = 'update')
{
if (isset($param['match']) && $param['match'] != 'option') {
if (is_string($param['match']) && strpos($param['match'], '/') !== false) {
if (strstr($param['match'], 'option||')) {
$param['valid'] = 'validate[custom[' . $key . ']]';
} else {
$param['valid'] = 'validate[required,custom[' . $key . ']]';
}
} else {
$param['valid'] = 'validate[required]';
}
}
if (isset($param['name']) && $param['name'] && isset($param['update']) && $param['update'] != 'hidden' && $param['update'] != 'load') {
$result .= Html::pageLeft($param);
}
if ($param['update']) {
$order = true;
# 名称带前缀
$param['name'] = $ext . '_' . $param['ext'];
$param['index'] = $index;
//$param['value'] = '';
# 得到当前的值
//if (isset($data[$index]) && !isset($param['value'])) {
if (isset($data[$index])) {
$param['value'] = $data[$index];
}
# 得到下级的值
if (isset($param['child_value']) && isset($data['id'])) {
$param['child_value'] = $this->value($param['child_value'], $data);
}
# 验证option是否是匿名函数
if (isset($param['option'])) {
$param['option'] = $this->option($param['option']);
}
if (isset($data[$index]) && !isset($param['value']) && isset($param['key']) && $param['update'] != 'editor') {
$param['value'] = Dever::upload($data[$index]);
}
# 处理下级字段
if (isset($param['child'])) {
$param['child'] = $this->option($param['child']);
if (isset($data[$key . '_parent'])) {
$param['parent_value'] = $data[$key . '_parent'];
}
}
# 设置默认值
if (isset($param['default'])) {
$param['default'] = $this->option($param['default']);
}
# 处理关联数据 兼容处理，以后删除
if (isset($param['sync']) && isset($param['sync'][0]) && strpos($key, '-') && $param['update'] != 'load') {
$temp = explode('-', $key);
if (isset($data[$param['sync'][0]])) {
if (isset($temp[2])) {
$m = 'one';
} else {
$m = 'select';
}
if ($data[$param['sync'][0]] > 0) {
$load = Dever::load($temp[0] . '/' . $temp[1] . '-' . $m, array('option_' . $param['sync'][1] => $data[$param['sync'][0]], 'orders' => array('id' => 'asc')));
} else {
$load = Dever::load($temp[0] . '/' . $temp[1] . '-' . $m, array('option_' . $param['sync'][3] => $data[$param['sync'][2]], 'option_' . $param['sync'][4] => $data[$param['sync'][0]], 'orders' => array('id' => 'asc')));
}
if ($m == 'one') {
$param['value'] = isset($load[$temp[2]]) ? $load[$temp[2]] : $param['default'];
} else {
$param['value'] = $load;
}
}
if (!isset($temp[2]) && is_array($param['update'])) {
$order = false;
if (isset($param['update'][0]) && is_string($param['update'][0]) && strstr($param['update'][0], '.')) {
if (isset($param['update'][1]) && $param['update'][1]) {
$param['update_load'] = $param['update'][0];
$param['update'] = 'load';
} else {
$param['update'] = Dever::load($param['update'][0]);
}
} else {
$config = Dever::db($temp[0] . '/' . $temp[1])->config;
$param['update'] = $config['struct'];
}
if (isset($config['manage']['tab'])) {
$param['prefix'] = $prefix;
$param['tab_config'] = $config['manage']['tab'];
if (isset($config['manage']['lang'])) {
$param['lang'] = $config['manage']['lang'];
}
}
//$param['value'] = Dever::db($temp[0] . '/' . $temp[1]);
}
} elseif (isset($param['sync']) && isset($param['api']) && $param['update'] != 'load') {
$param['sync']['dever-read'] = $data;
if (is_array($param['update'])) {
$param['value'] = Dever::load($param['api'], $param['sync']);
$order = false;
if (isset($param['update'][0]) && is_string($param['update'][0]) && strstr($param['update'][0], '.')) {
if (isset($param['update'][1]) && $param['update'][1]) {
$param['update_load'] = $param['update'][0];
$param['update'] = 'load';
} else {
$param['update'] = Dever::load($param['update'][0]);
}
} else {
$config = Dever::db($param['api'])->config;
$param['update'] = $config['struct'];
}
if (isset($config['manage']['tab'])) {
$param['prefix'] = $prefix;
$param['tab_config'] = $config['manage']['tab'];
if (isset($config['manage']['lang'])) {
$param['lang'] = $config['manage']['lang'];
}
}
} elseif (strstr($param['api'], '.')) {
$param['value'] = Dever::load($param['api'], $param['sync']);
} elseif (isset($param['method'])) {
$param['value'] = Dever::load($param['api'] . '-' . $param['method'], $param['sync']);
}
}
$method = $param['update'];
if (is_array($method)) {
$c = '';
if (layadmin()) {
$c = 'layui-tab-title';
}
$delete = true;
if (isset($param['update_type']) && $param['update_type'] == 2) {
$table = '';
$table .= '
';
$table_header = '';
$table_body = '
';
$table_key = '';
if (isset($param['option'])) {
$param['value'] = $param['value'] + $param['option'];
$table_key = '1';
if (isset($param['value']) && $param['value']) {
$table_body .= '';
$table_up = 'dever_up';
} else {
$table_body .= '
';
$table_up = 'update';
}
} else {
$table_body .= '
';
$table_key = '-1';
$table_up = 'dever_up';
}
if ($table_key) {
foreach ($param['update'] as $hk => $hv) {
if (isset($hv['col'])) {
$hk = $hv['col'];
}
$this->update_key($hk, $hv);
if ($this->id && $hk === 'id') {
$hv['update'] = 'hidden';
}
if (isset($hv['update']) && $hv['update'] && (!isset($hv['tab']) || (isset($hv['tab']) && $hv['tab'] <= 0))) {
$n = $hv['name'];
unset($hv['name']);
$s = '';
$hv['ext'] = $param['name'] . '_c_'.$table_key.'_i_' . $hk;
if ($hv['update'] == 'linkage') {
$hv['update_width'] = '30%';
}
$this->update_html($hv, $hk, $hk, array(), $s, '', $table_up);
if ($hv['update'] == 'hidden') {
$table_header .= '| '.$n.' | ';
$table_body .= ''.$s.' | ';
} else {
$table_header .= ''.$n.' | ';
$table_body .= ''.$s.' | ';
}
}
}
if ($table_key == '-1') {
$table_header .= '操作 | ';
$table_body .= '删除 | ';
}
$table_body .= '
';
}
$total = array();
if (isset($param['value']) && $param['value']) {
if (!is_array($param['value'])) {
$param['value'] = Dever::json_decode($param['value']);
}
foreach ($param['value'] as $bk => $bv) {
$table_body .= '';
foreach ($param['update'] as $hk => $hv) {
if (isset($hv['col'])) {
$hk = $hv['col'];
}
$this->update_key($hk, $hv);
if ($this->id && $hk === 'id') {
$hv['update'] = 'hidden';
}
if (isset($hv['update']) && $hv['update'] && (!isset($hv['tab']) || (isset($hv['tab']) && $hv['tab'] <= 0))) {
unset($hv['name']);
$s = '';
$hv['ext'] = $param['name'] . '_c_' . $bk . '_i_' . $hk;
if ($hv['update'] == 'linkage') {
$hv['update_width'] = '30%';
}
$hv = $this->update_html($hv, $hk, $hk, $bv, $s);
if (isset($param['update_show']) && $param['update_show'] && is_array($param['update_show'])) {
if (isset($param['update_show'][$hv['source_key']])) {
if (!isset($total[$hv['source_key']])) {
$total[$hv['source_key']] = array($hv['desc'], $param['update_show'][$hv['source_key']], 0);
}
$total[$hv['source_key']][2] += $hv['value'];
}
}
if ($hv['update'] == 'hidden') {
$table_body .= '| '.$s.' | ';
} else {
$table_body .= ''.$s.' | ';
}
}
}
if ($table_key == '-1') {
if (isset($param['api'])) {
$del_table = $param['api'];
$del_id = Dever::encode($bv['id']);
$table_body .= '删除 | ';
} else {
$table_body .= '删除 | ';
}
}
$table_body .= '
';
}
} else {
if (isset($param['update_show']) && $param['update_show'] && is_array($param['update_show'])) {
foreach ($param['update_show'] as $uk => $uv) {
if (isset($param['update'][$uk])) {
if (!isset($total[$uk])) {
$total[$uk] = array($param['update'][$uk]['desc'], $uv, 0);
}
}
}
}
}
$table_body .= '';
$table_header .= '';
$table .= $table_body . $table_header;
$table .= '
';
$result .= $table;
if ($total) {
$result .= '
';
foreach ($total as $k => $v) {
$result .= ''.$v[0].'：'.$v[2].' ';
}
$result .= '';
}
} elseif (isset($param['update_type']) && $param['update_type'] == 3) {
$table = '';
$table .= '
';
$table_header = '';
$table_body = '
';
$table_body .= '';
foreach ($param['update'] as $hk => $hv) {
if (isset($hv['col'])) {
$hk = $hv['col'];
}
$this->update_key($hk, $hv);
if ($this->id && $hk === 'id') {
$hv['update'] = 'hidden';
}
if (isset($hv['update']) && $hv['update'] && (!isset($hv['tab']) || (isset($hv['tab']) && $hv['tab'] <= 0))) {
$n = $hv['name'];
unset($hv['name']);
$s = '';
$hv['ext'] = $param['name'] . '_c_-1_i_' . $hk;
if ($hv['update'] == 'linkage') {
$hv['update_width'] = '30%';
}
$this->update_html($hv, $hk, $hk, array(), $s, '', 'dever_up');
if ($hv['update'] == 'hidden') {
$table_header .= '| '.$n.' | ';
$table_body .= ''.$s.' | ';
} else {
$table_header .= ''.$n.' | ';
$table_body .= ''.$s.' | ';
}
}
}
$table_body .= '
';
if (isset($param['value']) && $param['value']) {
if (!is_array($param['value'])) {
$param['value'] = Dever::json_decode($param['value']);
}
foreach ($param['value'] as $bk => $bv) {
$table_body .= '';
foreach ($param['update'] as $hk => $hv) {
if (isset($hv['col'])) {
$hk = $hv['col'];
}
$this->update_key($hk, $hv);
if ($this->id && $hk === 'id') {
$hv['update'] = 'hidden';
}
if (isset($hv['update']) && $hv['update'] && (!isset($hv['tab']) || (isset($hv['tab']) && $hv['tab'] <= 0))) {
unset($hv['name']);
$s = '';
$hv['ext'] = $param['name'] . '_c_' . $bk . '_i_' . $hk;
if ($hv['update'] == 'linkage') {
$hv['update_width'] = '30%';
}
if ($hv['update'] != 'hidden') {
$hv['update_type'] = $hv['update'];
$hv['update'] = 'show';
}
$this->update_html($hv, $hk, $hk, $bv, $s);
if ($hv['update'] == 'hidden') {
$table_body .= '| '.$s.' | ';
} else {
$table_body .= ''.$s.' | ';
}
}
}
$table_body .= '
';
}
}
$table_body .= '';
$table_header .= '';
$table .= $table_body . $table_header;
$table .= '
';
$result .= $table;
} else {
if (isset($param['option'])) {
$delete = false;
$result .= '
';
$order = array
(
'col' => $key,
'name' => $param['desc'],
'default' => '1',
'desc' => $param['desc'],
'match' => 'is_string',
'update' => 'hidden',
'option' => $param['option']
);
array_unshift($method, $order);
if (isset($param['value']) && $param['value']) {
$value = $param['value'];
if (!is_array($value)) {
$value = Dever::json_decode($value);
}
$param['value'] = array();
if (!$value) {
foreach ($param['option'] as $k => $v) {
if (isset($v['name'])) {
$v = $v['name'];
}
$param['value'][$v]['main_' . $key] = $k;
}
} else {
foreach ($param['option'] as $k => $v) {
if (isset($v['name'])) {
$v = $v['name'];
}
foreach ($value[$k] as $k1 => $v1) {
$param['value'][$v][$k1] = $v1;
}
/*
foreach ($value[$k-1] as $k1 => $v1) {
$param['value'][$v][$k1] = $v1;
}*/
}
}
} else {
$param['value'] = array();
foreach ($param['option'] as $k => $v) {
if (isset($v['name'])) {
$v = $v['name'];
}
$param['value'][$v]['main_' . $key] = $k;
}
}
} else {
$result .= '
';
if ($order) {
$order = array
(
'col' => 'order',
'name' => '排序-按照数字正序排列',
'default' => '1',
'desc' => '排序',
'match' => 'is_string',
'update' => 'text',
);
array_unshift($method, $order);
}
}
$tab = '';
$this->update_child(array(), $method, $key, $result, -1, $param, $delete);
if (isset($param['value']) && $param['value']) {
if (!is_array($param['value'])) {
$param['value'] = Dever::array_decode($param['value']);
}
//print_r($param['value']);die;
if (is_array($param['value'])) {
$i = 0;
foreach ($param['value'] as $k => $v) {
$n = $k;
if (is_string($k)) {
$k = $i;
}
$this->update_child($v, $method, $key, $result, $k, $param, $delete);
$active = '';
if ($k == 0) {
$active = 'active';
}
if (layadmin() && $active) {
$active .= ' layui-this';
}
$k = $k + 1;
if (!is_string($n)) {
$n = '第' . $k . '条';
}
if (isset($param['option']) && count($param['option']) <= 1) {
} else {
$tab .= '
'.$n.'';
$i++;
}
}
}
} else {
$this->update_child(array(), $method, $key, $result, 0, $param, $delete);
$tab = '
第1条';
}
if ($tab) {
$result = str_replace('{tab}', $tab, $result);
} else {
$result = str_replace('
', '', $result);
}
}
} else {
if (isset($param['update_input']) && isset($data[$index . '_input'])) {
$param['update_input_data'] = explode(',', $data[$index . '_input']);
}
$param['project'] = $this->project;
$param['table'] = $this->table;
if (isset($param['upload_search'])) {
$param['upload_search'] = $this->value($param['upload_search'], $data + $param);
}
if (isset($param['upload_search_value'])) {
$param['upload_search_value'] = $this->value($param['upload_search_value'], $data + $param);
}
if (isset($param['update_search_value'])) {
$param['update_search_value'] = $this->value($param['update_search_value'], $data + $param);
}
$param['where_id'] = $this->id;
$result .= Html::$method($param);
}
if (isset($param['desc']) && ($param['update'] == 'text' || $param['update'] == 'password')) {
$result .= Html::desc($param['desc']);
}
}
return $param;
}
/**
* update_action
*
* @return array
*/
private function update_child($data, $param, $key, &$result, $index, $config, $delete = true)
{
if (isset($config['tab_config']) && $config['tab_config']) {
if ($index != 0) {
$style = 'display:none;';
} else {
$style = '';
}
$result .= '
';
} else {
$style = 'margin:10px;';
if ($index != 0) {
$style = 'display:none;margin:10px;';
}
$result .= '
';
}
}
private function update_child_data($data, $param, $key, $index, $tab = -1, $config = array())
{
$result = '';
foreach ($param as $k => $v) {
if (is_string($k)) {
$v['col'] = $k;
}
if ($this->id && $v['col'] == 'id') {
$v['update'] = 'hidden';
}
if (!isset($v['update'])) {
continue;
}
if (isset($config['prefix']) && $config['prefix']) {
if (isset($config['lang']) && $config['lang'] && !in_array($v['col'], $config['lang'])) {
continue;
}
$v['col'] = $config['prefix'] . '_' . $v['col'];
}
$state = false;
if ($tab == 0) {
if (!isset($v['tab']) || (isset($v['tab']) && $v['tab'] == $tab)) {
$state = true;
}
} elseif ($tab > 0) {
if (isset($v['tab']) && $v['tab'] == $tab) {
$state = true;
}
} else {
$state = true;
}
if (isset($v['update']) && $v['update'] && $state) {
$v['type'] = $v['update'];
$prefix = '';
if ($index < 0) {
$v['ext'] = $key . '_c_' . $v['col'];
$prefix = $v['ext'];
} else {
$v['ext'] = $key . '_c_' . $index . '_i_' . $v['col'];
$prefix = $v['ext'];
}
if ($v['col'] == 'order') {
$v['default'] = $index+1;
}
$class = $this->update_class($v['col'], $v, $prefix);
if ($v['update'] == 'hidden') {
$result .= '
';
$this->update_html($v, $key, $v['col'], $data, $result);
$result .= '
';
} else {
$result .= '
';
$this->update_html($v, $key, $v['col'], $data, $result);
$result .= '
';
}
}
}
return $result;
}
/**
* update_action
*
* @return array
*/
public function update_action_commit_api()
{
$key = Dever::input('dever_submit_key');
$col = Dever::input('col');
$value = Dever::input('value');
if ($key) {
Dever::submit_check($key, false, true);
}
$method = false;
$config = $this->config();
$input = Dever::preInput('update_');
$info = array();
if ($this->id) {
# 新增权限
if (isset($config['manage']['list']) && $config['manage']['list'] == 'update') {
$auth = 1;
} else {
$auth = 3;
}
if (Dever::load('manage/auth.oper', $auth) == false) {
Dever::alert('你没有权限');
}
Dever::setInput('where_id', $this->id);
//Dever::setInput('update_where_id', $this->id);
$info = $this->load('one', $this->id);
if ($info) {
$method = 'update';
if ($col && $value) {
$method = 'update_' . $col;
//Dever::setInput('set_' . $col, $value);
//Dever::setInput('update_' . $col, $value);
$param['where_id'] = $this->id;
$param['set_' . $col] = $value;
$this->load($method, $param);
$struct = $this->struct_data($config['struct'], array($col => $value));
Log::add($this->project, $this->table, $this->menu_id, '', $method, $struct, $this->id);
Dever::out('yes');
return;
}
$prefix = 'set';
} else {
$method = 'insert';
$prefix = 'add';
}
}
if (!$method) {
# 新增权限
if (isset($config['manage']['list']) && $config['manage']['list'] == 'update') {
$auth = 1;
} else {
$auth = 4;
}
if (Dever::load('manage/auth.oper', $auth) == false) {
Dever::alert('你没有权限');
}
$method = 'insert';
$prefix = 'add';
}
if ($method && $input) {
$update = $order = $update_other = array();
$i = 0;
$c = array();
foreach ($input as $k => $v) {
if ($v === '') {
$v = 'null';
}
if ($v && is_string($v) && strpos($v, 'copy.') !== false) {
$temp = str_replace('copy.', '', $v);
if (isset($input['update_' . $temp])) {
$v = $input['update_' . $temp];
}
}
if (strpos($k, '_c_') !== false) {
if (strstr($k, 'update_update_')) {
$k = str_replace('update_update_', 'update_', $k);
}
if ($v == 'null') {
$v = '';
}
$temp = explode('_c_', $k);
$h = $temp[0];
$k = str_replace('update_', $prefix . '_', $h);
if (!isset($c[$k])) {
$c[$k] = array();
}
if (strpos($temp[1], '_i_') !== false) {
$temp = explode('_i_', $temp[1]);
if (!isset($c[$k][$temp[1]])) {
$c[$k][$temp[1]] = 0;
} else {
$c[$k][$temp[1]]++;
}
$num = $c[$k][$temp[1]];
if (strpos($h, '-')) {
$h = str_replace('update_', '', $h);
$h = str_replace('--', '/', $h);
# 兼容处理 之后删除
if (isset($config['struct'][$h]) && isset($config['struct'][$h]['sync']) && isset($config['struct'][$h]['sync'][0])) {
$s_col = $config['struct'][$h]['sync'][0];
$m_col = $config['struct'][$h]['sync'][1];
if ($s_col == 'id') {
$s_value = $this->id;
} elseif (isset($info[$s_col])) {
$s_value = $info[$s_col];
} else {
$s_value = $input['update_' . $s_col];
}
$t = explode('-', $h);
$index = $t[0] . '/' . $t[1];
if (Dever::zero($v)) {
$v = (string) $v;
} elseif (!$v) {
$v = 'null';
}
$update_col[$i][$index] = $m_col;
$update_set[$i][$index][$num]['set_' . $temp[1]] = $v;
$update_add[$i][$index][$num]['add_' . $temp[1]] = $v;
$update_add[$i][$index][$num]['add_' . $m_col] = $s_value;
$update_deletes[$i][$index][$m_col] = $s_value;
$update_id[$i][$index][$num][$m_col] = $s_value;
if ($this->id && $temp[1] == 'id') {
$update_id[$i][$index][$num]['id'] = $v;
}
} elseif (isset($config['struct'][$h]) && isset($config['struct'][$h]['sync'])) {
$t = explode('-', $h);
$index = $t[0];
if (Dever::zero($v)) {
$v = (string) $v;
} elseif (!$v) {
$v = 'null';
}
$update_set[$i][$index][$num]['set_' . $temp[1]] = $v;
$update_add[$i][$index][$num]['add_' . $temp[1]] = $v;
if ($this->id && $temp[1] == 'id') {
$update_id[$i][$index][$num]['id'] = $v;
}
foreach ($config['struct'][$h]['sync'] as $ks => $vs) {
if ($vs == 'id') {
$vs = $this->id;
$update_col[$i][$index] = $ks;
} elseif (isset($info[$vs])) {
$vs = $info[$vs];
} elseif (isset($input['update_' . $vs])) {
$vs = $input['update_' . $vs];
}
$update_add[$i][$index][$num]['add_' . $ks] = $vs;
$update_deletes[$i][$index][$ks] = $vs;
$update_id[$i][$index][$num][$ks] = $vs;
}
}
} else {
$update[$i][$k][$num][$temp[1]] = $v;
if ($temp[1] == 'order') {
$order[$i][$k][$num] = $v;
}
}
} else {
//$update[$i][$k][$c][$temp[1]] = $v;
}
} elseif (strpos($k, '__') !== false) {
$temp1 = explode('__', $k);
$temp2 = explode('_', $temp1[0]);
$i = $temp2[1] - 1;
if (strpos($k, 'where_id') !== false) {
//$update[$i]['where_id'] = $v;
} else {
$update[$i]['add_' . $temp1[1]] = $v;
}
} else {
$ki = str_replace('update_', $prefix . '_', $k);
if (strpos($ki, 'where_id') !== false) {
if ($method != 'insert') {
$update[$i]['where_id'] = $v;
}
} else {
if (strpos($k, 'l-l')) {
$temp = explode('l-l', $k);
$k = str_replace('_', '', $temp[2]);
$update_other[$i][$temp[1]][$k] = $v;
} elseif (strpos($k, '-') && isset($config['struct'][$k]['sync'][0])) {
# 兼容处理，之后删除
$k = str_replace('update_', '', $k);
if (isset($config['struct'][$k]) && isset($config['struct'][$k]['sync'])) {
$s_col = $config['struct'][$k]['sync'][0];
$m_col = $config['struct'][$k]['sync'][1];
if ($s_col == 'id') {
$s_value = $this->id;
} elseif (isset($info[$s_col])) {
$s_value = $info[$s_col];
} else {
$s_value = $input['update_' . $s_col];
}
$temp = explode('-', $k);
$index = $temp[0] . '/' . $temp[1];
if (isset($temp[2])) {
$update_col[$i][$index] = $m_col;
$update_set[$i][$index][0]['set_' . $temp[2]] = $v;
//$update_set[$i][$index][0]['set_' . $m_col] = $s_value;
$update_add[$i][$index][0]['add_' . $temp[2]] = $v;
$update_add[$i][$index][0]['add_' . $m_col] = $s_value;
$update_id[$i][$index][0][$m_col] = $s_value;
}
} else {
$temp = explode('-', $k);
if (isset($temp[2])) {
$k = $temp[0] . '-' . $temp[1];
if (isset($config['struct'][$k]) && isset($config['struct'][$k]['sync'])) {
$s_col = $config['struct'][$k]['sync'][0];
$m_col = $config['struct'][$k]['sync'][1];
if ($s_col == 'id') {
$s_value = $this->id;
} elseif (isset($info[$s_col])) {
$s_value = $info[$s_col];
} else {
$s_value = $input['update_' . $s_col];
}
$index = $temp[0] . '/' . $temp[1];
$temp[2] = ltrim($temp[2], '_');
$temp = explode('_', $temp[2]);
$update_col[$i][$index] = $m_col;
$up = array();
$up['add_' . $temp[0] . '_id'] = $temp[1];
$up['add_' . $temp[0] . '_value'] = $v;
$up['add_' . $m_col] = $s_value;
$update_add[$i][$index][] = $up;
$update_delete[$i][$index][][$m_col] = $s_value;
}
}
}
} elseif (strpos($k, '#')) {
$k = str_replace('update_', '', $k);
$k = str_replace('--', '/', $k);
# 此处需要改造 ---
if (isset($config['struct'][$k]) && isset($config['struct'][$k]['sync'])) {
$temp = explode('-', $k);
$index = $temp[0];
$temp = explode('#', $temp[1]);
$c_col = $temp[1];
$update_set[$i][$index][0]['set_' . $c_col] = $v;
$update_add[$i][$index][0]['add_' . $c_col] = $v;
foreach ($config['struct'][$k]['sync'] as $ks => $vs) {
if ($vs == 'id') {
$vs = $this->id;
$update_col[$i][$index] = $ks;
} elseif (isset($info[$vs])) {
$vs = $info[$vs];
} elseif (isset($input['update_' . $vs])) {
$vs = $input['update_' . $vs];
}
$update_add[$i][$index][0]['add_' . $ks] = $vs;
$update_id[$i][$index][0][$ks] = $vs;
}
} else {
$temp = explode('-', $k);
$k = $index = $temp[0];
$temp = explode('#', $temp[1]);
$c_col = $temp[1];
if (isset($config['struct'][$k]) && isset($config['struct'][$k]['sync'])) {
$c_col = ltrim($c_col, '_');
$temp = explode('_', $c_col);
$up = array();
$up['add_' . $temp[0] . '_id'] = $temp[1];
$up['add_' . $temp[0] . '_value'] = $v;
foreach ($config['struct'][$k]['sync'] as $ks => $vs) {
if ($vs == 'id') {
$vs = $this->id;
$update_col[$i][$index] = $ks;
} elseif (isset($info[$vs])) {
$vs = $info[$vs];
} elseif (isset($input['update_' . $vs])) {
$vs = $input['update_' . $vs];
}
$up['add_' . $ks] = $vs;
$update_delete[$i][$index][][$ks] = $vs;
}
$update_add[$i][$index][] = $up;
}
}
} else {
if (is_array($v)) {
$k = str_replace('update_', '', $k);
$kd = $k . '_id';
if (isset($config['struct'][$kd])) {
foreach ($v as $vk => $vt) {
if ($vt == -1) {
if ($vk != 0) {
unset($v[$vk]);
}
}
}
if ($v) {
$vd = end($v);
$kdi = $prefix . '_' . $kd;
$update[$i][$kdi] = $vd;
}
}
if (isset($config['struct'][$k]) && strpos($config['struct'][$k]['type'], 'int') !== false) {
$v = end($v);
}
}
$update[$i][$ki] = $v;
}
}
}
}
//print_r($update_col);
//print_r($update_set);
//print_r($update_id);
//print_r($update_add);die;
//print_r($input);
//print_r($update_other);die;
//print_r($config['struct']);die;
$this->checkSpec($config);
# 增加复制的数量
$copy_num = Dever::input('copy_num');
if ($copy_num > 0) {
$update[0]['where_id'] = 0;
for ($i = 1; $i < $copy_num; $i++) {
$update[$i] = $update[0];
# 缓存处理
$update[$i]['rank'] = $i;
}
}
if ($this->id && !$info) {
$update[0]['add_id'] = $this->id;
}
//print_r($update);die;
$fast = Dever::input('fast');
foreach ($update as $k => $v) {
$method = 'insert';
$old = array();
if (isset($v['where_id']) && $v['where_id']) {
$method = 'update';
$old = $this->load('one', $v['where_id']);
}
if ($method == 'insert' && isset($config['manage']['insert_check'])) {
$insert_check = explode(',', $config['manage']['insert_check']);
foreach ($insert_check as $k1 => $v1) {
if (strstr($v1, '-')) {
$t = explode('-', $v1);
$v1 = $t[0] . '/' . $t[1];
}
if (isset($config['struct'][$v1])) {
if (strstr($v1, '/') && !isset($update_id[$k][$v1])) {
Dever::alert($config['struct'][$v1]['name'] . '不能为空');
} elseif (isset($v['add_' . $v1]) && is_string($v['add_' . $v1]) && (!$v['add_' . $v1] || $v['add_' . $v1] == 'null')) {
Dever::alert($config['struct'][$v1]['name'] . '不能为空');
}
}
}
}
if ($method == 'update' && isset($config['manage']['update_check'])) {
$update_check = explode(',', $config['manage']['update_check']);
foreach ($update_check as $k1 => $v1) {
if (strstr($v1, '-')) {
$t = explode('-', $v1);
$v1 = $t[0] . '/' . $t[1];
}
if (isset($config['struct'][$v1])) {
if (strstr($v1, '/') && !isset($update_id[$k][$v1])) {
Dever::alert($config['struct'][$v1]['name'] . '不能为空');
} elseif (isset($v['set_' . $v1]) && is_string($v['set_' . $v1]) && (!$v['set_' . $v1] || $v['set_' . $v1] == 'null')) {
Dever::alert($config['struct'][$v1]['name'] . '不能为空');
}
}
}
}
if (isset($order[$k])) {
foreach ($order[$k] as $i => $j) {
array_multisort($j, SORT_ASC, $v[$i]);
}
}
if (isset($v['set_password']) && (!$v['set_password'] || $v['set_password'] == 'null')) {
unset($v['set_password']);
}
$id = $this->load($method, $v);
if ($id) {
$struct = $this->struct_data($config['struct'], $v, $old);
Log::add($this->project, $this->table, $this->menu_id, '', $method, $struct, $id ? $id : $this->id);
if ($update_other && isset($update_other[$k])) {
foreach ($update_other[$k] as $k1 => $v1) {
$v1['id'] = $id;
$this->load($method, $v1, $this->table . '__' . $k1);
}
}
if (isset($update_add[$k]) && $update_add[$k]) {
if (isset($update_deletes[$k]) && $update_deletes[$k]) {
foreach ($update_deletes[$k] as $k1 => $v1) {
$v1['set_state'] = 2;
Dever::load($k1 . '-updates', $v1);
}
}
foreach ($update_add[$k] as $k1 => $v1) {
$col = isset($update_col[$k][$k1]) ? $update_col[$k][$k1] : false;
foreach ($v1 as $k2 => $v2) {
if ($col) {
if (isset($update_set[$k][$k1][$k2]['set_' . $col])) {
$update_set[$k][$k1][$k2]['set_' . $col] = $id;
}
if (isset($v2['add_' . $col])) {
$v2['add_' . $col] = $id;
}
}
$check = false;
if (isset($update_id[$k][$k1][$k2])) {
if ($col && isset($update_id[$k][$k1][$k2][$col])) {
$update_id[$k][$k1][$k2][$col] = $id;
}
$check = Dever::load($k1 . '-one', $update_id[$k][$k1][$k2]);
} elseif (isset($update_delete[$k][$k1][$k2])) {
# 清理
Dever::load($k1 . '-delete', $update_delete[$k][$k1][$k2]);
}
if ($check) {
unset($update_set[$k][$k1][$k2]['set_id']);
$update_set[$k][$k1][$k2]['where_id'] = $check['id'];
$update_set[$k][$k1][$k2]['set_state'] = 1;
Dever::load($k1 . '-update', $update_set[$k][$k1][$k2]);
} else {
Dever::load($k1 . '-insert', $v2);
}
}
}
}
$this->spec($id, $config);
if ($method == 'insert' && isset($config['manage']['insert_end'])) {
Dever::load($config['manage']['insert_end'], $id);
}
if ($method == 'update' && isset($config['manage']['update_end'])) {
Dever::load($config['manage']['update_end'], $id);
}
}
}
}
Dever::out('yes');
}
private function checkSpec($config)
{
$type = Dever::input('update_type');
if ($type && isset($type[0]) && $type[0] > 10) {
//Dever::setInput('update_spec_type', -1);
return;
}
$spec_type = Dever::input('update_spec_type');
if ($spec_type == 1) {
$sku = Dever::input('skus');
if (!isset($sku[-1])) {
Dever::alert('规格设置不能为空');
}
if (!$sku[-1]['code']) {
Dever::alert('规格设置不能为空');
}
} elseif ($spec_type == 2) {
$spec = Dever::input('spec');
if (!$spec) {
Dever::alert('规格设置不能为空');
}
}
}
private function spec($id, $config)
{
$spec_type = Dever::input('update_spec_type');
if ($spec_type && $spec_type > 0) {
if (isset($config['manage']['sku'])) {
$spec_table = $config['manage']['sku']['spec'];
$sku_table = $config['manage']['sku']['sku'];
}
if (!isset($sku_table)) {
$sku_table = 'info_sku';
}
$sku_table = $this->project . '/' . $sku_table;
if ($spec_type == 2) {
$spec = Dever::input('spec');
$sku = Dever::input('skus');
if ($spec && $sku) {
if (!isset($spec_table)) {
$spec_table = 'info_spec';
}
$spec_table = $this->project . '/' . $spec_table;
$spec_value_table = $spec_table . '_value';
$spec = Dever::json_decode($spec);
if ($spec) {
$sku_id = array();
Dever::db($spec_table)->updates(array('option_info_id' => $id, 'set_state' => 2));
Dever::db($spec_value_table)->updates(array('option_info_id' => $id, 'set_state' => 2));
foreach ($spec as $k1 => $v1) {
$order = $k1 + 1;
if (is_numeric($v1['id'])) {
$spec_id = Dever::db($spec_table)->update(array('where_id' => $v1['id'], 'set_state' => 1, 'set_reorder' => $order));
} else {
$spec_id = Dever::db($spec_table)->insert(array('name' => $v1['title'], 'info_id' => $id, 'reorder' => $order));
}
foreach ($v1['child'] as $k2 => $v2) {
$v2['checked'] = $v2['checked'] ? 1 : 2;
if (is_numeric($v2['id'])) {
Dever::db($spec_value_table)->update(array('where_id' => $v2['id'], 'set_state' => 1, 'set_is_checked' => $v2['checked']));
} else {
$sku_id[$v2['id']] = Dever::db($spec_value_table)->insert(array('value' => $v2['title'], 'is_checked' => $v2['checked'], 'info_id' => $id, 'spec_id' => $spec_id));
}
}
}
Dever::db($spec_table)->delete(array('info_id' => $id, 'state' => 2));
Dever::db($spec_value_table)->delete(array('info_id' => $id, 'state' => 2));
$this->sku($id, $sku_table, $sku, $sku_id);
}
}
} else {
$sku = Dever::input('skus');
if ($sku) {
$this->sku($id, $sku_table, $sku);
//Dever::db($spec_table)->delete(array('info_id' => $id));
//Dever::db($spec_value_table)->delete(array('info_id' => $id));
}
}
}
}
private function sku($id, $sku_table, $sku, $sku_id = false)
{
Dever::db($sku_table)->updates(array('option_info_id' => $id, 'set_state' => 2));
foreach ($sku as $k1 => $v1) {
if ($sku_id) {
foreach ($sku_id as $k2 => $v2) {
$k1 = str_replace($k2, $v2, $k1);
}
}
$sku_data = array();
$sku_data['info_id'] = $id;
$sku_data['key'] = $k1;
$sku_info = Dever::db($sku_table)->one($sku_data);
foreach ($v1 as $k3 => $v3) {
$sku_data[$k3] = $v3;
}
if ($sku_info) {
$sku_data['where_id'] = $sku_info['id'];
$sku_data['state'] = 1;
Dever::db($sku_table)->update($sku_data);
} else {
Dever::db($sku_table)->insert($sku_data);
}
}
Dever::db($sku_table)->delete(array('info_id' => $id, 'state' => 2));
}
public function struct_data($struct, $data, $old = array())
{
$log = $tlog = array();
foreach ($struct as $i => $j) {
if (isset($data[$i])) {
$data['cur_value'] = $data[$i];
}
/*
if ($i == 'reorder' || $i == 'id') {
continue;
}
*/
if (isset($j['list_name'])) {
$j['name'] = $j['list_name'];
} elseif (strpos($j['name'], '-')) {
$temp = explode('-', $j['name']);
$j['name'] = $temp[0];
}
if (isset($j['list_table'])) {
$j['list'] = $j['list_table'];
if ($j['list'] == false) {
$data[$i] = false;
}
}
$list = (isset($j['list']) && is_string($j['list']) && $j['list'] != 'table');
$update = true;
if ($old && isset($j['update'])) {
$update = (is_string($j['update']) && $j['update'] != 'linkage');
}
if (isset($data['where_' . $i]) && $data['where_' . $i]) {
$log[$j['name']] = $data['where_' . $i];
} elseif (isset($data['set_' . $i]) && $data['set_' . $i]) {
$log[$j['name']] = $data['set_' . $i];
} elseif (isset($data['add_' . $i]) && $data['add_' . $i]) {
$log[$j['name']] = $data['add_' . $i];
} elseif (isset($data[$i]) && $data[$i]) {
if ($i == 'id') {
$log[$j['name']] = $data[$i];
} else {
$log[$j['name']] = $list ? $this->value($j['list'], $data) : $data[$i];
}
}
if (isset($log[$j['name']])) {
$tlog[$j['name']] = $log[$j['name']];
if (is_array($tlog[$j['name']])) {
if (isset($tlog[$j['name']][0]) && is_array($tlog[$j['name']][0])) {
$tlog[$j['name']] = json_encode($tlog[$j['name']]);
if (isset($old[$i]) && is_array($old[$i])) {
$old[$i] = json_encode($old[$i]);
}
} elseif (isset($tlog[$j['name']][0])) {
$tlog[$j['name']] = implode(',', $tlog[$j['name']]);
if (isset($old[$i]) && is_array($old[$i])) {
$old[$i] = implode(',', $old[$i]);
}
}
} elseif (strpos($log[$j['name']], 'http://wx.qlogo.cn/') !== false || strpos($log[$j['name']], '.jpg') !== false || strpos($log[$j['name']], '.gif') !== false || strpos($log[$j['name']], '.png') !== false) {
$log[$j['name']] = '
';
if (isset($old[$i]) && $old[$i]) {
$old[$i] = Dever::pic($old[$i]);
$old[$i] = '
';
}
} elseif (is_numeric($log[$j['name']]) && (strpos($i, 'time') !== false || strpos($i, 'date') !== false)) {
if (!strstr($log[$j['name']], '-')) {
$log[$j['name']] = date("Y-m-d H:i:s", $log[$j['name']]);
}
if (isset($old[$i]) && $old[$i]) {
$old[$i] = date("Y-m-d H:i:s", $old[$i]);
}
} elseif (is_numeric($log[$j['name']]) && (strpos($i, 'day') !== false)) {
if (!strstr($log[$j['name']], '-')) {
$log[$j['name']] = date("Y-m-d", $log[$j['name']]);
}
if (isset($old[$i]) && $old[$i]) {
$old[$i] = date("Y-m-d", $old[$i]);
}
} elseif (is_numeric($log[$j['name']]) && (strpos($i, 'month') !== false)) {
if (!strstr($log[$j['name']], '-')) {
$log[$j['name']] = date("Y-m", $log[$j['name']]);
}
if (isset($old[$i]) && $old[$i]) {
$old[$i] = date("Y-m", $old[$i]);
}
} elseif (isset($j['decode'])) {
$log[$j['name']] = Dever::array_decode($log[$j['name']]);
if (isset($old[$i]) && $old[$i]) {
$old[$i] = Dever::array_decode($old[$i]);
}
}
if (isset($j['option']) && !$list && $update) {
$name = array();
$old_name = array();
$option = $this->option($j['option']);
if (is_array($option)) {
foreach ($option as $a => $b) {
if (!is_array($log[$j['name']])) {
if ($a == $log[$j['name']]) {
$name[] = (is_array($b) && isset($b['name'])) ? $b['name'] : $b;
}
} elseif (in_array($a, $log[$j['name']])) {
$name[] = (is_array($b) && isset($b['name'])) ? $b['name'] : $b;
}
if ($old && isset($old[$i])) {
if (!is_array($old[$i])) {
if ($a == $old[$i]) {
$old_name[] = (is_array($b) && isset($b['name'])) ? $b['name'] : $b;
}
} elseif (in_array($a, $old[$i])) {
$old_name[] = (is_array($b) && isset($b['name'])) ? $b['name'] : $b;
}
}
}
}
$log[$j['name']] = implode(',', $name);
if ($old_name) {
$old[$i] = implode(',', $old_name);
}
}
if ($log[$j['name']] == 'null') {
unset($log[$j['name']]);
}
if ($old && strstr($i, 'area')) {
$old[$i] = Dever::load('area/api')->string($old[$i]);
if (isset($log[$j['name']]) && $log[$j['name']]) {
$log[$j['name']] = Dever::load('area/api')->string($log[$j['name']]);
}
}
if (isset($log[$j['name']]) && isset($old[$i]) && $old[$i] != $tlog[$j['name']] && $old[$i] != $log[$j['name']]) {
$log[$j['name']] = array('更新前' => $old[$i], '更新后' => $log[$j['name']]);
} elseif ($old) {
//unset($log[$j['name']]);
}
}
}
return $log;
}
/**
* delete_action
*
* @return array
*/
public function delete_action_api()
{
if (Dever::load('manage/auth.oper', 5) == false) {
Dever::alert('您没有权限');
}
$config = $this->config();
if (isset($config['struct']['state']) && (!isset($config['manage']['delete']) || (isset($config['manage']['delete']) && $config['manage']['delete']))) {
$name = '逻辑删除';
$this->load('update', array('where_id' => $this->id, 'state' => 2));
} else {
$name = '物理删除';
$this->load('delete', $this->id);
}
Log::add($this->project, $this->table, $this->menu_id, '', 3, array('ID' => $this->id, '方式' => $name), $this->id);
return 'reload';
return 'reloaderror';
}
/**
* recovery_action
*
* @return array
*/
public function recovery_action_api()
{
if (Dever::load('manage/auth.oper', 5) == false) {
Dever::alert('您没有权限');
}
$this->load('update', array('where_id' => $this->id, 'state' => 1));
Log::add($this->project, $this->table, $this->menu_id, '', 4, array('ID' => $this->id, '方式' => '逻辑恢复'), $this->id);
return 'reload';
}
/**
* list_data
*
* @return array
*/
public function list_data()
{
$config = $this->config();
$data = array();
if (isset($config['manage']['data']) && $config['manage']['data']) {
$num = count($config['manage']['data']);
if ($num <= 4) {
$xs = '3';
} else {
$xs = '1';
}
foreach ($config['manage']['data'] as $k => $v) {
if (is_object($v[1])) {
$function = $v[1];
$v[1] = $function();
}
$link = '';
if (isset($v[2]) && $v[2]) {
$link = 'project/database/list?project=' . $this->project . '&table=' . $this->table . '&' . $v[2];
$link = 'href="' . Dever::url($link, 'manage') . '"';
}
$data[] = '
'.$v[0].'
'.$v[1].'
';
}
}
return $data;
}
/**
* list_data
*
* @return array
*/
public function list_data_show()
{
$config = $this->config();
if (isset($config['manage']['data']) && $config['manage']['data']) {
return 'display:block';
}
return 'display:none';
}
/**
* chart
*
* @return array
*/
public function chart($config, $key, $data, $struct)
{
if (!$this->chart) {
$this->chart = array();
$this->chart['x'] = array();
$this->chart['data'] = array();
}
if ($config['x'] == $key) {
$this->chart['x'][] = $data;
} elseif (in_array($key, $config['data'])) {
if (!isset($this->chart['data'][$key])) {
$this->chart['data'][$key] = array
(
'name' => $struct['name'],
'type' => 'line',
'stack' => 'Total',
'data' => array(),
);
}
$this->chart['data'][$key]['data'][] = $data;
}
}
/**
* chart_data
*
* @return array
*/
public function list_chart()
{
$config = $this->config();
$chart = '';
if (isset($config['manage']['chart']) && $this->chart) {
$this->chart['x'] = array_reverse($this->chart['x']);
$x = Dever::json_encode($this->chart['x']);
$this->chart['data'] = array_values($this->chart['data']);
foreach ($this->chart['data'] as $k => $v) {
$this->chart['data'][$k]['data'] = array_reverse($this->chart['data'][$k]['data']);
}
$data = Dever::json_encode($this->chart['data']);
$echarts = Dever::assets('lib/echarts/echarts.common.min.js', 'script');
$chart = '";
}
return $chart;
}
/**
* chart_data
*
* @return array
*/
public function list_chart_show()
{
$config = $this->config();
if (isset($config['manage']['chart'])) {
return 'display:block';
}
return 'display:none';
}
/**
* stat 为主动统计提供相关数据
*
* @return array
*/
public function stat()
{
//bundle 包依赖工具
$config = $this->config();
if (empty($config['manage']['stat'])) {
Dever::alert('该项目主动统计功能未开放');
}
$data = $config['manage'];
$data['table'] = '';
$method = $this->project . '/' . $this->table . '-all';
$gp = Dever::input('gp', 'month,day');
$col = is_string($gp) ? explode(',', $gp) : $gp;
$data['search'] = $this->stat_search($config['struct'], $gp, $config['manage']['stat'], $config['manage']['search']);
foreach ($col as $k => $v) {
$this->stat_data($data, $config['struct'], $v, $method);
}
return $data;
}
/**
* stat 为主动统计提供导出数据 后续优化
*
* @return array
*/
public function stat_excel()
{
Dever::$global['base']['excel'] = 1;
//print_r($data['thead']);die;
$data = $this->stat();
if ($data && isset($data['list'])) {
$xls = new \PHPExcel();
$xls->getProperties()->setCreator("Maze Stat Excel")
->setLastModifiedBy("Maze Stat Excel")
->setTitle("Office 2007 XLSX Maze Document")
->setSubject("Office 2007 XLSX Maze Document")
->setDescription("Dever Stat Excel")
->setKeywords("Dever Stat Excel")
->setCategory("Dever Stat Excel");
$info = $this->info();
$name = $info['list_header'] . '的' . $info['stat_desc'] . '-' . $info['project_name'];
$start = 65;
$s = 0;
foreach ($data['thead'] as $k => $v) {
if ($s > 0) {
$xls->createSheet();
}
$act = $xls->setActiveSheetIndex($s);
$act->setTitle($v[0]);
$s++;
$i = 0;
foreach ($v as $kj => $vj) {
$num = 1;
$cell = $this->_getChr($start, $i);
$act->setCellValue($cell . '' . $num, $vj);
$act->getColumnDimension($cell)->setWidth(20);
$i++;
if (isset($data['list'][$k])) {
foreach ($data['list'][$k] as $ki => $vi) {
if (isset($vi[$kj])) {
$num += 1;
$act->setCellValue($cell . $num, $vi[$kj]);
}
}
}
}
}
//$act->getStyle('A1:'.$k.'20')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER); // 垂直居中
//$act->getStyle('A1:'.$k.'20')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);// 水平居中
$xls->setActiveSheetIndex(0);
$filename = $name . '.xlsx';
header('Pragma: public');
header('Expires: 0');
header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
header('Content-Type:application/force-download');
header('Content-Type:application/vnd.ms-execl');
header('Content-Type:application/octet-stream');
header('Content-Type:application/download');
header("Content-Disposition:attachment;filename='" . $filename . "'");
header('Content-Transfer-Encoding:binary');
$write = \PHPExcel_IOFactory::createWriter($xls, 'Excel2007');
$write->save('php://output');
}
}
/**
* stat_search
*
* @return mixed
*/
private function stat_search($struct, $col, $stat, $search)
{
unset($struct['id']);
unset($struct['cdate']);
if ($stat) {
$stat = explode(',', $stat);
foreach ($stat as $k => $v) {
if (isset($struct[$v])) {
unset($struct[$v]);
}
}
}
$struct['day']['name'] = '天';
$struct['month']['name'] = '月';
$struct['year']['name'] = '年';
$param['update'] = 'checkbox';
$param['name'] = 'gp';
$param['value'] = $col;
$param['option'] = $struct;
$html = '
';
return $html;
}
/**
* stat_data
*
* @return mixed
*/
private function stat_data(&$data, $struct, $col, $method)
{
Dever::setInput('group', $col);
switch ($col) {
case 'year':
$name = '按年统计';
break;
case 'month':
$name = '按月统计';
break;
case 'day':
$name = '按天统计';
break;
default:
$name = $struct[$col]['name'];
break;
}
$list = Dever::load($method, array('group' => $col, 'col' => 'count(1) as total,id'));
$data['table'] .= '
';
$data['table'] .= '| ' . $name . ' | 统计数字 |
|---|
';
$data['thead'][$col] = array($name, '统计数字');
if ($list) {
$data['table'] .= '';
$total = 0;
foreach ($list as $k => $v) {
if (isset($v[$col])) {
if (isset($struct[$col]['option'])) {
$option = $this->option($struct[$col]['option']);
if (isset($option[$v[$col]])) {
$v[$col] = $option[$v[$col]];
if (is_array($v[$col])) {
$v[$col] = $v[$col]['name'];
}
}
}
$data['table'] .= '| ' . $v[$col] . ' | ' . $v['total'] . ' |
';
$total += $v['total'];
$data['list'][$col][] = array($v[$col], $v['total']);
}
}
$data['table'] .= '';
if ($total > 0 && $k > 0) {
$data['table'] .= '| 汇总 | ' . $total . ' |
';
$data['list'][$col][] = array('汇总', $total);
}
}
$data['table'] .= '
';
}
/**
* load
*
* @return mixed
*/
private function load($method = 'one', $param = array(), $table = false)
{
if (!$table) {
$table = $this->table;
}
return Dever::load($this->project . '/' . $table . '-' . $method, $param);
}
/**
* __call
*
* @return object
*/
public function __call($method, $param)
{
if (strpos($method, 'html_') !== false) {
return Html::text($param);
}
return $this;
}
/**
* option
*
* @return string
*/
private function option($option, $value = false)
{
if (is_object($option)) {
$function = $option;
$option = $function();
}
if ($value && is_array($value)) {
$state = false;
foreach ($value as $k => $v) {
if ($v === true) {
$state = true;
break;
}
}
if ($state) {
$option = array_intersect_key($option, $value);
} else {
$option = $value;
}
}
return $option;
}
/**
* option
*
* @return string
*/
public function manage()
{
$config = $this->config();
return $config;
}
/**
* valid
*
* @return string
*/
public function valid()
{
//http://placehold.it/350x150
$config = $this->config();
if (isset($config['struct'])) {
$rule = array();
$rule['required']['regex'] = 'none';
$rule['required']['alertText'] = '此项不能为空';
$rule['required']['alertTextCheckboxMultiple'] = '请选择一个选项';
$rule['required']['alertTextCheckboxe'] = '请选择一个选项';
$rule['required']['alertTextDateRange'] = '日期范围不可空白';
foreach ($config['struct'] as $k => $v) {
if (isset($v['match']) && $v['match'] != 'option' && is_string($v['match']) && strpos($v['match'], '/') !== false) {
if (strstr($v['match'], 'option||')) {
$v['match'] = str_replace('option||', '', $v['match']);
}
$rule[$k]['regex'] = $v['match'];
$rule[$k]['alertText'] = $v['desc'];
}
}
}
$script = '';
//print_r($script);die;
return $script;
}
/**
* save
*
* @return string
*/
public function save()
{
$config = $this->config();
if (isset($config['manage']['save'])) {
return 'yes';
}
return 'no';
}
}