if (empty($_POST['project_end'])) { $_POST['project_end'] = '0000-00-00'; } if (isset($_POST["MM_insert"]) && $_POST["MM_insert"] == "form1") { $insertSQL = sprintf("INSERT INTO tk_project (project_name, project_code, project_text, project_start, project_end, project_to_user, project_status, project_from, project_from_user, project_to_dept, project_remark, project_from_contact) VALUES (%s, {$project_code} {$project_text} %s, %s, %s, %s, '', %s, '', '', '')", GetSQLValueString($_POST['project_name'], "text"), GetSQLValueString($_POST['project_start'], "date"), GetSQLValueString($_POST['project_end'], "date"), GetSQLValueString($_POST['project_to_user'], "text"), GetSQLValueString($_POST['project_status'], "text"), GetSQLValueString($_SESSION['MM_uid'], "text")); mysql_select_db($database_tankdb, $tankdb); $Result1 = mysql_query($insertSQL, $tankdb) or die(mysql_error()); $newID = mysql_insert_id(); $insertGoTo = "project_view.php?recordID={$newID}"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= strpos($insertGoTo, '?') ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } $user_arr = get_user_select(); mysql_select_db($database_tankdb, $tankdb); $query_Recordset3 = "SELECT * FROM tk_status_project ORDER BY task_status_pbackup1 ASC"; $Recordset3 = mysql_query($query_Recordset3, $tankdb) or die(mysql_error()); $row_Recordset3 = mysql_fetch_assoc($Recordset3); $totalRows_Recordset3 = mysql_num_rows($Recordset3); require 'head.php'; ?> <link type="text/css" href="skin/themes/base/ui.all.css" rel="stylesheet" /> <link href="skin/themes/base/lhgcheck.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="srcipt/lhgcore.js"></script> <script type="text/javascript" src="srcipt/lhgcheck.js"></script> <link rel="stylesheet" href="bootstrap/css/bootstrap-multiselect.css" type="text/css"/> <script type="text/javascript" src="bootstrap/js/bootstrap-multiselect.js"></script> <link rel="stylesheet" href="bootstrap/css/datepicker3.css" type="text/css"/> <script type="text/javascript" src="bootstrap/js/bootstrap-datepicker.js"></script>
</select> </div> <input name="selected_project_Director" type="hidden" id="selected_project_Director" /> <span class="help-block"><?php echo $multilingual_personSelect_tips; ?> </span> </div> <!--填写项目主管主任工程师--> <div class="form-group col-xs-12" > <label for="project_Division_engineer" >项目主管主任工程师<span id="project_Division_engineer_msg" ></span></label> <div> <select name="project_Division_engineer" id="project_Division_engineer" multiple="multiple"> //class="form-control"> <?php foreach (get_user_select(40) as $key => $val) { ?> <option value='<?php echo $val["uid"]; ?> ' <?php if (in_array($val["uid"], explode(',', $row_Recordset1['project_Division_engineer']))) { echo "selected=\"selected\""; } ?> ><?php $py = strtoupper(substr($val["pinyin"], 0, 1)); echo $py . "-" . $val["name"]; ?> </option> <?php
<?php require_once 'config/tank_config.php'; $getjson = file_get_contents('php://input'); $dataarr = json_decode($getjson, true); $token = $dataarr['token']; $task_id = $dataarr['taskid']; $uid = check_token($token); if ($uid != 3) { mysql_select_db($database_tankdb, $tankdb); $query_Recordset_task = sprintf("SELECT *, \ntk_project.id as proid \nFROM tk_task \ninner join tk_project on tk_task.csa_project=tk_project.id \nWHERE TID = %s", GetSQLValueString($task_id, "int")); $Recordset_task = mysql_query($query_Recordset_task, $tankdb) or die(mysql_error()); $row_Recordset_task = mysql_fetch_assoc($Recordset_task); $get_type = get_task_type(); $get_status = get_task_status(); $get_user = get_user_select(); $data = array(); $data["tasktitle"] = $row_Recordset_task['csa_text']; $data["type"] = $get_type; $data["status"] = $get_status; $data["user"] = $get_user; $redata = json_encode($data); echo $redata; } else { echo 3; }
$msg_from = $_POST['csa_create_user']; $msg_type = "newtask"; $msg_id = $newID; $msg_title = $title; $mail = send_message($msg_to, $msg_from, $msg_type, $msg_id, $msg_title); if ($_POST['user_cc'] != null) { $cc_arr = json_decode($cc_post, true); foreach ($cc_arr as $k => $v) { send_message($v['uid'], $msg_from, $msg_type, $msg_id, $msg_title, 1); } } header(sprintf("Location: %s", $insertGoTo)); } $user_arr = get_user_select(); // wangzi add $user_arr_do = get_user_select(); mysql_select_db($database_tankdb, $tankdb); $query_Recordset_type = "SELECT * FROM tk_task_tpye ORDER BY task_tpye_backup1 ASC"; $Recordset_type = mysql_query($query_Recordset_type, $tankdb) or die(mysql_error()); $row_Recordset_type = mysql_fetch_assoc($Recordset_type); $totalRows_Recordset_type = mysql_num_rows($Recordset_type); mysql_select_db($database_tankdb, $tankdb); $query_Recordset_project = sprintf("SELECT * FROM tk_project WHERE id = %s", GetSQLValueString($project_id, "int")); $Recordset_project = mysql_query($query_Recordset_project, $tankdb) or die(mysql_error()); $row_Recordset_project = mysql_fetch_assoc($Recordset_project); $totalRows_Recordset_project = mysql_num_rows($Recordset_project); mysql_select_db($database_tankdb, $tankdb); $query_tkstatus = "SELECT * FROM tk_status WHERE task_status_backup2 <>1 ORDER BY task_status_backup1 ASC"; $tkstatus = mysql_query($query_tkstatus, $tankdb) or die(mysql_error()); $row_tkstatus = mysql_fetch_assoc($tkstatus); $totalRows_tkstatus = mysql_num_rows($tkstatus);
<?php require_once 'config/tank_config.php'; $getjson = file_get_contents('php://input'); $dataarr = json_decode($getjson, true); $token = $dataarr['token']; $uid = check_token($token); if ($uid != 3) { $get_function = get_user_select(); $redata = json_encode($get_function); echo $redata; } else { echo 3; }