<title><?php echo $cfg_softname; ?> 职工管理</title> <script language="javascript"> function cway(value){ if(value==0) document.forms[0].s_e.value="%"; else document.forms[0].s_e.value="元/件"; } </script> </head> <body> <?php $esql = new Dedesql(false); $query = "select * from #@__staff where id='{$id}'"; $esql->SetQuery($query); $esql->Execute(); if ($esql->GetTotalRow() == 0) { ShowMsg('非法调用参数,请重试', '-1'); exit; } $row = $esql->GetOne($query); $esql->close(); ?> <table width="100%" border="0" id="table_style_all" cellpadding="0" cellspacing="0"> <tr> <td id="table_style" class="l_t"> </td> <td> </td> <td id="table_style" class="r_t"> </td>
if(obj.style.display == "none"){ obj.style.display = "block"; }else{ obj.style.display = "none"; } } </script> <base target="main"> <body> <div class="menu"> <?php if (!empty($_COOKIE["VioomaUserID"])) { if ($c == '') { $c = 1; } $msql = new Dedesql(false); $query = "select name from #@__menu where id='{$c}'"; $menuinfo = $msql->GetOne($query); $menus = "\r\n<dl>\r\n <dt><a href='###' onclick=showHide('items" . $c . "') target='_self' class='top'>" . $menuinfo['name'] . "</a></dt>\r\n <dd id='items" . $c . "' style='display:block;'>\r\n\t\t\t<ul>\r\n~Item~\r\n \t\t\t</ul>\r\n\t\t</dd>\r\n\t</dl>\r\n"; $msql->Setquery("select name,url from #@__menu where reid='{$c}'"); $msql->Execute(); while ($row = $msql->GetArray()) { $iteminfo = $iteminfo . "\r\n<li><a href='" . $row['url'] . "' target='main'>" . $row['name'] . "</a></li>\r\n"; } $menus = str_replace("~Item~", $iteminfo, $menus); echo $menus . $endmenus; $msql->close(); } ?> </div> </body>
<textarea name="b_text" rows="2" cols="40"></textarea></td> </tr> <tr> <td id="row_style"> 是否默认银行:</td> <td> <select name="b_default"><option value="1">是</option><option value="0" selected>否</option></select> 只能保留一个默认银行</td> </tr> <tr> <td id="row_style"> </td> <td> <input type="submit" name="submit" value=" 添加账户 "></td> </tr></form> </table> <?php } else { echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">"; $csql = new Dedesql(false); $csql->SetQuery("select * from #@__bank"); $csql->Execute(); $rowcount = $csql->GetTotalRow(); if ($rowcount == 0) { echo "<tr><td> 还没添加银行账户,请先<a href=bank.php?action=new>添加账户</a>。</td></tr>"; } else { echo "<tr class='row_color_head'><td>ID</td><td>银行名称</td><td>银行账号</td><td>金额</td><td>默认</td><td>备注</td><td>修改</td></tr>"; while ($row = $csql->GetArray()) { if ($row['bank_default'] == 1) { $default_yes = "<img src=images/yes.png>"; } else { $default_yes = " "; $delstring = " | <a href=bank_del.php?id=" . $row['id'] . ">删除</a>"; } echo "<tr><td>ID号:" . $row['id'] . "</td><td> " . $row['bank_name'] . "</td><td> " . $row['bank_account'] . "</td><td> ¥" . $row['bank_money'] . "</td><td> " . $default_yes . "</td><td>" . $row['bank_text'] . "</td><td><a href=bank_edit.php?id=" . $row['id'] . ">修改</a>" . $delstring . "</td></tr>";
<!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" /> <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>
if ($cp_sdate == '' || $cp_edate == '' || $cp_sdate == '单击选择日期' || $cp_edate == '单击选择日期' || $cp_sdate > $cp_edate) { echo "<script>alert('请选择正确的时间段');history.go(-1);</script>"; } if ($atype != '') { $query = "select * from #@__accounts where dtime between '{$cp_sdate}' and '{$cp_edate}' and atype='{$atype}' order by dtime desc"; } else { $query = "select * from #@__accounts where dtime between '{$cp_sdate}' and '{$cp_edate}' order by dtime desc"; } } else { if ($atype != '') { $query = "select * from #@__accounts where atype='{$atype}' order by dtime desc"; } else { $query = "select * from #@__accounts order by dtime desc"; } } $csql = new Dedesql(false); $dlist = new DataList(); $dlist->pageSize = $cfg_record; //设置GET参数表 if ($action == 'seek') { $dlist->SetParameter("action", $action); $dlist->SetParameter("cp_sdate", $cp_sdate); $dlist->SetParameter("cp_edate", $cp_edate); } $dlist->SetSource($query); echo "<tr><td colspan='8' align='right'>" . $moneystring . " </td></tr>"; echo "<tr class='row_color_head'><td>ID号</td><td>科目</td><td>账户</td><td>操作用户</td><td>日期</td><td>金额</td><td>备注</td><td>选择</td></tr>"; $mylist = $dlist->GetDataList(); while ($row = $mylist->GetArray('dm')) { $cmoney += $row['amoney']; echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['id'] . "</td><td> <a href='{$hurl}" . $row['atype'] . "'>" . $row['atype'] . "</td><td>" . getbank($row['abank']) . "</td><td>" . $row['apeople'] . "</td><td>" . $row['dtime'] . "</td><td>¥" . $row['amoney'] . "</td><td>" . $row['atext'] . "</td><td><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . $row['id'] . "'></td>\r\n</tr>";
} 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'); exit; } $row = $seekrs->GetOne(); $seekrs->close(); ?> <body onload="form1.cp_tm.focus()"> <table width="100%" border="0" id="table_style_all" cellpadding="0" cellspacing="0"> <tr> <td id="table_style" class="l_t"> </td>
<tr> <td bgcolor="#FFFFFF"> <?php echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">"; $csql = new Dedesql(false); 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>";
//非法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>
else return true; } </SCRIPT> <META content="MSHTML 6.00.2900.5583" name=GENERATOR></HEAD> <BODY leftMargin=0 topMargin=0 onload=document.form1.username.focus() MARGINHEIGHT="0" MARGINWIDTH="0"> <?php require_once dirname(__FILE__) . "/include/config_rglobals.php"; require_once dirname(__FILE__) . "/include/config_base.php"; if ($action == 'login') { if (GetCkVdValue() == $code) { //登陆处理 $username = eregi_replace("['\"\$ \r\n\t;<>\\*%\\?]", '', $username); $loginip = getip(); $logindate = getdatetimemk(time()); $lsql = new Dedesql(false); $sql = str_replace('#@__', $cfg_dbprefix, "select * from #@__boss where boss='{$username}' and password='******'"); $lsql->SetQuery($sql); $lsql->Execute(); $rowcount = $lsql->GetTotalRow(); if ($rowcount == 0) { $message = '用户或密码错误被系统拒绝登陆!'; WriteNote($message, $logindate, $loginip, $username); showmsg($message, -1); } else { //可以正常登陆,写登陆数据 $message = "正常登入进销存系统!"; setcookie('VioomaUserID', $username . $cfg_cookie_encode, time() + $cfg_keeptime * 3600); WriteNote($message, $logindate, $loginip, $username); $loginsql = str_replace('#@__', $cfg_dbprefix, "update #@__boss set logindate='{$logindate}',loginip='{$loginip}' where boss='{$username}'"); mysql_query($loginsql);
<tr> <td bgcolor="#FFFFFF"> <?php echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">"; $csql = new Dedesql(false); 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>";
<head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <link href="style/main.css" rel="stylesheet" type="text/css" /> <title>产品入库管理</title> <style type="text/css"> .rtext {background:transparent;border:0px;color:red;font-weight:bold;font-family:Verdana, Arial, Helvetica, sans-serif;} </style> </head> <?php if ($action == 'save') { //保存入库单及记录 if ($labid == '' || $kc_number == '' || $pid == '') { showmsg('执行了带有非法参数的文件', '-1'); exit; } $bsql = new Dedesql(false); $query = "select * from #@__mainkc where p_id='{$pid}'"; $bsql->SetQuery($query); $bsql->Execute(); $rowcount = $bsql->GetTotalRow(); if ($rowcount == 0) { ShowMsg('非法参数或没有此产品信息!', '-1'); exit; } else { $bsql->executenonequery("update #@__mainkc set number='{$kc_number}',l_id='{$labid}' where p_id='" . $pid . "'"); $loginip = getip(); $logindate = getdatetimemk(time()); $username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']); WriteNote('修改产品' . get_name($pid, 'name') . '资料成功', $logindate, $loginip, $username); ShowMsg('产品信息已成功修改', 'system_kc.php'); $bsql->close();
function getadid($id) { $s = new Dedesql(false); $query = "select * from #@__staff"; $s->SetQuery($query); $s->Execute(); $rowcount = $s->GetTotalRow(); if ($rowcount == 0) { echo "<a href='system_worker.php?action=new'>请先添加员工</a>"; } else { echo "<select name=\"staff\"><option value=''>=请选择业务员=</option>"; while ($row1 = $s->GetArray()) { if ($id == '' || $row1['id'] != $id) { echo "<option value='" . $row1['s_name'] . "'>" . $row1['s_name'] . "</option>"; } else { echo "<option value='" . $row1['s_name'] . "' selected>" . $row1['s_name'] . "</option>"; } } echo "</select>"; } $s->close(); }
//非法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>
$dlist = new DataList(); $dlist->pageSize = $cfg_record; $dlist->SetParameter("action", $action); //设置GET参数表 $dlist->SetSource($query); echo "<tr class='row_color_head'><td>ID</td><td>销售单号</td><td>操作人员</td><td>创单时间</td><td>保存状态</td><td>相关操作</td></tr>"; $mylist = $dlist->GetDataList(); while ($row = $mylist->GetArray('dm')) { if ($row['r_status'] == 1) { $statusstring = "<img src='images/yes.png'>"; } else { $statusstring = "<img src='images/no.png'>"; } echo "<tr><td>ID号:" . $row['id'] . "</td><td> " . $row['r_dh'] . "</td><td> " . $row['r_people'] . "</td><td> " . $row['r_date'] . "</td><td> " . $statusstring . "</td><td><span onclick=showsubinfo(" . $row['id'] . ") style='cursor:hand;'>展开详情</span> | <a href=system_basic_del.php?id=" . $row['id'] . ">打印此单</a></td></tr>"; echo "<tr id='rk_subinfo" . $row['id'] . "' style='display:none;'><td colspan='6'><br><table width=\"98%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\" align=\"center\">"; $csql1 = new Dedesql(false); $csql1->SetQuery("select * from #@__sale where rdh='" . $row['r_dh'] . "'"); $csql1->Execute(); $rowcount = $csql1->GetTotalRow(); echo "<tr class='row1_color_head'><td>货号</td><td>名称</td><td>规格</td><td>分类</td><td>单位</td><td>售价</td><td>供应商<td>入库数量</td><td>操作</tr>"; while ($row = $csql1->GetArray()) { $nsql = new dedesql(false); $query1 = "select * from #@__basic where cp_number='" . $row['productid'] . "'"; $nsql->setquery($query1); $nsql->execute(); $row1 = $nsql->getone(); echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\"><td>" . $row['productid'] . "</td><td> " . $row1['cp_name'] . "</td><td>" . $row1['cp_gg'] . "</td><td>" . get_name($row1['cp_categories'], 'categories') . ">" . get_name($row1['cp_categories_down'], 'categories') . "</td><td>" . get_name($row1['cp_dwname'], 'dw') . "</td><td>¥" . $row1['cp_sale'] . "</td><td>" . $row1['cp_gys'] . "</td><td>" . $row['number'] . "</td><td><a href=''></a></td></tr>"; $nsql->close(); } $csql1->close(); echo "</table><br></td></tr>\r\n";
</form> </table> <?php } else { echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">"; $csql = new Dedesql(false); $csql->SetQuery("select * from #@__dw where reid=0"); $csql->Execute(); $rowcount = $csql->GetTotalRow(); if ($rowcount == 0) { echo "<tr><td> 系统里还没有任何计量单位,请先<a href=system_dw.php?action=new>添加基本计量单位</a>。</td></tr>"; } else { echo "<tr class='row_color_head'><td>ID</td><td>名称</td><td>操作</td></tr>"; while ($row = $csql->GetArray()) { echo "<tr><td>ID号:" . $row['id'] . "</td><td><img src=images/cate.gif align=absmiddle> " . $row['dwname'] . "</td><td><a href=system_dw_edit.php?id=" . $row['id'] . ">修改</a> | <a href=system_dw_del.php?id=" . $row['id'] . ">删除</a></td></tr>"; $csql1 = new Dedesql(false); $csql1->SetQuery("select * from #@__dw where reid='" . $row['id'] . "'"); $csql1->Execute(); while ($row1 = $csql1->GetArray()) { echo "<tr class='row_color_gray'><td> ID号:" . $row1['id'] . "</td><td> ├ " . $row1['dwname'] . "</td><td><a href=system_dw_edit.php?id=" . $row1['id'] . ">修改</a> | <a href=system_dw_del.php?id=" . $row1['id'] . ">删除</a></td></tr>"; } $csql1->close(); } } echo "</table>"; $csql->close(); } ?> </td> </tr> </table>
require dirname(__FILE__) . "/include/config_rglobals.php"; if ($action == 'save') { if ($atext == '') { ShowMsg('请输入财务进出原因', '-1'); exit; } if ($amoney == '' || !is_numeric($amoney) || $amoney < 0) { ShowMsg('请确保输入了正确的金额', '-1'); exit; } $loginip = getip(); $logindate = getdatetimemk(time()); $username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']); $addsql = "insert into #@__accounts(atype,amoney,abank,dtime,apeople,atext) values('{$atype}','{$amoney}','{$abank}','{$logindate}','{$username}','{$atext}')"; $message = "手动添加账务成功"; $asql = new Dedesql(false); $asql->ExecuteNoneQuery($addsql); $asql->close(); WriteNote($message, $logindate, $loginip, $username); showmsg('成功添加了账务', 'system_money.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; ?>