function getAllWebsiteCategoriesDT() { global $bdd, $_TABLES; if (!is_null($bdd) && !is_null($_TABLES)) { $content = '<thead>'; $content .= '<tr>'; $content .= '<th>Id</th>'; $content .= '<th>Category</th>'; $content .= '<th>Website</th>'; $content .= '<th>Website Category</th>'; $content .= '<th>Url</th>'; $content .= '<th>Use Url</th>'; $content .= '<th>Url Pagination</th>'; $content .= '<th>Use Pagination</th>'; $content .= '<th>Action</th>'; $content .= '</tr>'; $content .= '</thead>'; $content .= '<tbody>'; $objWebsiteCategory = new WebsiteCategory($bdd, $_TABLES); $items = $objWebsiteCategory->getAllWebsiteCategories(); if ($items) { foreach ($items as $key => $item) { $content .= '<tr website_category_id=' . $item->id . '>'; $content .= '<td>' . $item->id . '</td>'; $content .= '<td><select class="select_dt select_dt_category_id">'; $objCategory = new Category($bdd, $_TABLES); $categories_items = $objCategory->getAllCategories(); if ($categories_items) { foreach ($categories_items as $key_c => $category_item) { $temp_content = ''; $temp_content .= '<option value="' . $category_item->id . '" '; if ($category_item->id == $item->category_id) { $temp_content .= 'selected>'; } else { $temp_content .= '>'; } $temp_content .= $category_item->category . '</option>'; $content .= $temp_content; } } $content .= '</select></td>'; $content .= '<td><select class="select_dt select_dt_website_id">'; $objWebsite = new Website($bdd, $_TABLES); $websites_items = $objWebsite->getAllWebsites(); if ($websites_items) { foreach ($websites_items as $key_w => $website_item) { $temp_content = ''; $temp_content .= '<option value="' . $website_item->id . '" '; if ($website_item->id == $item->website_id) { $temp_content .= 'selected>'; } else { $temp_content .= '>'; } $temp_content .= $website_item->website . '</option>'; $content .= $temp_content; } } $content .= '</select></td>'; $content .= '<td><input type="text" class="input_dt input_dt_website_category" value="' . $item->category . '" /></td>'; $content .= '<td><input type="text" class="input_dt input_dt_url" value="' . $item->url . '" /></td>'; $content .= '<td><input type="checkbox" class="input_dt input_dt_use_url" value="' . $item->use_url . '"></input></td>'; $content .= '<td><input type="text" class="input_dt input_dt_url_pagination" value="' . $item->url_pagination . '" /></td>'; $content .= '<td><input type="checkbox" class="input_dt input_dt_use_pagination" value="' . $item->use_pagination . '"></input></td>'; $content .= "<td><input type='button' class='edit edit_website_category_dt' value='Save' />\n\t\t\t\t <input type='button' class='delete delete_website_category_dt' value='Supprimer' /></td>"; $content .= '</tr>'; } } $content .= '</tbody>'; return $content; } else { error_log("BDD ERROR : " . json_encode($bdd)); error_log("TABLES ERROR : " . json_encode($_TABLES)); } }
include_once $_SERVER['DOCUMENT_ROOT'] . "/engine.php"; if (!isset($_GET['web-id']) && !isset($_GET['start-id'])) { echo "Nothing given :("; exit; } if (isset($_GET['web-id'])) { function echoSite(Website $site) { echo $site->getName() . ":\r\n"; echo $site->update() . "\r\n"; } $webId = $_GET['web-id']; if ($webId == "-1") { // Update all foreach (Website::getAllWebsites() as $site) { echoSite($site); } } else { // Update single site QueryBuilder::create(SQL::getConnection())->withQuery("SELECT display_name, folder_name FROM websites WHERE id = ?")->withParam($webId, QueryBuilder::PARAM_TYPE_INT)->build()->forEachResult(function ($row) { $site = new Website(0, $row['display_name'], $row['folder_name']); echoSite($site); }); } } else { function echoStart(Startables $starter) { echo $starter->getName() . ":\r\n"; echo $starter->start() . "\r\n"; }
<?php if (session_status() == PHP_SESSION_NONE) { session_start(); } require_once dirname(dirname(__FILE__)) . "/common/php/class/class.website.php"; global $bdd; global $_TABLES; $content = ""; $view = new Template(dirname(__FILE__) . '/html/website.html'); if (!is_null($bdd) && !is_null($_TABLES)) { $objWebsite = new Website($bdd, $_TABLES); $websites = $objWebsite->getAllWebsites(); if (!is_null($websites)) { foreach ($websites as $key => $value) { if (isset($_COOKIE['media_preference'])) { $website_preference = json_decode(stripcslashes($_COOKIE['media_preference']), true); if (!is_null($website_preference) && !empty($website_preference)) { $checked = in_array($value->id, $website_preference) == true ? 'checked="true"' : ''; } else { $checked = ''; } } else { $checked = 'checked="true"'; } $content .= $view->getView(array("website_id" => $value->id, "website_name" => mb_strtoupper($value->website, 'UTF-8'), "checked" => $checked)); } echo $content; } else { // 404 echo "404 Not Found";
function getAllWebsiteSubscriptionsDT() { global $bdd, $_TABLES; if (!is_null($bdd) && !is_null($_TABLES)) { $content = '<thead>'; $content .= '<tr>'; $content .= '<th>Id</th>'; $content .= '<th>User</th>'; $content .= '<th>Website</th>'; $content .= '<th>Action</th>'; $content .= '</tr>'; $content .= '</thead>'; $content .= '<tbody>'; $objWebsiteSubscription = new WebsiteSubscription($bdd, $_TABLES); $website_subscriptions = $objWebsiteSubscription->getAllWebsiteSubscriptions(); if ($website_subscriptions) { foreach ($website_subscriptions as $key => $website_subscription) { $content .= '<tr website_subscription_id=' . $website_subscription->id . '>'; $content .= '<td>' . $website_subscription->id . '</td>'; $content .= '<td><select class="select_dt select_dt_user_id">'; $objUser = new User($bdd, $_TABLES); $users_items = $objUser->getAllUsers(); if ($users_items) { foreach ($users_items as $key_u => $user_item) { $temp_content = ''; $temp_content .= '<option value="' . $user_item->id . '" '; if ($user_item->id == $website_subscription->user_id) { $temp_content .= 'selected>'; } else { $temp_content .= '>'; } $temp_content .= $user_item->name . '</option>'; $content .= $temp_content; } } $content .= '</select></td>'; $content .= '<td><select class="select_dt select_dt_website_id">'; $objWebsite = new Website($bdd, $_TABLES); $websites_items = $objWebsite->getAllWebsites(); if ($websites_items) { foreach ($websites_items as $key_w => $website_item) { $temp_content = ''; $temp_content .= '<option value="' . $website_item->id . '" '; if ($website_item->id == $website_subscription->website_id) { $temp_content .= 'selected>'; } else { $temp_content .= '>'; } $temp_content .= $website_item->website . '</option>'; $content .= $temp_content; } } $content .= '</select></td>'; $content .= "<td><input type='button' class='edit edit_website_subscription_dt' value='Save' />\n\t\t\t\t <input type='button' class='delete delete_website_subscription_dt' value='Supprimer' /></td>"; $content .= '</tr>'; } } $content .= '</tbody>'; return $content; } else { error_log("BDD ERROR : " . json_encode($bdd)); error_log("TABLES ERROR : " . json_encode($_TABLES)); } }
function getAllWebsitesDT() { global $bdd, $_TABLES; if (!is_null($bdd) && !is_null($_TABLES)) { $content = '<thead>'; $content .= '<tr>'; $content .= '<th>Id</th>'; $content .= '<th>Website</th>'; $content .= '<th>Url</th>'; $content .= '<th>Logo</th>'; $content .= '<th>File</th>'; $content .= '<th>Scrap</th>'; $content .= '<th>Action</th>'; $content .= '</tr>'; $content .= '</thead>'; $content .= '<tbody>'; $objWebsite = new Website($bdd, $_TABLES); $items = $objWebsite->getAllWebsites(); if ($items) { foreach ($items as $key => $item) { $content .= '<tr websiteId=' . $item->id . '>'; $content .= '<td>' . $item->id . '</td>'; $content .= '<td><input type="text" class="input_dt input_dt_website" value="' . $item->website . '" /></td>'; $content .= '<td><input type="text" class="input_dt input_dt_url" value="' . $item->url . '" /></td>'; $content .= '<td><input type="text" class="input_dt input_dt_logo" value="' . $item->logo . '" /></td>'; $content .= '<td><input type="text" class="input_dt input_dt_file" value="' . $item->file . '" /></td>'; $content .= '<td><input type="checkbox" class="input_dt input_dt_scrap" value="' . $item->scrap . '"></input></td>'; $content .= "<td><input type='button' class='edit edit_website_dt' value='Save' />\n\t\t\t\t <input type='button' class='delete delete_website_dt' value='Supprimer' /></td>"; $content .= '</tr>'; } } $content .= '</tbody>'; return $content; } else { error_log("BDD ERROR : " . json_encode($bdd)); error_log("TABLES ERROR : " . json_encode($_TABLES)); } }