コード例 #1
0
ファイル: home.php プロジェクト: ColBT/php_tut
    } else {
        headerFunction("home.php?changeProject=true&" . session_name() . "=" . session_id());
    }
}
$bouton[0] = "over";
$titlePage = $strings["welcome"] . " {$nameSession} " . $strings["your_projectsite"];
include "include_header.php";
if ($updateProject != "true" && $changeProject != "true") {
    $tmpquery = "WHERE org.id = '" . fixInt($projectDetail->pro_organization[0]) . "'";
    $clientDetail = new request();
    $clientDetail->openOrganizations($tmpquery);
}
$idStatus = $projectDetail->pro_status[0];
$idPriority = $projectDetail->pro_priority[0];
if ($projectSession == "" || $changeProject == "true") {
    $tmpquery = "WHERE tea.member = '" . fixInt($idSession) . "' AND pro.status IN(0,2,3) AND pro.published = '0' ORDER BY pro.name";
    $listProjects = new request();
    $listProjects->openTeams($tmpquery);
    $comptListProjects = count($listProjects->tea_id);
    $block1 = new block();
    $block1->heading($strings["my_projects"]);
    if ($comptListProjects != "0") {
        echo "\t<table cellspacing='0' width='90%' border='0' cellpadding='3' cols='4' class='listing'>\n\t\t\t\t<tr>\n\t\t\t\t\t<th class='active'>" . $strings["name"] . "</th>\n\t\t\t\t\t<th>" . $strings["organization"] . "</th>\n\t\t\t\t\t<th>" . $strings["priority"] . "</th>\n\t\t\t\t\t<th>" . $strings["status"] . "</th>\n\t\t\t\t</tr>";
        for ($i = 0; $i < $comptListProjects; $i++) {
            if (!($i % 2)) {
                $class = "odd";
                $highlightOff = $block1->oddColor;
            } else {
                $class = "even";
                $highlightOff = $block1->evenColor;
            }
コード例 #2
0
ファイル: addfile.php プロジェクト: ColBT/php_tut
         $send = "false";
     }
 }
 if ($filename != "" && $_FILES['upload']['size'] < $maxFileSize && $_FILES['upload']['size'] != 0 && $send != "false") {
     $docopy = "true";
 }
 if ($docopy == "true") {
     $match = strstr($versionFile, ".");
     if ($match == "") {
         $versionFile = $versionFile . ".0";
     }
     if ($versionFile == "") {
         $versionFile = "0.0";
     }
     $c = convertData($c);
     $tmpquery = "INSERT INTO " . $tableCollab["files"] . "(owner,project,phase,task,comments,upload,published,status,vc_version,vc_parent) VALUES('{$idSession}','{$project}','" . fixInt($phase) . "','{$task}','{$c}','{$dateheure}','1','{$statusField}','{$versionFile}','0')";
     connectSql("{$tmpquery}");
     $tmpquery = $tableCollab["files"];
     last_id($tmpquery);
     $num = $lastId[0];
     unset($lastId);
 }
 if ($task != "0") {
     if ($docopy == "true") {
         uploadFile("files/{$project}/{$task}", $_FILES['upload']['tmp_name'], "{$num}--" . $filename);
         $size = file_info_size("../files/" . $project . "/" . $task . "/" . $num . "--" . $filename);
         //$dateFile = file_info_date("../files/".$project."/".$task."/".$num."--".$filename);
         $chaine = strrev("../files/" . $project . "/" . $task . "/" . $num . "--" . $filename);
         $tab = explode(".", $chaine);
         $extension = strtolower(strrev($tab[0]));
     }
コード例 #3
0
ファイル: edittask.php プロジェクト: ColBT/php_tut
 $tmpquery = $tableCollab["tasks"];
 last_id($tmpquery);
 $num = $lastId[0];
 unset($lastId);
 if ($enableInvoicing == "true") {
     if ($st == "1") {
         $completeItem = "1";
     } else {
         $completeItem = "0";
     }
     $tmpquery = "WHERE project = '{$project}'";
     $detailInvoice = new request();
     $detailInvoice->openInvoices($tmpquery);
     if ($detailInvoice->inv_status[0] == "0") {
         //$tmpquery3 = "INSERT INTO ".$tableCollab["invoices_items"]." SET title='$task_name',description='$d',invoice='".$detailInvoice->inv_id[0]."',created='$dateheure',active='$invoicing',completed='$completeItem',mod_type='1',mod_value='$num',worked_hours='$worked_hours'";
         $tmpquery3 = "INSERT INTO " . $tableCollab["invoices_items"] . " (title,description,invoice,created,active,completed,mod_type,mod_value,worked_hours) VALUES ('{$task_name}','{$d}','" . fixInt($detailInvoice->inv_id[0]) . "','{$dateheure}','{$invoicing}','{$completeItem}','1','{$num}','{$worked_hours}')";
         connectSql($tmpquery3);
     }
 }
 if ($st == "1") {
     $tmpquery6 = "UPDATE " . $tableCollab["tasks"] . " SET complete_date='{$date}' WHERE id = '{$num}'";
     connectSql($tmpquery6);
 }
 //recompute number of completed tasks of the project
 $projectDetail->pro_name[0] = projectComputeCompletion($projectDetail, $tableCollab["projects"]);
 //if assigned_to not blank, set assigned date
 if ($at != "0") {
     $tmpquery6 = "UPDATE " . $tableCollab["tasks"] . " SET assigned='{$dateheure}' WHERE id = '{$num}'";
     connectSql($tmpquery6);
 }
 $tmpquery2 = "INSERT INTO " . $tableCollab["assignments"] . "(task,owner,assigned_to,assigned) VALUES('{$num}','{$idSession}','{$at}','{$dateheure}')";
コード例 #4
0
ファイル: viewnews.php プロジェクト: ColBT/php_tut
} else {
    $block1->noresults();
}
$block1->closeToggle();
$block1->closeFormResults();
$block1->openPaletteScript();
if ($profilSession == "0" || $profilSession == "1" || $profilSession == "5") {
    $block1->paletteScript(0, "add", "../newsdesk/editnews.php?", "true,true,true", $strings["add_newsdesk"]);
    $block1->paletteScript(1, "remove", "../newsdesk/editnews.php?action=remove&id={$id}", "true,false,true", $strings["del_newsdesk"]);
    $block1->paletteScript(3, "edit", "../newsdesk/editnews.php?id={$id}", "true,true,true", $strings["edit_newsdesk"]);
}
$block1->closePaletteScript($comptNewsDetail, $newsDetail->news_id);
///////////////////////////////////////////////////////////////////////////////////
///////////////////////////////// comments block //////////////////////////////////
///////////////////////////////////////////////////////////////////////////////////
$tmpquery = "WHERE newscom.post_id = '" . fixInt($id) . "'";
$newsComments = new request();
$newsComments->openNewsDeskComments($tmpquery);
$comptCommentsDetail = count($newsComments->newscom_id);
$block2 = new block();
$block2->form = "clPrc";
$block2->openForm("../newsdesk/viewnews.php?" . session_name() . "=" . session_id() . "&id={$id}#" . $block2->form . "Anchor");
$block2->headingToggle($strings["comments"]);
$block2->openPaletteIcon();
$block2->paletteIcon(0, "add", $strings["add_newsdesk_comment"]);
$block2->paletteIcon(1, "edit", $strings["edit_newsdesk_comment"]);
if ($profilSession == "0" || $profilSession == "1" || $profilSession == "5") {
    $block2->paletteIcon(2, "remove", $strings["del_newsdesk_comment"]);
}
$block2->closePaletteIcon();
$block1->borne = $blockPage->returnBorne("2");
コード例 #5
0
ファイル: editclient.php プロジェクト: ColBT/php_tut
         $cn = convertData($cn);
         $add = convertData($add);
         $comments = convertData($comments);
         //test if name already exists
         $tmpquery = "WHERE org.name = '{$cn}'";
         $existsClient = new request();
         $existsClient->openOrganizations($tmpquery);
         $comptExistsClient = count($existsClient->org_id);
         if ($comptExistsClient != "0") {
             $error = $strings["organization_already_exists"];
         } else {
             if ($hourly_rate == "") {
                 $hourly_rate = 0.0;
             }
             //insert into organizations and redirect to new client organization detail (last id)
             $tmpquery1 = "INSERT INTO " . $tableCollab["organizations"] . "(name,address1,phone,url,email,comments,created,owner,hourly_rate) VALUES('{$cn}','{$add}','{$client_phone}','{$url}','{$email}','{$c}','{$dateheure}','" . fixInt($cown) . "','{$hourly_rate}')";
             connectSql("{$tmpquery1}");
             $tmpquery = $tableCollab["organizations"];
             last_id($tmpquery);
             $num = $lastId[0];
             unset($lastId);
             $extension = strtolower(substr(strrchr($upload_name, "."), 1));
             if (@move_uploaded_file($upload, "../logos_clients/" . $num . ".{$extension}")) {
                 chmod("../logos_clients/" . $num . ".{$extension}", 0666);
                 $tmpquery = "UPDATE " . $tableCollab["organizations"] . " SET extension_logo='{$extension}' WHERE id='{$num}'";
                 connectSql("{$tmpquery}");
             }
             headerFunction("../clients/viewclient.php?id={$num}&msg=add&" . session_name() . "=" . session_id());
         }
     }
 }
コード例 #6
0
ファイル: library.php プロジェクト: soitun/phpcollab
            $extractDay = substr("{$storedDate}", 8, 2);
            return date("Y-m-d H:i", mktime($extractHour + $gmtUser, $extractMinute, 0, $extractMonth, $extractDay, $extractYear));
        }
    } else {
        return $storedDate;
    }
}
//update sorting table if query sort column
if (!empty($sor_cible) && $sor_cible != "" && $sor_champs != "none") {
    $sor_champs = convertData($sor_champs);
    $sor_cible = convertData($sor_cible);
    $tmpquery = "UPDATE " . $tableCollab["sorting"] . " SET {$sor_cible}='{$sor_champs} {$sor_ordre}' WHERE member = '{$idSession}'";
    connectSql("{$tmpquery}");
}
//set all sorting values for logged user
$tmpquery = "WHERE sor.member = '" . fixInt($idSession) . "'";
$sortingUser = new request();
$sortingUser->openSorting($tmpquery);
/**
 * Convert insert data value in form
 * @param string $data Data to convert
 * @access public
 **/
function convertData($data)
{
    global $databaseType;
    if ($databaseType == "sqlserver") {
        $data = str_replace('"', '&quot;', $data);
        $data = str_replace("'", '&#39;', $data);
        $data = str_replace('<', '&lt;', $data);
        $data = str_replace('>', '&gt;', $data);
コード例 #7
0
ファイル: viewproject.php プロジェクト: ColBT/php_tut
$comptListTasksTime = count($listTasksTime->tas_id);
if ($comptListTasksTime != "0") {
    for ($i = 0; $i < $comptListTasksTime; $i++) {
        $estimated_time = $estimated_time + $listTasksTime->tas_estimated_time[$i];
        $actual_time = $actual_time + $listTasksTime->tas_actual_time[$i];
        if ($listTasksTime->tas_complete_date[$i] != "" && $listTasksTime->tas_complete_date[$i] != "--" && $listTasksTime->tas_due_date[$i] != "--") {
            $diff = diff_date($listTasksTime->tas_complete_date[$i], $listTasksTime->tas_due_date[$i]);
            $diff_time = $diff_time + $diff;
        }
    }
    if ($diff_time > 0) {
        $diff_time = "<b>+{$diff_time}</b>";
    }
}
$teamMember = "false";
$tmpquery = "WHERE tea.project = '{$id}' AND tea.member = '" . fixInt($idSession) . "'";
$memberTest = new request();
$memberTest->openTeams($tmpquery);
$comptMemberTest = count($memberTest->tea_id);
if ($comptMemberTest == "0") {
    $teamMember = "false";
} else {
    $teamMember = "true";
}
if ($teamMember == "false" && $projectsFilter == "true") {
    header("Location:../general/permissiondenied.php?" . session_name() . "=" . session_id());
    exit;
}
if ($enableHelpSupport == "true" && ($teamMember == "true" || $profilSession == "5")) {
    $tmpquery = "WHERE sr.status = '0' AND sr.project = '" . $projectDetail->pro_id[0] . "'";
    $listNewRequests = new request();