function home_workclass($num) { global $db, $_USER; echo '<div id="module_' . $num . '" class="module listColor">'; echo '<div class="head">'; echo '<h4 id="module_' . $num . '_head" class="module_0169c2 color_style_0 moduleHeader">'; echo '<a href="javascript:_resize(' . $num . ');" class="expand expand_arrow" id="img_resize_' . $num . '" title="折叠"></a><span id="module_' . $num . '_text" class="text" onclick="_resize(' . $num . ');">工作流审批</span>'; echo '</h4>'; echo '</div>'; echo '<div id="module_' . $num . '_body" class="module_body">'; echo '<div id="module_' . $num . '_ul" class="module_div">'; $query = $db->query("SELECT a.* FROM " . DB_TABLEPRE . "workclass a," . DB_TABLEPRE . "workclass_personnel b WHERE a.id=b.workid and (b.pertype=0 or b.pertype=4) and b.name like '%" . get_realname($_USER->id) . "%' and a.type!=1 order by b.perid asc"); while ($row = $db->fetch_array($query)) { echo '<ul>'; echo '<li>【'; echo public_value('typename', 'workclass_type', 'tid=' . $row['typeid']); echo '】【'; echo public_value('title', 'workclass_template', 'tplid=' . $row['tplid']); echo '】 <a href="admin.php?ac=list&do=view&fileurl=workclass&workid=' . $row['id'] . '" target="_blank">' . $row['title'] . '</a> <a href="admin.php?ac=list&do=personnel&fileurl=workclass&workid=' . $row['id'] . '"><font color=red>审批>></font></a></li>'; echo '</ul>'; } echo '</div>'; echo '</div>'; echo '</div>'; }
</td> </tr> <tr> <td nowrap class="TableContent">申请人:</td> <td class="TableData"><?php echo get_pubuser(1, 'user', "", "+选择人员", '', 22); ?> </td> <td class="TableContent">供应商名称:<?php get_helps(); ?> </td> <td class="TableData"> <?php if ($_GET['cid'] != '') { echo public_value('title', 'crm_supplier', 'id=' . $_GET['cid']); echo '<input type="hidden" name="cid" value="' . $_GET['cid'] . '" />'; } else { crm_title('选择供应商', 'cname', 'cid', 'crm_supplier', 1); } ?> </td> </tr> </table> <table class="TableBlock" border="0" width="90%" align="center"> <tr> <td nowrap class="TableHeader" colspan="4">产品信息</td> </tr> <tr>
$num = 0; while ($row = $db->fetch_array($query)) { $num++; $archive[] = "<b>" . $row['formname'] . "</b>"; $inputname[] = $row['inputname']; } $archive[] = "<b>业务员</b>"; $archive[] = "<b>发布人</b>"; $archive[] = "<b>发布时间</b>"; $content = array(); $content[] = $archive; $sql = "SELECT * FROM " . DB_TABLEPRE . "crm_care WHERE 1 {$wheresql} ORDER BY id desc"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { $archive = array(); $archive[] = public_value('title', $company, 'id=' . $row['cid']); $archive[] = $row['number']; $archive[] = $row['title']; for ($i = 0; $i < $num; $i++) { $blog = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "crm_db WHERE viewid = '" . $row['id'] . "' and inputname='" . $inputname[$i] . "' and type='crm_care' "); if ($blog['type'] == '3') { $archive[] = str_replace("-", ".", $blog['content']); } else { $archive[] = $blog['content']; } } $archive[] = $row['user']; $archive[] = get_realname($row['uid']); $archive[] = str_replace("-", ".", $row['date']); $content[] = $archive; }
$num++; $archive[] = "<b>" . $row['formname'] . "</b>"; $inputname[] = $row['inputname']; } $archive[] = "<b>指定回访时间</b>"; $archive[] = "<b>电话回访时间</b>"; $archive[] = "<b>回访人员</b>"; $archive[] = "<b>发布人</b>"; $archive[] = "<b>发布时间</b>"; $content = array(); $content[] = $archive; $sql = "SELECT * FROM " . DB_TABLEPRE . "crm_service WHERE 1 {$wheresql} ORDER BY id desc"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { $archive = array(); $archive[] = public_value('title', 'crm_company', 'id=' . $row['cid']); $archive[] = $row['number']; $archive[] = $row['title']; for ($i = 0; $i < $num; $i++) { $blog = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "crm_db WHERE viewid = '" . $row['id'] . "' and inputname='" . $inputname[$i] . "' and type='crm_service' "); if ($blog['type'] == '3') { $archive[] = str_replace("-", ".", $blog['content']); } else { $archive[] = $blog['content']; } } $archive[] = str_replace("-", ".", $row['startdate']); $archive[] = str_replace("-", ".", $row['enddate']); $archive[] = $row['user']; $archive[] = get_realname($row['uid']); $archive[] = str_replace("-", ".", $row['date']);
?> </td> <td class="TableContent" width="15%"> 客户名称:<?php get_helps(); ?> </td> <td class="TableData" width="35%"> <?php if ($_GET['type'] == 1) { $company = 'crm_company'; } else { $company = 'crm_business'; } if ($_GET['cid'] != '') { echo public_value('title', $company, 'id=' . $_GET['cid']); echo '<input type="hidden" name="cid" value="' . $_GET['cid'] . '" />'; } else { crm_title('选择企业', 'cname', 'cid', $company, 1); } ?> </td> </tr> <tr> <td nowrap class="TableContent" width="15%"> 投诉时间:<?php get_helps(); ?> </td> <td class="TableData" width="35%"><input type="text" name="comdate" class="BigInput" size="15" value="<?php
?> "><?php echo $row['title']; ?> </a></td> <td class="TableData"><?php if ($row['type'] == 1) { echo '<font color=red>急件</font>'; } else { echo '普件'; } ?> </td> <!-- <td align="center" class="TableData"><?php echo public_value('name', 'app_type', "id='" . $row['category'] . "'"); ?> </td> --> <td align="center" class="TableData"><?php echo get_realname($row['uid']); ?> </td> <td align="left" class="TableData"> <?php $sql = "SELECT * FROM " . DB_TABLEPRE . "personnel WHERE fileid = '" . $row['id'] . "' and type=1 and (pkey=0 or pkey=2 or pkey=4 or pkey=5) and apptype='" . $row['category'] . "' order by id desc"; $per = $db->fetch_one_array($sql); $perkey = $per['pkey']; if ($per['pkey'] == 5) { echo '<font color=red>流程结束</font>'; } elseif ($per['pkey'] == 2) {
<td class="TableData" width="35%"><?php echo $view['title']; ?> </td> </tr> <tr> <td nowrap class="TableContent">产品价格:</td> <td class="TableData"><span style="font-size:18px; color:#FF0000; font-weight:900;"><?php echo $view['price']; ?> </span>元</td> <td class="TableContent" width="15%">产品分类:</td> <td class="TableData" width="35%"> <?php if ($view['type'] != '') { echo public_value('title', 'crm_pord_type', 'id=' . $view['type']); } ?> </td> </tr> </table> <?php //引入表单 form_view('产品信息', 'crm_product', $view['id']); //引入编辑器 form_view_eweb('crm_product', $view['id']); ?> </div> </form>
if ($dnum < 1) { if ($row['tpltype'] != '1') { get_boxlistkey("id[]", $row['tplid'], $row['uid'], $_USER->id); } else { echo '<input type="checkbox" name="id[]" value="' . $row['tplid'] . '" disabled="disabled" />'; } } else { echo '<input type="checkbox" name="id[]" value="' . $row['tplid'] . '" disabled="disabled" />'; } } else { echo '<input type="checkbox" name="id[]" value="' . $row['tplid'] . '"/>'; } ?> </td> <td align="center" class="TableData"><?php echo public_value('title', 'project_type', " tid='" . $row['typeid'] . "'"); ?> </td> <td class="TableData"> <?php if (file_exists("project/tpl/" . $row['tplid'] . '_' . $row["tpladdr"]) != '') { echo '<img class="v-al-middle" src="template/default/images/newfolder.gif" />'; } echo $row['title']; ?> </td> <td align="center" class="TableData"> <?php if ($row["tplkey"] == '1') { echo '<font color=red>正常</font>'; } elseif ($row["tplkey"] == '2') {
<!--<td class="TableData"><?php echo $row['number']; ?> </td> --> <td class="TableData"><?php echo $row['title']; ?> </td> <td align="center" class="TableData"><?php echo public_value('typename', 'workclass_type', 'tid=' . $row["typeid"]); ?> </td> <td align="center" class="TableData"> <?php echo public_value('title', 'workclass_template', 'tplid=' . $row["tplid"]); ?> </td> </tr> <?php } ?> <tr align="center" class="TableControl"> <td height="35" colspan="9" align="left" nowrap> <input type="checkbox" class="checkbox" value="1" name="chkall" onClick="check_all(this)" /><b>全选</b> <input type="submit" name="delete" id="button" class="BigButtonBHover" value="删 除"/> <?php echo showpage($num, $pagesize, $page, $url);
</td> </tr> <tr> <td nowrap class="TableContent">客户名称:</td> <td class="TableData"> <?php if ($view['sid'] != '') { echo public_value('title', 'crm_supplier', 'id=' . $view['sid']); } ?> </td> <td class="TableContent">采购单:</td> <td class="TableData"> <?php if ($view['perid'] != '') { echo public_value('title', 'crm_purchase', 'id=' . $view['perid']); } ?> </td> </tr> </table> <?php //引入表单 form_view('付款信息', 'crm_payment', $view['id']); //引入编辑器 form_view_eweb('crm_payment', $view['id']); //引入流程 if ($_flow == 1) { echo crm_flow_view($view['id'], 'crm_payment'); } ?>
<div id="navPanel"> <div id="navMenu" style="padding-left:50px;"> <a href="admin.php?ac=<?php echo $ac; ?> &fileurl=<?php echo $fileurl; ?> &do=stock&type=<?php echo $_GET['type']; ?> &id=<?php echo $_GET['pid']; ?> " ><span><img src="template/default/content/images/p3.gif" width="16" height="16" align="absmiddle"><?php echo public_value('title', 'crm_product', 'id=' . $_GET['pid']); ?> </span></a> <a href="admin.php?ac=<?php echo $ac; ?> &fileurl=<?php echo $fileurl; ?> &do=add&type=<?php echo $_GET['type']; ?> &pid=<?php echo $_GET['pid']; ?> " class="active"><span><img src="template/default/content/images/p2.gif" width="16" height="16" align="absmiddle">库存操作</span></a>
echo $view['title']; ?> " /> </td> </tr> <tr> <td nowrap class="TableContent">申请人:</td> <td class="TableData"><?php echo get_pubuser(1, 'user', $view['user'], "+选择人员", '', 22); ?> </td> <td class="TableContent">供应商名称:</td> <td class="TableData"> <?php if ($view['sid'] != '') { echo public_value('title', 'crm_supplier', 'id=' . $view['sid']); } ?> </td> </tr> </table> <table class="TableBlock" border="0" width="90%" align="center"> <tr> <td nowrap class="TableHeader" colspan="4">产品信息</td> </tr> <tr> <td nowrap class="TableContent" style="font-weight:bold;">产品名称</td> <td class="TableContent" width="15%" align="center" style="font-weight:bold;">产品单价</td> <td class="TableContent" width="15%" align="center" style="font-weight:bold;">采购数量</td>
$inputname[] = $row['inputname']; } $archive[] = "<b>发布人</b>"; $archive[] = "<b>发布时间</b>"; $content = array(); $content[] = $archive; $sql = "SELECT * FROM " . DB_TABLEPRE . "crm_contract WHERE 1 {$wheresql} ORDER BY id desc"; $result = $db->query($sql); while ($row = $db->fetch_array($result)) { $archive = array(); $archive[] = public_value('title', 'crm_company', 'id=' . $row['cid']); $archive[] = $row['number']; $archive[] = $row['title']; $archive[] = $row['price']; if ($row['oid'] != '') { $archive[] = public_value('title', 'crm_offer', 'id=' . $row['oid']); } else { $archive[] = ''; } for ($i = 0; $i < $num; $i++) { $blog = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "crm_db WHERE viewid = '" . $row['id'] . "' and inputname='" . $inputname[$i] . "' and type='crm_contract' "); if ($blog['type'] == '3') { $archive[] = str_replace("-", ".", $blog['content']); } else { $archive[] = $blog['content']; } } $archive[] = get_realname($row['uid']); $archive[] = str_replace("-", ".", $row['date']); $content[] = $archive; }
if ($dnum < 1) { if ($row['tpltype'] != '1') { get_boxlistkey("id[]", $row['tplid'], $row['uid'], $_USER->id); } else { echo '<input type="checkbox" name="id[]" value="' . $row['tplid'] . '" disabled="disabled" />'; } } else { echo '<input type="checkbox" name="id[]" value="' . $row['tplid'] . '" disabled="disabled" />'; } } else { echo '<input type="checkbox" name="id[]" value="' . $row['tplid'] . '"/>'; } ?> </td> <td align="center" class="TableData"><?php echo public_value('typename', 'workclass_type', " tid='" . $row['typeid'] . "'"); ?> </td> <td class="TableData"> <?php if (file_exists("workclass/tpl/" . $row['tplid'] . '_' . $row["tpladdr"]) != '') { echo '<img class="v-al-middle" src="template/default/images/newfolder.gif" />'; } echo $row['title']; ?> </td> <td align="center" class="TableData"> <?php if ($row["tplkey"] == '1') { echo '<font color=red>正常</font>'; } elseif ($row["tplkey"] == '2') {
</td> <td class="TableContent" width="15%">代理商:</td> <td class="TableData" width="35%"> <?php if ($view['bid'] != '') { ?> <a href="#" onClick="window.open ('admin.php?ac=business&fileurl=crm&do=view&id=<?php echo $view['bid']; ?> ', '<?php echo $view['bid']; ?> ', 'height=600, width=1000, top=50, left=150, toolbar=no, menubar=no, scrollbars=yes, resizable=yes,location=no, status=no')"> <?php if ($view['bid'] != '') { echo public_value('title', 'crm_business', 'id=' . $view['bid']); } ?> </a> <?php } ?> </td> </tr> </table> <?php //引入表单 form_view('客户信息', 'crm_company', $view['id']); //引入编辑器 form_view_eweb('crm_company', $view['id']); $user = $db->fetch_one_array("SELECT id,name FROM " . DB_TABLEPRE . "crm_contact WHERE type1 = '1' and cid='" . $view['id'] . "' and type=1 ");
type="submit" value="查 询" class="SmallButton" /> </form> </div> <table width="98%" border="0" align="center" cellpadding="3" cellspacing="0" class="small"> <tr> <td class="Big" style="font-size:12px;"><img src="template/default/content/images/notify_new.gif" align="absmiddle"><span class="big3"> <a href="admin.php?ac=list&do=view&fileurl=<?php echo $fileurl; ?> &projectid=<?php echo $projectid; ?> "><?php echo public_value('title', 'project', 'id=' . $projectid); ?> </a> <?php echo $mod['modname']; ?> 信息列表</span> <span style="font-size:12px; float:right; margin-right:50px;"> <a href="admin.php?ac=list&fileurl=<?php echo $fileurl; ?> &do=view&projectid=<?php echo $projectid; ?> " style="font-size:12px;"><< 返回项目管理</a> <input type="button" value="新增信息" class="BigButtonBHover" onClick="javascript:window.location='admin.php?ac=modadd&fileurl=<?php
em; <?php echo $background; ?> } <?php } ?> </style> <title>Office 515158 2011 OA办公系统</title> </head> <body class="bodycolor"> <table width="90%" border="0" align="center" cellpadding="3" cellspacing="0" class="small"> <tr> <td class="Big" style="font-size:12px;"><img src="template/default/content/images/notify_new.gif" align="absmiddle"><span class="big3"> <?php echo public_value('title', 'workclass_template', 'tplid=' . $_GET['tplid']); ?> 流程图查看 </span> </td> </tr> </table> <div class="demo flowchart-demo" id="flowchart-demo"> <?php $n = 0; foreach ($result as $row) { $n++; ?> <div class="window" id="flowchartWindow<?php echo $n;
} ?> </td> </tr> <tr> <td nowrap class="TableContent" width="15%"> </td> <td class="TableData" width="35%"></td> <td class="TableContent" width="15%"> 报价单:</td> <td class="TableData" width="35%"> <?php if ($_GET['cid'] != '') { echo public_value('title', 'crm_offer', 'id=' . $_GET['oid']); echo '<input type="hidden" name="oid" value="' . $_GET['oid'] . '" />'; } else { crm_title('选择报价单', 'oname', 'oid', 'crm_offer', 1); } ?> </td> </tr> </table> <?php //引入表单 form_add('订单信息', 'crm_order'); //引入编辑器 form_add_eweb('crm_order'); //引入流程
?> </td> </tr> <tr> <td nowrap class="TableContent" width="15%"> 指定回访时间:</td> <td class="TableData" width="35%"><?php echo $view['startdate']; ?> </td> <td class="TableContent" width="15%"> 回访客户:</td> <td class="TableData" width="35%"> <?php if ($view['cid'] != '') { echo public_value('title', 'crm_company', 'id=' . $view['cid']); } ?> </td> </tr> <tr> <td nowrap class="TableContent" width="15%"> 回访人员:</td> <td class="TableData" width="35%"><?php echo $view['user']; ?> </td> <td class="TableContent" width="15%"> 回访时间:</td>
?> </td> <td class="TableContent" width="15%"> 客户名称:<?php get_helps(); ?> </td> <td class="TableData" width="35%"> <?php if ($view['type'] == 1) { $company = 'crm_company'; } else { $company = 'crm_business'; } if ($view['cid'] != '') { echo public_value('title', $company, 'id=' . $view['cid']); } ?> </td> </tr> <tr> <td nowrap class="TableContent" width="15%"> 投诉时间:<?php get_helps(); ?> </td> <td class="TableData" width="35%"><input type="text" name="comdate" class="BigInput" size="15" value="<?php echo $view['comdate']; ?> " onClick="WdatePicker();"/></td>
?> " /> </td> </tr> <tr> <td nowrap class="TableContent">代理商价格:</td> <td class="TableData"> <?php echo get_pubuser(1, 'user', $view['user'], "+选择人员", '', 22); ?> </td> <td class="TableContent">上级代理:</td> <td class="TableData"> <?php if ($view['bid'] != '') { crm_title('选择代理商', 'cname', 'bid', 'crm_business', 1, $view['bid'], public_value('title', 'crm_business', 'id=' . $view['bid'])); } else { crm_title('选择代理商', 'cname', 'bid', 'crm_business', 1); } ?> </td> </tr> </table> <?php //引入表单 form_edit('代理商信息', 'crm_business', $view['id']); //引入编辑器 form_edit_eweb('crm_business', $view['id']); $user = $db->fetch_one_array("SELECT id,name FROM " . DB_TABLEPRE . "crm_contact WHERE type1 = '1' and cid='" . $view['id'] . "' and type=2 "); ?>
} ?> </td> </tr> <tr> <td nowrap class="TableContent" width="15%"> 报价单:</td> <td class="TableData" width="35%"> <?php if ($_GET['cid'] != '') { echo public_value('title', 'crm_offer', 'id=' . $_GET['oid']); echo '<input type="hidden" name="oid" value="' . $_GET['oid'] . '" />'; } else { if ($view['oid'] != '') { crm_title('选择报价单', 'oname', 'oid', 'crm_offer', 1, $view['oid'], public_value('title', 'crm_offer', 'id=' . $view['oid'])); } else { crm_title('选择报价单', 'oname', 'oid', 'crm_offer', 1); } } ?> </td> <td class="TableContent" width="15%"> </td> <td class="TableData" width="35%"> </td> </tr> </table>