function WriteNote($msg, $date, $ip, $user)
{
$nsql = new Dedesql();
$notesql = "insert into #@__recordline(message,date,ip,userid) values('{$msg}','{$date}','{$ip}','{$user}')";
$nsql->ExecuteNoneQuery($notesql);
$nsql->close();
}
require dirname(__FILE__) . "/include/config_rglobals.php";
if ($id == '') {
ShowMsg('非法参数，请正确执行此文件。', '-1');
}
if ($action == 'save') {
if ($s_name == '') {
ShowMsg('请输入职工的姓名', '-1');
exit;
}
$addsql = "update #@__staff set s_name='{$s_name}',s_address='{$s_address}',s_phone='{$s_phone}',s_part='{$s_part}',s_way='{$s_way}',s_money='{$s_money}',s_utype='{$s_utype}',s_duty='{$s_duty}' where id='{$id}'";
$message = "修改公司职工" . $s_name . "资料成功";
$loginip = getip();
$logindate = getdatetimemk(time());
$username = str_replace($cfg_cookie_encode, '', $_COOKIE["VioomaUserID"]);
$asql = new Dedesql(false);
$asql->ExecuteNoneQuery($addsql);
$asql->ExecuteNoneQuery("insert into #@__recordline(message,date,ip,userid) values('{$message}','{$logindate}','{$loginip}','{$username}')");
$asql->close();
showmsg('成功修改了职工的资料', 'system_worker.php');
exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="style/main.css" rel="stylesheet" type="text/css" />
<title><?php
echo $cfg_softname;
?>
职工管理</title>
if ($action == 'save') {
if ($b_name == '') {
ShowMsg('请输入账户的名称', '-1');
exit;
}
if ($b_money == '' || !is_numeric($b_money) || $b_money < 0) {
ShowMsg('请确保输入了正确的初始金额', '-1');
exit;
}
$addsql = "insert into #@__bank(bank_name,bank_money,bank_account,bank_default,bank_text) values('{$b_name}','{$b_money}','{$b_account}','{$b_default}','{$b_text}')";
$message = "添加银行账户" . $b_name . "成功";
$loginip = getip();
$logindate = getdatetimemk(time());
$username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']);
$asql = new Dedesql(false);
$asql->ExecuteNoneQuery($addsql);
$asql->close();
WriteNote($message, $logindate, $loginip, $username);
showmsg('成功添加了银行账户', 'bank.php');
exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="style/main.css" rel="stylesheet" type="text/css" />
<title><?php
echo $cfs_softname;
?>
账户管理</title>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>会员删除</title>
</head>
<body>
<?php
require_once dirname(__FILE__) . "/include/config_base.php";
require_once dirname(__FILE__) . "/include/config_rglobals.php";
if ($id == '') {
ShowMsg('非法的执行操作', 'guest_group.php');
}
//检测分类的等级
$username = str_replace($cfg_cookie_encode, '', $_COOKIE["VioomaUserID"]);
$dsql = new Dedesql(false);
$query = "select * from #@__group where id='{$id}'";
$dsql->Setquery($query);
$dsql->Execute();
$rowcount = $dsql->GetTotalRow();
if ($rowcount == 0) {
//非法ID
ShowMsg('执行了非法的操作', '-1');
} else {
$dsql->ExecuteNoneQuery("delete from #@__group where id='{$id}'");
WriteNote('成功删除会员分组资料(ID为' . $id . ')', getdatetimemk(time()), getip(), $username);
ShowMsg('成功删除会员分组资料', 'guest_group.php');
}
$dsql->close();
?>
</body>
</html>
<?php
require dirname(__FILE__) . "/include/config_base.php";
require dirname(__FILE__) . "/include/config_rglobals.php";
if ($id == '') {
ShowMsg('非法参数，请正确执行此文件。', '-1');
}
if ($action == 'save') {
if ($b_name == '') {
ShowMsg('请输入账户名称', '-1');
exit;
}
if ($b_default == 1) {
$sasql = new Dedesql(false);
$sasql->ExecuteNoneQuery("update #@__bank set bank_default=0");
$sasql->close();
}
$addsql = "update #@__bank set bank_name='{$b_name}',bank_account='{$b_account}',bank_default='{$b_default}',bank_text='" . $b_text . "' where id='{$id}'";
$message = "修改银行资料" . $b_name . "成功";
$loginip = getip();
$logindate = getdatetimemk(time());
$username = str_replace($cfg_cookie_encode, '', $_COOKIE["VioomaUserID"]);
WriteNote($message, $logindate, $loginip, $username);
$isql = new dedesql(false);
$isql->ExecuteNoneQuery($addsql);
$isql->close();
showmsg('成功修改了银行账户资料', 'bank.php');
exit;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
if ($pid == '') {
//初始状态
if ($action == 'normal') {
$csql->SetQuery("select * from #@__saleback where rdh='{$did}'");
} else {
$csql->SetQuery("select * from #@__saleback where id<0");
}
} else {
if ($action == '' && $did != '') {
//写入产品记录
$wsql = new Dedesql(false);
$writesql = "select * from #@__basic where cp_number='{$pid}'";
$wsql->Setquery($writesql);
$wsql->Execute();
$wrs = $wsql->GetOne();
$wsql->ExecuteNoneQuery("insert into #@__saleback(productid,number,rdh,dtime,r_text) values('" . $pid . "','" . $num . "','" . $did . "','" . GetDateTimeMk(time()) . "','" . $r_text . "')");
$wsql->close();
}
$csql->SetQuery("select * from #@__saleback where rdh='{$did}'");
}
$csql->Execute();
$rowcount = $csql->GetTotalRow();
if ($rowcount == 0) {
echo "<tr><td> </td></tr>";
} else {
echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>分类</td><td>单位</td><td>售价</td><td>退回原因<td>退回数量</td><td>删除</tr>";
while ($row = $csql->GetArray()) {
$nsql = new dedesql(false);
$query1 = "select * from #@__basic where cp_number='" . $row['productid'] . "'";
$nsql->setquery($query1);
$nsql->execute();
}
if ($cp_dwname == '') {
echo "<script language='javascript'>alert('请输入产品的基本单位!');history.go(-1)</script>";
}
if ($cp_jj == '' || $cp_sale == '') {
echo "<script language='javascript'>alert('产品进价与建议零售价为必填项!');history.go(-1)</script>";
}
if (!(is_numeric($cp_jj) && is_numeric($cp_sale))) {
echo "<script language='javascript'>alert('价格必须为数字!');history.go(-1)</script>";
}
if ($cp_jj > $cp_sale) {
echo "<script language='javascript'>alert('零售价不能小于进价!');history.go(-1)</script>";
}
$bsql = new Dedesql(false);
$query = "update #@__basic set cp_number='" . $cp_number . "',cp_tm='" . $cp_tm . "',cp_name='" . $cp_name . "',cp_gg='" . $cp_gg . "',cp_categories='" . $cp_categories . "',cp_categories_down='" . $cp_categories_down . "',cp_dwname='" . $cp_dwname . "',cp_jj='" . $cp_jj . "',cp_sale='" . $cp_sale . "',cp_saleall='" . $cp_saleall . "',cp_sdate='" . $cp_sdate . "',cp_edate='" . $cp_edate . "',cp_gys='" . $cp_gys . "',cp_helpword='" . $cp_helpword . "',cp_bz='" . $cp_bz . "' where id='{$id}'";
$bsql->ExecuteNoneQuery($query);
showmsg('成功修改了产品基本信息', 'system_basic_cp.php?action=seek');
$loginip = getip();
$logindate = getdatetimemk(time());
$username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']);
WriteNote('修改产品基本信息' . $cp_name . ' 成功', $logindate, $loginip, $username);
$bsql->close();
exit;
}
$seekrs = new Dedesql(falsh);
$squery = "select * from #@__basic where id='{$id}'";
$seekrs->SetQuery($squery);
$seekrs->Execute();
$rowcount = $seekrs->gettotalrow();
if ($rowcount == 0) {
Showmsg('非法的参数', '-1');
//非法ID
ShowMsg('执行了非法的操作', '-1');
} else {
$row = $dsql->GetArray();
if ($row['reid'] == 0) {
//删除顶级分类
$msql = new Dedesql(false);
$msql->SetQuery("select * from #@__categories where reid='" . $row['id'] . "'");
$msql->Execute();
if ($msql->GetTotalRow() >= 1) {
echo "<script language='javascript'>alert('你要删除的顶级分类下有子分类,请先删除其子分类!');history.go(-1);</script>";
} else {
$msql->ExecuteNoneQuery("delete from #@__categories where id='{$id}'");
WriteNote('成功删除顶级分类' . $row['categories'], getdatetimemk(time()), getip(), $username);
ShowMsg('删除分类成功', 'system_class.php');
}
$msql->close();
} else {
//删除子分类
$msql = new Dedesql(false);
$msql->ExecuteNoneQuery("delete from #@__categories where id='{$id}'");
WriteNote('成功删除子分类' . $row['categories'], getdatetimemk(time()), getip(), $username);
ShowMsg('成功删除子分类', 'system_class.php');
$msql->close();
}
$dsql->close();
}
?>
</body>
</html>
if ($pid == '') {
//初始状态
if ($action == 'normal') {
$csql->SetQuery("select * from #@__kc where rdh='{$did}'");
} else {
$csql->SetQuery("select * from #@__kc where id<0");
}
} else {
if ($action == '' && $did != '') {
//写入产品记录
$wsql = new Dedesql(false);
$writesql = "select * from #@__basic where cp_number='{$pid}'";
$wsql->Setquery($writesql);
$wsql->Execute();
$wrs = $wsql->GetOne();
$wsql->ExecuteNoneQuery("insert into #@__kc(productid,number,labid,rdh,dtime) values('" . $pid . "','" . $num . "','" . $lid . "','" . $did . "','" . GetDateTimeMk(time()) . "')");
$wsql->close();
}
$csql->SetQuery("select * from #@__kc where rdh='{$did}'");
}
$csql->Execute();
$rowcount = $csql->GetTotalRow();
if ($rowcount == 0) {
echo "<tr><td> </td></tr>";
} else {
echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>分类</td><td>单位</td><td>进价</td><td>供应商<td>入库数量</td><td>删除</tr>";
while ($row = $csql->GetArray()) {
$nsql = new dedesql(false);
$query1 = "select * from #@__basic where cp_number='" . $row['productid'] . "'";
$nsql->setquery($query1);
$nsql->execute();
//非法ID
ShowMsg('执行了非法的操作', '-1');
} else {
$row = $dsql->GetArray();
if ($row['reid'] == 0) {
//删除顶级分类
$msql = new Dedesql(false);
$msql->SetQuery("select * from #@__dw where reid='" . $row['id'] . "'");
$msql->Execute();
if ($msql->GetTotalRow() >= 1) {
echo "<script language='javascript'>alert('你要删除的单位下有子单位,请先删除其子单位!');history.go(-1);</script>";
} else {
$msql->ExecuteNoneQuery("delete from #@__dw where id='{$id}'");
WriteNote('成功删除基本单位' . $row['dwname'], getdatetimemk(time()), getip(), $username);
ShowMsg('删除计量单位成功', 'system_dw.php');
}
$msql->close();
} else {
//删除子分类
$msql = new Dedesql(false);
$msql->ExecuteNoneQuery("delete from #@__dw where id='{$id}'");
WriteNote('成功删除子计量单位' . $row['dwname'], getdatetimemk(time()), getip(), $username);
ShowMsg('成功删除子计量单位', 'system_dw.php');
$msql->close();
}
$dsql->close();
}
?>
</body>
</html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>职工删除</title>
</head>
<body>
<?php
require_once dirname(__FILE__) . "/include/config_base.php";
require_once dirname(__FILE__) . "/include/config_rglobals.php";
if ($id == '') {
ShowMsg('非法的执行操作', 'system_worker.php');
}
//检测分类的等级
$username = str_replace($cfg_cookie_encode, '', $_COOKIE["VioomaUserID"]);
$dsql = new Dedesql(false);
$query = "select * from #@__staff where id='{$id}'";
$dsql->Setquery($query);
$dsql->Execute();
$rowcount = $dsql->GetTotalRow();
if ($rowcount == 0) {
//非法ID
ShowMsg('执行了非法的操作', '-1');
} else {
$dsql->ExecuteNoneQuery("delete from #@__staff where id='{$id}'");
WriteNote('成功删除职工资料(ID为' . $id . ')', getdatetimemk(time()), getip(), $username);
ShowMsg('成功删除公司职工资料', 'system_worker.php');
}
$dsql->close();
?>
</body>
</html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>职工删除</title>
</head>
<body>
<?php
require_once dirname(__FILE__) . "/include/config_base.php";
require_once dirname(__FILE__) . "/include/config_rglobals.php";
if ($id == '') {
ShowMsg('非法的执行操作', 'system_worker.php');
}
//检测分类的等级
$username = str_replace($cfg_cookie_encode, '', $_COOKIE["VioomaUserID"]);
$dsql = new Dedesql(false);
$query = "select * from #@__basic where id='{$id}'";
$dsql->Setquery($query);
$dsql->Execute();
$rowcount = $dsql->GetTotalRow();
if ($rowcount == 0) {
//非法ID
ShowMsg('执行了非法的操作', '-1');
} else {
$dsql->ExecuteNoneQuery("delete from #@__basic where id='{$id}'");
WriteNote('成功删除产品基本信息(ID为' . $id . ')', getdatetimemk(time()), getip(), $username);
ShowMsg('成功删除产品基本信息', 'system_basic_cp.php?action=seek');
}
$dsql->close();
?>
</body>
</html>
echo "<script language='javascript'>alert('价格必须为数字!');history.go(-1)</script>";
}
if ($cp_jj > $cp_sale) {
echo "<script language='javascript'>alert('零售价不能小于进价!');history.go(-1)</script>";
}
$bsql = new Dedesql(false);
$query = "select * from #@__basic where cp_name='{$cp_name}' and cp_gg='{$cp_gg}'";
$bsql->SetQuery($query);
$bsql->Execute();
$rowcount = $bsql->GetTotalRow();
if ($rowcount >= 1) {
ShowMsg('此产品名称和规格在数据库里已经存在,请检查或区分!', '-1');
exit;
} else {
$addquery = "insert into #@__basic(cp_number,cp_tm,cp_name,cp_gg,cp_categories,cp_categories_down,cp_dwname,cp_jj,cp_sale,cp_saleall,cp_sdate,cp_edate,cp_gys,cp_helpword,cp_bz) values('{$cp_number}','{$cp_tm}','{$cp_name}','{$cp_gg}','{$cp_categories}','{$cp_categories_down}','{$cp_dwname}','{$cp_jj}','{$cp_sale}','{$cp_saleall}','{$cp_sdate}','{$cp_edate}','{$cp_gys}','{$cp_helpword}','{$cp_bz}')";
$bsql->ExecuteNoneQuery($addquery);
ShowMsg('成功写入一条产品基本信息.', 'system_basic_cp.php');
$loginip = getip();
$logindate = getdatetimemk(time());
$username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']);
WriteNote('添加产品基本信息' . $cp_name . ' 成功', $logindate, $loginip, $username);
$bsql->close();
exit;
}
} else {
if ($action == 'seek') {
//列表
?>
<table width="100%" border="0" id="table_style_all" cellpadding="0" cellspacing="0">
<tr>
<td id="table_style" class="l_t"> </td>
