Пример #1
0
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>';
}
Пример #2
0
       </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>
Пример #3
0
 $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;
 }
Пример #4
0
     $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']);
Пример #5
0
?>
</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 
Пример #6
0
    ?>
"><?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) {
Пример #7
0
      <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>
Пример #8
0
        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') {
Пример #9
0
<!--<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>&nbsp;&nbsp;<input type="submit" name="delete" id="button" class="BigButtonBHover" value="删 除"/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php 
echo showpage($num, $pagesize, $page, $url);
Пример #10
0
      </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');
}
?>
Пример #11
0
<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>
Пример #12
0
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>
Пример #13
0
     $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;
 }
Пример #14
0
        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') {
Пример #15
0
</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 ");
Пример #16
0
	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>&nbsp;&nbsp;&nbsp;&nbsp;
	<?php 
echo $mod['modname'];
?>
信息列表</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<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>&nbsp;&nbsp;&nbsp;&nbsp;
	<input type="button" value="新增信息" class="BigButtonBHover" onClick="javascript:window.location='admin.php?ac=modadd&fileurl=<?php 
Пример #17
0
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']);
?>
&nbsp;&nbsp;流程图查看
	</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;
Пример #18
0
}
?>
	  
       </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');
//引入流程
Пример #19
0
?>
       </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>
Пример #20
0
?>
</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>
Пример #21
0
?>
" />
       </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 ");
?>
Пример #22
0
}
?>
	  
       </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>