public function save()
{
$act = str_enhtml($this->input->get('act', TRUE));
$id = intval($this->input->post('id', TRUE));
$data['name'] = str_enhtml($this->input->post('name', TRUE));
if ($act == 'add') {
$this->purview_model->checkpurview(78);
strlen($data['name']) < 1 && die('{"status":-1,"msg":"名称不能为空"}');
$this->mysql_model->db_count(UNIT, '(name="' . $data['name'] . '")') > 0 && die('{"status":-1,"msg":"单位名称重复"}');
$data['id'] = $this->mysql_model->db_inst(UNIT, $data);
if ($data['id']) {
$this->data_model->logs('新增单位:' . $data['name']);
$this->cache_model->delsome(UNIT);
die('{"status":200,"msg":"success","data":' . json_encode($data) . '}');
} else {
die('{"status":-1,"msg":"添加失败"}');
}
} elseif ($act == 'update') {
$this->purview_model->checkpurview(79);
strlen($data['name']) < 1 && die('{"status":-1,"msg":"名称不能为空"}');
$this->mysql_model->db_count(UNIT, '(id<>' . $id . ') and (name="' . $data['name'] . '")') > 0 && die('{"status":-1,"msg":"单位名称重复"}');
$sql = $this->mysql_model->db_upd(UNIT, $data, '(id=' . $id . ')');
if ($sql) {
$data['id'] = $id;
$this->data_model->logs('修改单位:' . $data['name']);
$this->cache_model->delsome(UNIT);
die('{"status":200,"msg":"success","data":' . json_encode($data) . '}');
} else {
die('{"status":-1,"msg":"修改失败"}');
}
}
}
public function export()
{
sys_xls('日志明细.xls');
$user = str_enhtml($this->input->get('user', TRUE));
$where = '';
if ($user) {
$where .= ' and username="******"';
}
$data['list'] = $this->cache_model->load_data(LOG, '(1=1) ' . $where . ' order by id desc');
$this->load->view('logs/export', $data);
}
public function parameter()
{
$this->purview_model->checkpurview(81);
$data = str_enhtml($this->input->post(NULL, TRUE));
if (is_array($data) && count($data) > 0) {
$dir = './data/config/parameter_config.php';
$err = $this->config_model->set_config($data, $dir);
if ($err) {
die('{"status":200,"msg":"success"}');
} else {
alert('设置失败');
}
} else {
$this->load->view('settings/parameter', $data);
}
}
public function editpwd()
{
$userpwd = str_enhtml($this->input->post('userpwd', TRUE));
if (strlen($userpwd) > 0) {
$data['userpwd'] = md6($userpwd);
$sql = $this->mysql_model->db_upd(ADMIN, $data, '(uid=' . $this->uid . ')');
if ($sql) {
$this->cache_model->delsome(ADMIN);
$this->load->model('data_model');
$this->data_model->logs('密码修改成功 用户名：' . $this->name);
die('{"status":200,"msg":"密码修改成功"}');
} else {
die('{"status":-1,"msg":"修改失败"}');
}
} else {
$this->load->view('admin/edit');
}
}
public function index()
{
$data = str_enhtml($this->input->post(NULL, TRUE));
if (is_array($data) && count($data) > 0) {
!token(1) && die('token验证失败');
!isset($data['username']) || strlen($data['username']) < 1 && die('用户名不能为空');
!isset($data['userpwd']) || strlen($data['userpwd']) < 1 && die('密码不能为空');
$sql = $this->login_model->login($data['username'], $data['userpwd']);
if ($sql) {
if (isset($data['ispwd']) && $data['ispwd'] == 1) {
$this->input->set_cookie('username', $data['username'], 3600000);
$this->input->set_cookie('userpwd', $data['userpwd'], 3600000);
}
$this->input->set_cookie('ispwd', $data['ispwd'], 3600000);
$this->data_model->logs('登陆成功 用户名：' . $data['username']);
die('1');
}
die('账号或密码错误');
} else {
$this->load->view('login', $data);
}
}
public function del()
{
$this->purview_model->checkpurview(61);
$id = str_enhtml($this->input->post('id', TRUE));
if (strlen($id) > 0) {
$this->mysql_model->db_count(INVSA, '(contactid in(' . $id . '))') > 0 && die('{"status":-1,"msg":"其中有客户发生业务不可删除"}');
$name = $this->mysql_model->db_select(CONTACT, '(id in(' . $id . '))', 'name');
if (count($name) > 0) {
$name = join(',', $name);
}
$sql = $this->mysql_model->db_del(CONTACT, '(id in(' . $id . '))');
if ($sql) {
$this->cache_model->delsome(CONTACT);
$this->data_model->logs('删除客户:ID=' . $id . ' 名称:' . $name);
die('{"status":200,"msg":"success","data":{"msg":"","id":[' . $id . ']}}');
} else {
die('{"status":-1,"msg":"删除失败"}');
}
}
}
public function export()
{
$this->purview_model->checkpurview(10);
sys_xls('销货记录.xls');
$id = str_enhtml($this->input->get_post('id', TRUE));
if (strlen($id) > 0) {
$data['list1'] = $this->cache_model->load_data(INVSA, '(id in(' . $id . '))');
$data['list2'] = $this->data_model->invsa_info(' and (a.invsaid in(' . $id . '))');
$this->data_model->logs('导出销货记录');
$this->load->view('invsa/export', $data);
}
}
public function del()
{
$this->purview_model->checkpurview(76);
$id = intval($this->input->post('id', TRUE));
$type = str_enhtml($this->input->post('typeNumber', TRUE));
$data = $this->mysql_model->db_one(CATEGORY, '(id=' . $id . ')');
if (count($data) > 0) {
$this->mysql_model->db_count(CATEGORY, '(1=1) and (find_in_set(' . $id . ',path))') > 1 && die('{"status":500,"msg":"操作的对象包含了下级类别，请先删除下级类别"}');
$this->mysql_model->db_count(GOODS, '(categoryid=' . $id . ')') > 0 && die('{"status":500,"msg":"发生业务不可删除"}');
$this->mysql_model->db_count(CONTACT, '(categoryid=' . $id . ')') > 0 && die('{"status":500,"msg":"发生业务不可删除"}');
$sql = $this->mysql_model->db_del(CATEGORY, '(id=' . $id . ')');
if ($sql) {
$cate = $this->data_model->category_type();
$this->data_model->logs('删除' . $cate[$data['type']] . ':ID=' . $id . ' 名称：' . $data['name']);
$this->cache_model->delsome(CATEGORY);
die('{"status":200,"msg":"success"}');
} else {
die('{"status":-1,"msg":"删除失败"}');
}
}
}
public function export()
{
$this->purview_model->checkpurview(72);
sys_xls('商品明细.xls');
$skey = str_enhtml($this->input->get('skey', TRUE));
$categoryid = intval($this->input->get('assistId', TRUE));
$where = '';
if ($skey) {
$where .= ' and goods like "%' . $skey . '%"';
}
if ($categoryid > 0) {
$cid = $this->cache_model->load_data(CATEGORY, '(1=1) and find_in_set(' . $categoryid . ',path)', 'id');
if (count($cid) > 0) {
$cid = join(',', $cid);
$where .= ' and categoryid in(' . $cid . ')';
}
}
$this->data_model->logs('导出商品');
$data['list'] = $this->cache_model->load_data(GOODS, '(status=1) ' . $where . ' order by id desc');
$this->load->view('goods/export', $data);
}
public function type()
{
$type = str_enhtml($this->input->get_post('type', TRUE));
if (strlen($type) > 0) {
$v = '';
$data['status'] = 200;
$data['msg'] = 'success';
$list = $this->cache_model->load_data(INVOI_TYPE, '(type="' . $type . '") order by id');
foreach ($list as $arr => $row) {
$v[$arr]['acctId'] = 0;
$v[$arr]['calCost'] = 1;
$v[$arr]['commission'] = false;
$v[$arr]['direction'] = 1;
$v[$arr]['free'] = false;
$v[$arr]['id'] = intval($row['id']);
$v[$arr]['inOut'] = (double) $row['inout'];
$v[$arr]['name'] = $row['name'];
$v[$arr]['process'] = false;
$v[$arr]['sysDefault'] = true;
$v[$arr]['sysDelete'] = false;
$v[$arr]['tableName'] = "t_scm_inventryoi";
$v[$arr]['typeId'] = intval($row['id']);
$v[$arr]['voucher'] = true;
}
$data['data']['items'] = is_array($v) ? $v : '';
$data['data']['totalsize'] = $this->cache_model->load_total(INVOI_TYPE, '(type="' . $type . '")');
die(json_encode($data));
}
}
public function balance_detail_xls()
{
$this->purview_model->checkpurview(56);
sys_xls('balance_detail.xls');
$data['stt'] = str_enhtml($this->input->get_post('beginDate', TRUE));
$data['ett'] = str_enhtml($this->input->get_post('endDate', TRUE));
$accountno = str_enhtml($this->input->get_post('accountNo', TRUE));
$where1 = '';
$where2 = '';
if ($accountno) {
$where1 .= ' and number in(' . str_quote($accountno) . ')';
}
if ($data['stt']) {
$where2 .= ' and billdate>="' . $data['stt'] . '"';
}
if ($data['ett']) {
$where2 .= ' and billdate<="' . $data['ett'] . '"';
}
$data['list1'] = $this->cache_model->load_data(CONTACT, '(status=1) and type=1 ' . $where1 . ' order by id');
$data['list2'] = $this->cache_model->load_data(INVSA, '(1=1) ' . $where2 . ' order by id');
$this->load->view('report/balance_detail_xls', $data);
}
public function export()
{
$this->purview_model->checkpurview(13);
sys_xls('盘点表.xls');
$categoryid = intval($this->input->get_post('categoryId', TRUE));
$goods = str_enhtml($this->input->get_post('goods', TRUE));
$qty = intval($this->input->get_post('showZero', TRUE));
$where = '';
$order = 'order by a.id desc';
if ($categoryid > 0) {
$cid = $this->cache_model->load_data(CATEGORY, '(1=1) and find_in_set(' . $categoryid . ',path)', 'id');
if (count($cid) > 0) {
$cid = join(',', $cid);
$where .= ' and a.categoryid in(' . $cid . ')';
}
}
if ($qty > 0) {
$order = ' HAVING (qty<=0)';
}
if ($goods) {
$where .= ' and a.goods like "%' . $goods . '%"';
}
$this->data_model->logs('导出盘点记录');
$data['list'] = $this->data_model->inventory($where, $order);
$this->load->view('inventory/export', $data);
}
public function admin_checkname()
{
$username = str_enhtml($this->input->get('userName', TRUE));
$this->cache_model->load_total(ADMIN, '(username="******")') > 0 && die('{"status":200,"msg":"success"}');
die('{"status":502,"msg":"用户名不存在"}');
}
public function recovery()
{
$name = str_enhtml($this->input->get_post('name', TRUE));
$path = $this->conf['db_url'] . $name;
$info = read_file($path);
if ($info) {
$this->db->trans_begin();
$list = explode(";\n", $info);
foreach ($list as $sql) {
$this->db->query($sql);
}
if ($this->db->trans_status() === FALSE) {
$this->db->trans_rollback();
die('{"status":-1,"msg":"恢复失败"}');
} else {
$this->db->trans_commit();
$this->data_model->logs('备份与恢复,恢复文件名:' . $name);
die('{"status":200,"msg":"success"}');
}
} else {
die('{"status":-1,"msg":"恢复失败"}');
}
}
public function del()
{
$this->purview_model->checkpurview(66);
$id = str_enhtml($this->input->post('id', TRUE));
if (strlen($id) > 0) {
$this->mysql_model->db_count(INVPU, '(contactid in(' . $id . '))') > 0 && die('{"status":-1,"msg":"其中有供应商发生业务不可删除"}');
$sql = $this->mysql_model->db_del(CONTACT, '(id in(' . $id . '))');
if ($sql) {
$this->cache_model->delsome(CONTACT);
$this->data_model->logs('删除供应商:ID=' . $id);
die('{"status":200,"msg":"success","data":{"msg":"","id":[' . $id . ']}}');
} else {
die('{"status":-1,"msg":"删除失败"}');
}
}
}
public function doset()
{
$act = $this->input->get('act', TRUE);
$username = str_enhtml($this->input->get('username', TRUE));
$username == 'admin' && die('{"status":-1,"msg":"管理员不可操作"}');
switch ($act) {
case 'isstatus':
$data['status'] = 1;
break;
case 'nostatus':
$data['status'] = 0;
break;
default:
die('{"status":-1,"msg":"操作失败"}');
}
$sql = $this->mysql_model->db_upd(ADMIN, $data, '(username="******")');
if ($sql) {
$this->cache_model->delsome(ADMIN);
die('{"status":200,"data":{"userName":"******"},"msg":"success"}');
} else {
die('{"status":-1,"msg":"操作失败"}');
}
}
