function cashglide($accountid, $allmoney, $chgememo, $chgelisttype, $loginstaname, $listid, $listno, $cogetype, $listdate)
{
$db = new erp_test();
$ishaverecord = 0;
$query = "select * from tb_cashglide where fd_chge_accountid = '{$accountid}' \n\t and fd_chge_listid = '{$listid}' and fd_chge_listtype = '{$chgelisttype}' ";
$db->query($query);
if ($db->nf()) {
$ishaverecord = 1;
}
if ($allmoney != 0 && $ishaverecord == 0) {
$query = "SELECT MAX(fd_chge_id) as chge_id FROM tb_cashglide where \n fd_chge_accountid = '{$accountid}' and fd_chge_iskickback <> 1";
$db->query($query);
if ($db->nf()) {
$db->next_record();
$maxchgeid = $db->f(chge_id);
$query = "select fd_chge_balance from tb_cashglide \n where fd_chge_id = '{$maxchgeid}' ";
$db->query($query);
if ($db->nf()) {
$db->next_record();
$chgebalance = $db->f(fd_chge_balance);
} else {
$chgebalance = 0;
}
} else {
$chgebalance = 0;
}
if ($allmoney != 0) {
//金额不等于0 的才插入数据
if ($cogetype == 0) {
$endchgebalance = $chgebalance + $allmoney;
$query = "insert into tb_cashglide(\n fd_chge_date , fd_chge_accountid , fd_chge_listid , \n fd_chge_listno , fd_chge_listtype , fd_chge_addmoney ,\n fd_chge_lessen , fd_chge_balance , fd_chge_memo ,\n fd_chge_makename , fd_chge_datetime , fd_chge_listdate\n )values(\n now() , '{$accountid}' , '{$listid}' ,\n '{$listno}' , '{$chgelisttype}' , '{$allmoney}' ,\n '0' , '{$endchgebalance}' , '{$chgememo}' ,\n '{$loginstaname}', now() , '{$listdate}'\n )";
$db->query($query);
} else {
$endchgebalance = $chgebalance - $allmoney;
$query = "insert into tb_cashglide(\n fd_chge_date , fd_chge_accountid , fd_chge_listid , \n fd_chge_listno , fd_chge_listtype , fd_chge_addmoney ,\n fd_chge_lessen , fd_chge_balance , fd_chge_memo ,\n fd_chge_makename , fd_chge_datetime , fd_chge_listdate\n )values(\n now() , '{$accountid}' , '{$listid}' ,\n '{$listno}' , '{$chgelisttype}' , '0' ,\n '{$allmoney}' , '{$endchgebalance}' , '{$chgememo}' ,\n '{$loginstaname}', now() , '{$listdate}'\n )";
$db->query($query);
}
}
}
//------------------------------------
}
function makeqx($loginuser)
{
global $loginuserqx;
$db = new erp_test();
$menufile = "http://www.papersystem.cn/ms2011/include/menuarryfile.php";
$menuarry = file($menufile);
//1001±1±地区设置±ico_main_hr.gif±../basic/tb_area_b.php±0±
//1001代号、1为上级代号、地区设置为名称、ico_main_hr.gif为图片
//../basic/tb_area_b.php连接地址、0为是否为最底
$query = "select * from tb_teller \n\t left join tb_usegroup on fd_usegroup_id = fd_tel_usegroupid\n\t where fd_tel_id = '{$loginuser}'";
$db->query($query);
if ($db->nf()) {
$db->next_record();
$str_quanxian = $db->f(fd_tel_doprg);
//该用户所拥有的权限
$str_groupqx = $db->f(fd_usegroup_qx);
//所属于组权限
if (!empty($str_groupqx)) {
//组权限
$tmp_gorupqx = explode("±", $str_groupqx);
for ($i = 0; $i < count($tmp_gorupqx); $i++) {
$tmp_zqxfp = explode("@", $tmp_gorupqx[$i]);
$zqxfp = $tmp_zqxfp[0];
$arr_qxfp[$zqxfp] = 1;
//可执行程序
if (!empty($tmp_zqxfp[1])) {
//可执行权限
$str_optqx = explode("^", $tmp_zqxfp[1]);
//进一步拆分新增等功能
for ($k = 0; $k < count($str_optqx); $k++) {
$tmpoptqx = $str_optqx[$k];
//新增等权限代号
$loginuserqx[$zqxfp][$tmpoptqx] = 1;
//可执行权限
}
}
}
}
if (!empty($str_quanxian)) {
//组权限
$tmp_gorupqx = explode("±", $str_quanxian);
for ($i = 0; $i < count($tmp_gorupqx); $i++) {
$tmp_zqxfp = explode("@", $tmp_gorupqx[$i]);
$zqxfp = $tmp_zqxfp[0];
$arr_qxfp[$zqxfp] = 1;
//可执行程序
if (!empty($tmp_zqxfp[1])) {
//可执行权限
$str_optqx = explode("^", $tmp_zqxfp[1]);
//进一步拆分新增等功能
for ($k = 0; $k < count($str_optqx); $k++) {
$tmpoptqx = $str_optqx[$k];
//新增等权限代号
$loginuserqx[$zqxfp][$tmpoptqx] = 1;
//可执行权限
}
}
}
}
$temp_arrqx = explode("±", $str_quanxian);
}
for ($i = 0; $i < count($temp_arrqx); $i++) {
$tmp_qxfp = explode("@", $temp_arrqx[$i]);
$qxfp = $tmp_qxfp[0];
$arr_qxfp[$qxfp] = 1;
}
//---------------------------------------
for ($i = 0; $i < count($menuarry); $i++) {
$temp_arr1 = $menuarry[$i];
$temp_arr2 = explode("±", $temp_arr1);
$tmpcode = $temp_arr2[0];
if (empty($temp_arr2[1])) {
$arr_prgfcode[$tmpcode][fcode] = 0;
} else {
$arr_prgfcode[$tmpcode][fcode] = $temp_arr2[1];
}
$arr_prgfcode[$tmpcode][isunder] = $temp_arr2[5];
$arr_prgfcode[$tmpcode][level] = $temp_arr2[6];
}
//-------------------------------------
//找出该有的程序
$arr_tmpqx = muqx($arr_qxfp, $arr_prgfcode);
return $arr_tmpqx;
}
