function printProjects()
{
$row = 1;
foreach (getProjects() as $project) {
echo '<a href="/projects/view/' . $project['project_id'] . '"><div class="project_thumb">';
$img = '<img src="' . getProjectImage($project['project_id']) . '" />';
$text = '<div><h2>' . $project['project_name'] . '</h2><p class="subtitle">' . $project['project_description'] . '</p></div>';
echo $row > 0 ? $img . $text : $text . $img;
echo '</div>';
$row *= -1;
}
}
function getFilters()
{
$statusItems = getStatusData();
$filters['taskStatus'] = $statusItems;
//Get Who
$people = getPeopleData();
$filters['assigned'] = $people;
//Get All (now just staff later all)
$filters['people'] = $people;
//Projects
$projects = getProjects();
$filters['projects'] = $projects;
//Levels
$levels = getLevels();
$filters['levels'] = $levels;
echo json_encode($filters);
}
Utils::validateAPIKey();
checkRemovableProjects();
break;
case 'setFavorite':
setFavorite();
break;
case 'getBonusHistory':
getBonusHistory();
break;
case 'getMultipleBidList':
getMultipleBidList();
break;
case 'getProjects':
$userId = isset($_SESSION['userid']) ? $_SESSION['userid'] : 0;
$currentUser = User::find($userId);
getProjects(!$currentUser->isInternal());
break;
case 'getUserList':
getUserList();
break;
case 'getUsersList':
getUsersList();
break;
case 'payBonus':
payBonus();
break;
case 'pingTask':
pingTask();
break;
case 'userReview':
userReview();
$startDate = $processDate;
$endDate = $processDate;
foreach ($dimensions as $key => $value) {
print_r("---DIMENSIONS---" . json_encode($value));
$result = $client->get_statistics(array('format' => 'json', 'account_id' => $account_id, 'dimensions' => json_encode($value), 'metrics' => json_encode(array('impression', 'click', 'click_rate', 'reach_impression', 'total_cost', 'confirmed_tracked_conversion', 'expand', 'event', 'average_expand_time', 'pageview', 'average_visibility_time', 'progress_100', 'progress_50', 'user_play', 'close', 'impression_adwords', 'click_adwords', 'cost_adwords', 'bounce_rate', 'average_time_spent_on_site', 'cost_per_pageview')), 'start_date' => $processDate, 'end_date' => $processDate));
echo '<pre>';
////print_r($result->headers);
//print_r($result);
//die();
/*
************* METADATA **************
*/
$adspacesMeta = getAdspaces($mysqli);
$campaignsMeta = getCampaigns($mysqli);
$channelsMeta = getChannels($mysqli);
$projectsMeta = getProjects($mysqli);
$creativesMeta = getCreatives($mysqli);
$adnetworksMeta = getAdnetworks($mysqli);
$insertionsMeta = getInsertions($mysqli);
$agesMeta = getAges($mysqli);
$ispsMeta = getIsps($mysqli);
$opsMeta = getOps($mysqli);
$browsersMeta = getBrowsers($mysqli);
$socialsMeta = getSocials($mysqli);
$gendersMeta = getGenders($mysqli);
$GLOBALS["metrics"] = getMetrics($mysqli);
$metrics = $GLOBALS["metrics"];
/*
$metadata = $result->body->metadata;
foreach ($metadata as $key => $value) {
//print_r($key.'/');
?>
<h2>Käyttäjän <?php
echo $username->username;
?>
portfolio</h2>
<?php
}
?>
<?php
if (getProjects($username->uid, $DBH) == NULL) {
?>
<p>Ei projekteja.</p>
<?php
}
$projektit = getProjects($username->uid, $DBH);
foreach ($projektit as $projekti) {
?>
<a href="<?php
echo SITE_ROOT;
?>
/?portfolio=<?php
echo $username->username;
?>
&projekti=<?php
echo $projekti->pid;
?>
">
<div class="polaroid">
<img src="img/<?php
echo $username->username;
<?php
require_once 'settings.php';
if ($_SERVER['REQUEST_METHOD'] == "GET") {
if (!empty($_GET['id'])) {
echo json_encode(getProject($_GET['id']));
} else {
echo json_encode(getProjects());
}
}
if ($_SERVER['REQUEST_METHOD'] == "POST") {
// $json = file_get_contents('php://input');
// if($_SERVER['HTTP_X_HTTP_METHOD_OVERRIDE'] == 'PUT') {
// //This is an UPDATE call
// if(!empty($json))
// return json_encode(updatePrice());
// }
// elseif($_SERVER['HTTP_X_HTTP_METHOD_OVERRIDE'] == 'DELETE') {
// //This is a DELETE call
// // die($json);
// if(!empty($_GET['id'] && !empty($_GET['quantity'])))
// return json_encode(deletePriceFromQuantity($_GET['id'], $_GET['quantity']));
// }
// else {
// //This is an ADD call
// if(!empty($json))
// return json_encode(addPrice());
// }
}
function getProject($id)
{
/**
* @param $start int
* @param $step int
* @param $search_in_pname string|null
* @param $search_source string|null
* @param $search_target string|null
* @param $search_status string|null
* @param $search_onlycompleted bool
* @param $filter_enabled bool
* @param $project_id int
*
* @return array
* @throws Exception
*/
public static function queryProjects($start, $step, $search_in_pname, $search_source, $search_target, $search_status, $search_onlycompleted, $filter_enabled, $project_id)
{
$data = getProjects($start, $step, $search_in_pname, $search_source, $search_target, $search_status, $search_onlycompleted, $filter_enabled, $project_id);
$projects = array();
$projectIDs = array();
$project2info = array();
//get project IDs from projects array
foreach ($data as $item) {
$projectIDs[] = $item['pid'];
}
if (empty($projectIDs)) {
return array();
}
//get job data using job IDs
$jobData = getJobsFromProjects($projectIDs, $search_source, $search_target, $search_status, $search_onlycompleted);
$lang_handler = Langs_Languages::getInstance();
//Prepare job data
$project2jobChunk = array();
foreach ($jobData as $job_array) {
$job = array();
/**
* Assign job extracted variables
*/
$job['id'] = $job_array['id'];
$job['pid'] = $job_array['id_project'];
$job['password'] = $job_array['password'];
$job['source'] = $job_array['source'];
$job['target'] = $job_array['target'];
$job['subject'] = $job_array['subject'];
$job['sourceTxt'] = $lang_handler->getLocalizedName($job['source']);
$job['targetTxt'] = $lang_handler->getLocalizedName($job['target']);
$job['create_date'] = $job_array['create_date'];
$job['formatted_create_date'] = self::formatJobDate($job_array['create_date']);
$job['job_first_segment'] = $job_array['job_first_segment'];
$job['job_last_segment'] = $job_array['job_last_segment'];
$job['mt_engine_name'] = $job_array['name'];
$job['id_tms'] = $job_array['id_tms'];
//generate and set job stats
$jobStats = new WordCount_Struct();
$jobStats->setDraftWords($job_array['DRAFT']);
$jobStats->setRejectedWords($job_array['REJECT']);
$jobStats->setTranslatedWords($job_array['TRANSLATED']);
$jobStats->setApprovedWords($job_array['APPROVED']);
//These would be redundant in response. Unset them.
unset($job_array['DRAFT']);
unset($job_array['REJECT']);
unset($job_array['TRANSLATED']);
unset($job_array['APPROVED']);
$job['stats'] = CatUtils::getFastStatsForJob($jobStats);
//generate and set job tm_keys
$tm_keys_json = $job_array['tm_keys'];
$tm_keys_json = TmKeyManagement_TmKeyManagement::getOwnerKeys(array($tm_keys_json));
$tm_keys = array();
foreach ($tm_keys_json as $tm_key_struct) {
/**
* @var $tm_key_struct TmKeyManagement_TmKeyStruct
*/
$tm_keys[] = array("key" => $tm_key_struct->key, "r" => $tm_key_struct->r ? 'Lookup' : ' ', "w" => $tm_key_struct->w ? 'Update' : '');
}
$job['private_tm_key'] = json_encode($tm_keys);
$job['disabled'] = $job_array['status_owner'] == Constants_JobStatus::STATUS_CANCELLED ? "disabled" : "";
$job['status'] = $job_array['status_owner'];
//These vars will be used in projects loop for some flag evaluation.
$project2info[$job['pid']]['status'][] = $job['status'];
$project2info[$job['pid']]['mt_engine_name'] = $job['mt_engine_name'];
$project2info[$job['pid']]['id_tms'] = $job['id_tms'];
$project2jobChunk[$job['pid']][$job['id']][$job['job_first_segment']] = $job;
}
//Prepare project data
foreach ($data as $item) {
$project = array();
$project['id'] = $item['pid'];
$project['name'] = $item['name'];
$project['jobs'] = array();
$project['no_active_jobs'] = true;
$project['has_cancelled'] = 0;
$project['has_archived'] = 0;
$project['password'] = $item['password'];
$project['tm_analysis'] = number_format($item['tm_analysis_wc'], 0, ".", ",");
$project['jobs'] = $project2jobChunk[$project['id']];
$project['no_active_jobs'] = $project['no_active_jobs'] ? ' allCancelled' : '';
$project2info[$project['id']]['status'] = array_unique($project2info[$project['id']]['status']);
$project['no_active_jobs'] = !in_array(Constants_JobStatus::STATUS_ACTIVE, $project2info[$project['id']]['status']) ? ' allCancelled' : '';
$project['has_cancelled'] = in_array(Constants_JobStatus::STATUS_CANCELLED, $project2info[$project['id']]['status']);
$project['has_archived'] = in_array(Constants_JobStatus::STATUS_ARCHIVED, $project2info[$project['id']]['status']);
$project['mt_engine_name'] = $project2info[$project['id']]['mt_engine_name'];
$project['id_tms'] = $project2info[$project['id']]['id_tms'];
$projects[] = $project;
}
return $projects;
}
function createCurrentMonthData()
{
error_log('create current month data');
$db = db();
$config = config();
// delete data for previous month
error_log('clear previous month data');
$db->beginTransaction();
$db->prepare('delete from monthlyresults_google
where checkdate < date_format(date_sub(now(), interval 1 day), "%Y-%m-01")
')->execute();
$db->prepare('delete from monthlyresults_mail
where checkdate < date_format(date_sub(now(), interval 1 day), "%Y-%m-01")
')->execute();
$db->prepare('delete from monthlyresults_yandex
where checkdate < date_format(date_sub(now(), interval 1 day), "%Y-%m-01")
')->execute();
$db->commit();
error_log('create stat file');
$selectMonthStat = [];
$selectMonthStat['google'] = $db->prepare('
select * from monthlyresults_google
where project = ?
');
$selectMonthStat['mail'] = $db->prepare('
select * from monthlyresults_mail
where project = ?
');
$selectMonthStat['yandex'] = $db->prepare('
select * from monthlyresults_yandex
where project = ?
');
$monthDays = date('t');
$todayPrefix = date('Y-m-');
$fieldSep = ';';
foreach (getProjects() as $project) {
$statDir = DATA_PATH . '/stat/' . $project['name'];
// make dir for project stat
if (!is_dir($statDir)) {
mkdir($statDir);
}
$statFile = $statDir . '/' . $project['name'] . '_' . $todayPrefix . '01.csv';
if (file_exists($statFile)) {
unlink($statFile);
}
if ($fp = fopen($statFile, 'w')) {
foreach ($selectMonthStat as $checkerName => $checkerStat) {
$monthStat = [];
$checkerStat->execute([$project['name']]);
// fill data by keyword, date
foreach ($checkerStat as $row) {
if ($checkerName == 'yandex') {
$monthStat[$row->region_name][$row->keyword][$row->checkdate] = $row->pos;
} else {
$monthStat['single'][$row->keyword][$row->checkdate] = $row->pos;
}
}
//print_r($monthStat);
// create stat table
foreach ($monthStat as $region => $nextMonthStat) {
// header
fwrite($fp, $checkerName . ($checkerName == 'yandex' ? ' ' . $region : '') . $fieldSep);
foreach (range(1, $monthDays) as $day) {
fwrite($fp, ($day < 10 ? '0' . $day : $day) . $fieldSep);
}
fwrite($fp, PHP_EOL);
// keywords positions
foreach ($project['keywords'] as $keyword) {
fwrite($fp, $keyword . $fieldSep);
if (isset($nextMonthStat[$keyword])) {
foreach (range(1, $monthDays) as $day) {
$sday = $todayPrefix . ($day < 10 ? '0' . $day : $day);
fwrite($fp, (isset($nextMonthStat[$keyword][$sday]) ? $nextMonthStat[$keyword][$sday] : '0') . $fieldSep);
}
}
fwrite($fp, PHP_EOL);
}
fwrite($fp, PHP_EOL);
}
}
// end foreach checker
fclose($fp);
} else {
error_log("Can't create file " . $statFile);
}
}
// end foreach project
}
global $AppUI, $cal_sdf;
$AppUI->loadCalendarJS();
$project_id = (int) w2PgetParam($_GET, 'project_id', 0);
$company_id = (int) w2PgetParam($_GET, 'company_id', $AppUI->user_company);
$contact_id = (int) w2PgetParam($_GET, 'contact_id', 0);
$perms =& $AppUI->acl();
// check permissions for this record
$canEdit = $perms->checkModuleItem('projects', 'edit', $project_id);
$canAuthor = $perms->checkModuleItem('projects', 'add');
if (!$canEdit && $project_id > 0 || !$canAuthor && $project_id == 0) {
$AppUI->redirect('m=public&a=access_denied');
}
$pstatus = w2PgetSysVal('ProjectStatus');
$ptype = w2PgetSysVal('ProjectType');
$project = new CProject();
$structprojs = getProjects();
$structprojs = $project->getAllowedProjects($AppUI->user_id, false);
unset($structprojs[$project_id]);
$structprojs = array_map('temp_filterArrayForSelectTree', $structprojs);
$structprojects = arrayMerge(array('0' => array(0 => 0, 1 => '(' . $AppUI->_('No Parent') . ')', 2 => '')), $structprojs);
// get a list of permitted companies
$company = new CCompany();
$companies = $company->getAllowedRecords($AppUI->user_id, 'company_id,company_name', 'company_name');
$companies = arrayMerge(array('0' => ''), $companies);
// load the record data
$obj = $AppUI->restoreObject();
if ($obj) {
$project = $obj;
$project_id = $project->project_id;
} else {
$project->loadFull($AppUI, $project_id);
$startDate = $processDate;
$endDate = $processDate;
foreach ($dimensions as $key => $value) {
print_r("---DIMENSIONS---" . json_encode($value));
$result = $client->get_statistics(array('format' => 'json', 'account_id' => $account_id, 'dimensions' => json_encode($value), 'metrics' => json_encode(array('impression', 'click', 'click_rate', 'reach_impression', 'total_cost', 'confirmed_tracked_conversion', 'expand', 'event', 'average_expand_time', 'pageview', 'average_visibility_time', 'progress_100', 'progress_50', 'user_play', 'close', 'impression_adwords', 'click_adwords', 'cost_adwords', 'bounce_rate', 'average_time_spent_on_site', 'cost_per_pageview')), 'start_date' => $processDate, 'end_date' => $processDate));
echo '<pre>';
////print_r($result->headers);
//print_r($result);
//die();
/*
************* METADATA **************
*/
$adspacesMeta = getAdspaces($connSqlsrv);
$campaignsMeta = getCampaigns($connSqlsrv);
$channelsMeta = getChannels($connSqlsrv);
$projectsMeta = getProjects($connSqlsrv);
$creativesMeta = getCreatives($connSqlsrv);
$adnetworksMeta = getAdnetworks($connSqlsrv);
$insertionsMeta = getInsertions($connSqlsrv);
$agesMeta = getAges($connSqlsrv);
$ispsMeta = getIsps($connSqlsrv);
$opsMeta = getOps($connSqlsrv);
$browsersMeta = getBrowsers($connSqlsrv);
$socialsMeta = getSocials($connSqlsrv);
$gendersMeta = getGenders($connSqlsrv);
$GLOBALS["metrics"] = getMetrics($connSqlsrv);
$metrics = $GLOBALS["metrics"];
$metadata = $result->body->metadata;
foreach ($metadata as $key => $value) {
//print_r($key.'/');
foreach ($value as $idWeborama => $arrValues) {
<?php
include_once "analyticstracking.php";
include "../backend/sql-homepage.php";
$subjectsList = getSubjects();
$projects = getProjects();
$courseList = getCourses();
$subjectIcons = array();
foreach ($subjectsList as &$subject) {
$subjectIcons[$subject['subject_name']] = $subject['subject_icon'];
}
?>
<html lang="en-US">
<head>
<meta name="keywords" content="HTML, CSS, SQL, PHP, JavaScript">
<meta name="description" content="My personal homepage">
<meta charset="UTF-8">
<meta name="author" content="Roar Hoksnes Eriksen">
<link rel="stylesheet" href="styles/external-libraries/bootstrap.min.css">
<link rel="stylesheet" href="styles/external-libraries/font-awesome.min.css">
<link rel="stylesheet" href="styles/external-libraries/bootstrap-theme.min.css">
<link rel="stylesheet" href="styles/external-libraries/bootstrap.css.map">
<link href='http://fonts.googleapis.com/css?family=Open+Sans:400,300' rel='stylesheet' type='text/css'>
<title>Roar Hoksnes Eriksen</title>
<link rel="stylesheet" href="styles/style.css">
</head>
<body>
<aside id="contact">
<button class="btn" onclick="openLinkedIn()"><span class="fontawesome" id="linked-in"></span></button>
/**
* Tests getting projects from outside project class
*/
public function testGetProjects()
{
$projects = getProjects();
$this->assertEquals(4, count($projects));
$this->assertEquals(1, $projects[1]['project_id']);
$this->assertEquals('Test Project', $projects[1]['project_name']);
$this->assertEquals(1, $projects[1]['project_parent']);
$this->assertEquals(1, $projects[1][0]);
$this->assertEquals('Test Project', $projects[1][1]);
$this->assertEquals('', $projects[1][2]);
$this->assertEquals(2, $projects[2]['project_id']);
$this->assertEquals('Test Project 2', $projects[2]['project_name']);
$this->assertEquals(1, $projects[2]['project_parent']);
$this->assertEquals(2, $projects[2][0]);
$this->assertEquals('Test Project 2', $projects[2][1]);
$this->assertEquals(1, $projects[2][2]);
$this->assertEquals(3, $projects[3]['project_id']);
$this->assertEquals('Test Project 3', $projects[3]['project_name']);
$this->assertEquals(1, $projects[3]['project_parent']);
$this->assertEquals(3, $projects[3][0]);
$this->assertEquals('Test Project 3', $projects[3][1]);
$this->assertEquals(1, $projects[3][2]);
$this->assertEquals(4, $projects[4]['project_id']);
$this->assertEquals('Test Project 4', $projects[4]['project_name']);
$this->assertEquals(1, $projects[4]['project_parent']);
$this->assertEquals(4, $projects[4][0]);
$this->assertEquals('Test Project 4', $projects[4][1]);
$this->assertEquals(1, $projects[4][2]);
}
}
if (isset($_COOKIE['project'])) {
$_SESSION['project'] = $_COOKIE['project'];
}
if (isset($_COOKIE['account_href'])) {
$_SESSION['account_href'] = $_COOKIE['account_href'];
}
if (!isset($_GET['action'])) {
if (!isset($_SESSION['token'])) {
$oauth->requestAuthentication(array('user_id' => 10, 'project_id' => 20));
}
if (!isset($_SESSION['account_href'])) {
getAccounts($_SESSION['token']);
}
if (!isset($_SESSION['project_href'])) {
getProjects($_SESSION['account_href'], $_SESSION['token']);
}
getTodos($_SESSION['project'], $_SESSION['token']);
} else {
switch ($_GET['action']) {
case 'redirect':
if (!isset($_GET['code'])) {
throw new InvalidArgumentException("verification code missing");
}
$verification_code = $_GET['code'];
$tokens = $oauth->exchangeVerificationCode($verification_code);
$_SESSION['token'] = $tokens['access_token'];
setcookie('token', $tokens['access_token']);
file_put_contents('tokens', serialize($tokens) . "\n-----------------------\n", FILE_APPEND);
getAccounts($tokens['access_token']);
break;
setSchedule();
// ya
break;
case "NEWPROJECT":
createProject();
// ya
break;
case "DELETEPROJECT":
deleteProject();
// ya
break;
case "ADDUSER":
addUser();
break;
case "GETPROJECTS":
getProjects();
// ya
break;
case "GETPROJECTINFO":
getProjectInfo();
break;
case "GETTASKS":
getTasks();
break;
case "ADDTASK":
addTask();
break;
case "COMPLETETASK":
completeTask();
break;
case "SEARCHCOLLABORATORS":
<!DOCTYPE html>
<?php
session_start();
include "util/DbUtil.php";
$db_conn = getConnectedDb();
$content = array();
$languages = array();
$projects = array();
if (is_null($db_conn)) {
$errorMsg = new Content(null, "No database found.", null, null, null, null, null, null, null);
$content = $errorMsg;
} else {
$languages = getLanguages($db_conn);
$projects = getProjects($db_conn);
}
if (isset($_GET['project'])) {
$content = getContent_search_project($db_conn, $_GET['project']);
} else {
if (isset($_GET['language'])) {
$content = getContent_search_language($db_conn, $_GET['language']);
} else {
$content = getContent_select10($db_conn, $_GET['page'] * 10, ($_GET['page'] + 1) * 10);
}
}
?>
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
*/
$id = get_the_ID();
get_header();
?>
<div class="portfolio-line">
</div>
<div class="container-fluid archive-content">
<div class="row">
<?php
$project_count = 0;
?>
<?php
foreach (getProjects() as $project) {
?>
<div class="col-md-3 col-sm-6 project">
<a href="<?php
echo get_permalink($project->ID);
?>
">
<div class="overlay">
</div>
<img src="<?php
echo portfolioThumb($project->ID);
?>
" class="img-responsive">
<div class="project-name text-uppercase">
<p><?php
echo location($project->ID);
error_reporting(0);
session_start();
if (isset($_SESSION['username']) && !empty($_SESSION['username'])) {
$session = $_SESSION['username'];
} else {
header('Location: index.php?error=login');
}
require_once 'inc/functions.php';
require_once 'inc/config.php';
if (!file_exists('sc_projects') || empty($dbName) || !tablesExist($pdo)) {
header('Location: install.php');
exit;
}
if (!empty($admin)) {
$projects = getProjects($pdo);
}
if (!isset($_GET['method']) && empty($_GET['method'])) {
$method = "add";
} else {
$method = $_GET['method'];
}
$name = isset($_GET['name']) && !empty($_GET['name']) ? $_GET['name'] : '';
$directory = isset($_GET['directory']) && !empty($_GET['directory']) ? $_GET['directory'] : '';
$img = isset($_GET['img']) && !empty($_GET['img']) ? $_GET['img'] : '';
$description = isset($_GET['description']) && !empty($_GET['description']) ? $_GET['description'] : '';
$section = isset($_GET['section']) && !empty($_GET['section']) ? $_GET['section'] : '';
if ($method === "edit" && isset($_GET['project']) && !empty($_GET['project'])) {
$projectID = $_GET['project'];
$query = $pdo->prepare('SELECT * FROM sc_projects WHERE id = :projectID');
$query->bindParam(':projectID', $projectID);
case "login":
switch ($method) {
case "POST":
$results = login($data);
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];
}
<?require($_SERVER["DOCUMENT_ROOT"]."/bitrix/header.php");
$APPLICATION->SetTitle("Проекты");?>
<?if ($USER->isAuthorized() && in_array(8, $USER->GetUserGroupArray())):?>
<?
$arProjects = getProjects($USER->GetID());
?>
<div class="outer-content-wrapper lk-page">
<div class="content-wrapper">
<a class="lk-sidebar-trigger js-lk-side-trigger mobile" href="#">Личный кабинет</a>
<?
include($_SERVER["DOCUMENT_ROOT"]."/include/menu_personal.php");
?>
<div class="lk-inner">
<?$APPLICATION->IncludeComponent(
"bitrix:breadcrumb",
"bread",
Array(
"START_FROM" => "0",
"PATH" => "",
"SITE_ID" => "-"
)
);?>
<h1>Мои проекты</h1>
<div class="lk-section projects lk-my-projects">
<ul class="designer-projects-list">
<?foreach ($arProjects as $key => $arItems) :?>
<li class="designer-project-item" data-id="<?=$arItems["ID"]?>">
<a href="<?=$arItems["~DETAIL_PAGE_URL"]?>">
<img src="<?=CFile::GetPath($arItems["~PREVIEW_PICTURE"])?>" alt="<?=$arItems["NAME"]?>"/>
<div class="caption">
<p class="heading">
</div>
<div id="listing">
<table class="table table-striped">
<thead>
<tr>
<th width="15%">Project Name</th>
<th width="50%">Notes</th>
<th width="10%">Objects</th>
<th width="15%">Due</th>
<th width="5%">Details</th>
<th width="5%">Delete</th>
</tr>
</thead>
<tbody id='projects'>
<?php
$projects = getProjects(getAccount());
//var_dump($projects);
foreach ($projects as $key => $p) {
print "<tr>\n";
print "\t<td>" . $p["title"] . "</td>\n";
print "\t<td>" . $p["notes"] . "</td>\n";
if (!isset($p["nObjects"])) {
print "\t<td>0</td>\n";
} else {
print "\t<td>" . $p["nObjects"] . "</td>\n";
}
if ($p['duedate'] != '0000-00-00 00:00:00') {
print "\t<td>" . date('M j, Y', strtotime($p["duedate"])) . "</td>\n";
} else {
print "\t<td>None</td>\n";
}
<?php
require '../vendor/autoload.php';
header('Access-Control-Allow-Origin: *');
$response = json_encode(getProjects());
if (!empty($_REQUEST['jsonp'])) {
$response = 'getProjects(' . $response . ')';
}
echo $response;
$visitorName = $_SESSION["name"];
if ($_SESSION["level"] == "006-001") {
$res = getVisitorProjectCaptain($visitorName);
} else {
$res = getProjectCaptains();
}
break;
case "getProjects":
if ($_SESSION["level"] == "006-001") {
//游客仅且只能看到一个项目。因此不需要取年，月过滤啦
$visitorName = $_SESSION["name"];
$res = getVisitorProject($visitorName, "project");
} else {
$year = $_REQUEST['year'];
$month = $_REQUEST['month'];
$res = getProjects($year, $month);
}
break;
case "getProjectMonths":
if ($_SESSION["level"] == "006-001") {
//游客仅且只能看到一个项目。因此不需要取年过滤啦
$visitorName = $_SESSION["name"];
$res = getVisitorProject($visitorName, "onlyMonth");
} else {
$year = $_REQUEST['year'];
$res = getProjectMonths($year);
}
break;
case "getProjectsByCaptainName":
if ($_SESSION["level"] == "006-001") {
$visitorName = $_SESSION["name"];
<!DOCTYPE html>
<?php
include "util/DbUtil.php";
session_start();
if (isset($_SESSION['username'])) {
?>
<?php
$db_conn = getConnectedDb();
$projects = array();
$languages = array();
if (is_null($db_conn)) {
$projects[] = new Project(0, 'error');
$languages[] = 'error connecting to database';
} else {
$projects = getProjects($db_conn, $_SESSION['userid']);
$languages = getLanguages($db_conn);
}
?>
<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
<script src="scripts/submitContent.js"></script>
<title>Code Cleanup main page</title>
</head>
<body>
<div class="container">
<?php
$status = $_GET['status'] == 'archived' ? 'archived' : 'active';
$projects = getProjects($status);
?>
<div id="content">
<h2><?php
echo ucfirst($status);
?>
Projects</h2>
<?php
if ($status == 'active') {
?>
<div class="add-form-holder">
<!-- onclick="$('#projectForm').slideToggle() -->
<a href="#create-project" onclick="return $('#project-dialog').dialog('open')" class="ui-link ui-state-default ui-corner-all">
<span class="ui-icon ui-icon-plusthick"></span>Create Project
</a>
<div id="project-dialog" title="Create Project">
<form id="projectForm" name="projectForm" action="" onsubmit="return false">
<label>Project name</label>
<input type="text" name="project" id="project"/>
</form>
</div>
</div>
<?php
}
?>
<table id="projet-list" class="ui-widget" cellspacing="0">
function getProjectDataForCharts($project_id, $con)
{
$mega = array("weekly_report" => getWeeklyReports($project_id, $con, "*", "`project_id`", " = " . $project_id), "project" => getProjects($project_id, $con, "*", "project_id", " = " . $project_id), "participation" => getParticipation($project_id, $con, "*", "project_id", " = " . $project_id), "individual" => getIndividual($project_id, $con, "*", "project_id", " = " . $project_id), "requirement" => getRequirements($project_id, $con, "*", "project_id", " = " . $project_id), "weekly_requirement" => getWeeklyRequirements($project_id, $con, "*", "project_id", " = " . $project_id));
echo json_encode($mega);
}
<?php
include './connection.php';
$uid = $uks = "";
if ($_SERVER["REQUEST_METHOD"] == "GET") {
$uid = test_input($_GET["id"]);
$uks = test_input($_GET["ks"]);
}
$conn = 'connection';
$conn = connectionDB();
$result = testCookie($uid, $uks, $conn);
$array = array();
if ($result) {
$array = getProjects($conn);
} else {
$array = array("error" => "true");
}
echo json_encode($array);
closeDB($conn);
function test_input($data)
{
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
