echo "<input type=\"text\" name=\"cp_sdate\" size=\"15\" VALUE=\"单击选择日期\" onclick=\"setday(this)\"> 至\r\n\t\t <input type=\"text\" name=\"cp_edate\" size=\"15\" VALUE=\"单击选择日期\" onclick=\"setday(this)\">"; $hurl = "system_money.php?atype="; } ?> <input type="submit" value="开始检索"> </td> </tr></form> </table> </td> </tr> <form method="post" name="sel"> <tr> <td bgcolor="#FFFFFF"> <?php $asql = new dedesql(false); $aquery = "select sum(amoney) as imoney from #@__accounts where atype='收入'"; $aquery1 = "select sum(amoney) as omoney from #@__accounts where atype='支出'"; $asql->setquery($aquery); $asql->execute(); $rs = $asql->getone(); $imoney = $rs['imoney']; $asql->setquery($aquery1); $asql->execute(); $rs = $asql->getone(); $omoney = $rs['omoney']; $asql->close(); if ($imoney < $omoney) { $moneystring = "亏损:¥" . ($omoney - $imoney) . "元,总收入:¥" . $imoney . ",总支出:¥" . $omoney; } elseif ($imoney - $omoney == 0) { $moneystring = "收支平衡,总收入:¥" . $imoney . ",总支出:¥" . $omoney;
function getarea($areaid) { global $dsql; if($areaid==0) return ''; if(!is_object($dsql)) $dsql = new dedesql(false); $areaname = $dsql->GetOne("select name from #@__area where id=$areaid"); return $areaname['name']; }
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"> <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>
$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(); $row1 = $nsql->getone(); $amoney += $row1['cp_sale'] * $row['number']; $anum += $row['number']; 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>" . $row['r_text'] . "</td><td>" . $row['number'] . "</td><td><a href='current_order_back.php?action=del&id=" . $row['id'] . "&rid=" . $row['rdh'] . "'>删除</a></td></tr>"; $nsql->close(); } } echo "<tr><td> 共计:</td><td></td><td></td><td></td><td> 金额:</td><td>¥" . $amoney . "</td><td align='right'>数量:</td><td>" . $anum . "</td></tr></table>"; $csql->close(); ?> </td> </tr></form>
function getbank($id) { $banksql = new dedesql(false); $banksql->SetQuery("select * from #@__bank where id='{$id}'"); $banksql->Execute(); $bankr = $banksql->gettotalrow(); if ($bankr == 1) { $rs = $banksql->getone(); return $rs['bank_name']; } else { return "<font color=red>已删除银行</font>"; } $banksql->close(); }
<?php require_once dirname(__FILE__) . "/../include/common.inc.php"; require_once DEDEINC . "/channelunit.func.php"; $rili = rili($date, '', true); $db = new dedesql(); $curtime = time(); //获得时间戳 if (empty($date)) { $timestamp = $curtime; $date = date('Y-n-d', $timestamp); } else { $timestamp = strtotime($date); } $selectedyear = date('Y', $timestamp); $selectedmonth = date('n', $timestamp); $selectedday = date('d', $timestamp); $starttime = mktime(0, 0, 0, $selectedmonth, $selectedday, $selectedyear); $endtime = $starttime + 86400; $where = ''; $tid = intval($tid); if ($tid > 0) { $where = " and typeid={$tid}"; } $pagesize = 30; //默认一页30条数据 $maxpages = 9; // $pagepre = 4; //分页用 $pageno = isset($_GET["pageno"]) ? intval($_GET["pageno"]) : 1;
<td><strong> 账务管理</strong> <a href="system_money.php">查看明细账</a></td> </tr> <tr> <td bgcolor="#FFFFFF"><form action="add_money.php?action=save" method="post"> <table width="100%" cellspacing="0" cellpadding="0" border="0" id="table_border"> <tr> <td id="row_style"> 科目:</td> <td> <select name="atype"><option value="收入">收入</option><option value="支出">支出</option></select> </td> </tr> <tr> <td id="row_style"> 银行:</td> <td> <?php $bank = new dedesql(false); $bank->setquery("select * from #@__bank"); $bank->execute(); $r = $bank->gettotalrow(); if ($r == 0) { echo "没有银行供选择,请先<a href='bank.php?action=new'>添加</a>"; } else { echo "<select name='abank'>"; while ($row = $bank->getArray()) { if ($row['bank_default'] == 1) { echo "<option selected value='" . $row['id'] . "'>" . $row['bank_name'] . "</option>"; } else { echo "<option value='" . $row['id'] . "'>" . $row['bank_name'] . "</option>"; } } echo "</select>";