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>";
