function checkProject($project_name)
{
$user = getAdmin();
$query = queryProject($project_name);
if ($query == NULL) {
addProject($project_name);
$query = queryProject($project_name);
}
# return phid
$project = $query;
return $project;
}
<?php
include "../util/DbUtil.php";
session_start();
$projectName = mysql_real_escape_string($_POST['projectName']);
$isPrivate = $_POST['isPrivate'];
//Response will be json.
$formattableResponse = '{ "status":"%s", "projectId":%d, "projectName":"%s" }';
$response = "";
$projectId = null;
if (strlen($projectName) > 50) {
$response = sprintf($formattableResponse, "Project Name too long.", 0, "");
} else {
$db_conn = getConnectedDb();
if (is_null($db_conn)) {
$response = sprintf($formattableResponse, "Error connecting to database", 0, "");
} elseif (projectExists($db_conn, $projectName)) {
$response = sprintf($formattableResponse, "Project already exists", 0, "");
} elseif (is_null($projectId = addProject($db_conn, $projectName, $isPrivate, $_SESSION['userid']))) {
$response = sprintf($formattableResponse, "Unknown error occurred.", 0, "");
} else {
$response = sprintf($formattableResponse, "success", $projectId, $projectName);
}
}
echo $response;
<?php
require_once dirname(__FILE__) . "/../../../include/master.inc.php";
$error = "";
$success = "";
if (!isLogin()) {
redirect(BASEURL . "app/login.php");
}
if (isset($_POST['save'])) {
if (strlen($_POST['name']) < 2) {
$error = "Project Name Too Short.";
} else {
if (!addProject($_SESSION['user']['id'], $_POST['name'])) {
$error = "Something went wrong. Please refresh and try again!";
} else {
$success = "Successfully Added!";
}
}
} else {
$error = "Invalid Request";
}
$_SESSION['response']['project-add']['error'] = $error;
$_SESSION['response']['project-add']['success'] = $success;
redirect(BASEURL . "app/project-add.php");
}
if (!isset($_GET['step'])) {
$step = 0;
} else {
$step = intval($_GET['step']);
}
if (isset($_GET['id'])) {
$id = intval($_GET['id']);
} else {
$id = 0;
}
if ($id) {
$project = getProjectById($id);
}
if ($step == 2 && !$id && isset($_POST['save_project'])) {
$id = addProject($_POST);
redirect('upload.php?step=2&id=' . $id);
} else {
if ($step && $id && isset($_POST['save_project'])) {
updateProject($_POST, $id, $step);
}
}
?>
<div class="inner-page-wrapper">
<div class="upload inner-page content">
<?php
include DIR_INCLUDE . 'left_nav.php';
?>
<?php
include_once "conn.php";
include_once "projectDB.php";
include_once "budgetDB.php";
$action = $_REQUEST["action"];
$res = "";
switch ($action) {
case "addProject":
$res = addProject($_REQUEST);
break;
case "delProject":
$res = delProject($_REQUEST["projectId"]);
break;
case "editProject":
case "editproject":
case "editProjectHeadInfo":
$res = editProject($_REQUEST);
break;
case "editProjectByProjectName":
$res = editProjectByProjectName($_REQUEST);
break;
case "getProjectsByProjectId":
case "getprojectbyid":
$res = getProjectsByProjectId($_REQUEST['projectId']);
break;
case "getProjectNames":
$res = getProjectNames();
break;
case "getProjectYears":
$visitorName = $_SESSION["name"];
// liaison
$lastProjectId = $db->lastInsertId();
error_log('project_created' . $lastProjectId);
// link project / user
$link_result = linkItems("lo_users_projects", "id_user", $_SESSION['id_user'], "id_project", $lastProjectId);
if ($link_result == false) {
return 0;
}
// creation d'une categorie Todo par défaut
$defaultCategoryResult = addDefaultCategory($lastProjectId);
}
return $link_result && $defaultCategoryResult ? $lastProjectId : 0;
}
}
if (isset($_POST['project_name'])) {
$newProjectId = addProject($_POST['project_name']);
if ($newProjectId > 0) {
// si l'ajout à fonctionné on redirige vers la page home en pré-selectionnant le nouveau projet
header('location:../home.php?selected_project=' . $newProjectId);
} else {
header('location:' . $_SERVER['PHP_SELF']);
}
}
?>
<?php
echo_head();
?>
<?php
echo_topbar();
break;
default:
$results["meta"] = methodNotAllowed($method, $path);
}
break;
case "projects":
switch ($method) {
case "GET":
if (isset($path[1]) && trim($path[1]) !== "") {
$results = getProject($path[1]);
} else {
$results = getProjects($data);
}
break;
case "POST":
$results = addProject($data);
break;
case "PATCH":
if (isset($path[1]) && trim($path[1]) !== "") {
$data["projectID"] = $path[1];
}
$results = editProject($data);
break;
case "DELETE":
if (isset($path[1]) && trim($path[1]) !== "") {
$data["projectID"] = $path[1];
}
$results = deleteProject($data);
break;
default:
$results["meta"] = methodNotAllowed($method, $path);
function transferBusinessToProject($data)
{
global $mysql;
//必须字段
$businessId = $data['businessId'];
$obj = array('customer' => $data['customer'], "businessId" => $businessId);
//可选字段
$fields = array("projectTime", "projectName", "designer", "designerName", "captain", "captainName", "salesman", "supervisor", "supervisorName", "salesmanName");
foreach ($fields as $field) {
if (isset($data[$field])) {
$obj[$field] = $data[$field];
}
}
if (isset($data["startTime"])) {
$obj["period"] = $data["startTime"];
} else {
$obj["period"] = "";
}
if (isset($data["endTime"])) {
$obj["period"] = $obj["period"] . ":" . $data["endTime"];
}
include_once "projectDB.php";
$res = addProject($obj);
$mysql->DBUpdate('business', array('isTransfered' => 'true', 'updateTime' => 'now()', 'applyProjectTransference' => 2), "`id`='?'", array($businessId));
return array('status' => 'successful', 'errMsg' => '', 'projectId' => $res['projectId']);
}
