File Source for t_design.class.php

<?php /*
*@=@=@=@ START LICENSE @=@=@=@*
Copyright or © or Copr. Stéphane TRICHET and Nicolas SOTRON
stephane.t@simpliciweb.net and nicolas.s@simpliciweb.net
This software is a computer program whose purpose is to make a
web hosting platform
This software is governed by the CeCILL license under French law and
abiding by the rules of distribution of free software. You can use,
modify and/ or redistribute the software under the terms of the CeCILL
license as circulated by CEA, CNRS and INRIA at the following URL
"http://www.cecill.info".
As a counterpart to the access to the source code and rights to copy,
modify and redistribute granted by the license, users are provided only
with a limited warranty and the software's author, the holder of the
economic rights, and the successive licensors have only limited
liability.
In this respect, the user's attention is drawn to the risks associated
with loading, using, modifying and/or developing or reproducing the
software by the user in light of its specific status of free software,
that may mean that it is complicated to manipulate, and that also
therefore means that it is reserved for developers and experienced
professionals having in-depth computer knowledge. Users are therefore
encouraged to load and test the software's suitability as regards their
requirements in conditions enabling the security of their systems and/or
data to be ensured and, more generally, to use and operate it in the
same conditions as regards security.
The fact that you are presently reading this means that you have had
knowledge of the CeCILL license and that you accept its terms.
*@=@=@=@ END LICENSE @=@=@=@*
*/?><?php
/**
* TDesign Class
*
*
* @author SimpliciWeb
* @version $Id: t_design.class.php 724 2007-11-23 12:12:07Z stephanet $
* @package Common
* @subpackage FrameWork
*/
/**
* Include 'internal_components/common/cache_class/object_cached.class.php'
*/
require_once('internal_components/common/cache_class/object_cached.class.php');
/**
* Manage the designs for a container or a page
* (a design is a php and a template to print a page)
*
* @todo supprimer les tcontent invalidpagedesid, invalidpagedesid, invalidpagetitle, sqlinsert
* @author SimpliciWeb
* @version $Id: t_design.class.php 724 2007-11-23 12:12:07Z stephanet $
* @package Common
* @subpackage FrameWork
*/
class TDesign extends ObjectCached{
// BACK OFFICE CLASS
// member object
/**
* Format Object
*
* @var Format
*/
var $m_object_format = NULL;
/**
* Database Connexion object
*
* @var DbConnexion
*/
var $m_object_dbconnexion = NULL;
/**
* types
*
* @var array
*/
var $m_type = NULL;
/**
* reversed types
*
* @var array
*/
var $m_r_type = NULL;
/**
* entry exec
*
* @var array
*/
var $m_entry_exec = NULL;
/**
* entry exec reversed
*
* @var array
*/
var $m_r_entry_exec = NULL;
/**
* page id
*
* @var integer
*/
var $m_page_id = NULL;
/**
* Design list
*
* @var array
*/
var $m_design_list = array();
// member request
/**
* SQL Request : Get by page id
*
* @var string
*/
var $req_get_by_id_page = "SELECT des_id, des_title FROM t_design WHERE des_page_id=%d;";
/**
* SQL Request : get default detail design
*
* @var string
*/
var $req_get_default_detail_design = "SELECT MIN(des_id) FROM t_design WHERE des_type = 'DETAIL';";
/**
* SQL Request : get default link design
*
* @var string
*/
var $req_get_default_link_design = "SELECT MIN(des_id),des_level FROM t_design WHERE des_type='LINK' AND des_page_id = %d GROUP BY des_level;";
/**
* SQL Request : Get design list
*
* @var string
*/
var $req_get_design_list = "SELECT des_id, des_page_id, des_title, des_level FROM t_design WHERE des_type='%s' @des_page_id@ ORDER BY des_level, des_id;";
/**
* SQL Request : Get design list by array
*
* @var string
*/
var $req_get_design_list_by_array = "
SELECT des_id, des_entry, des_entry_parameter, des_entry_exec, des_template
FROM t_design
WHERE des_id IN %s;";
/**
* SQL Request : get design by template name
*
* @var string
*/
var $req_get_design_by_template_name= "SELECT des_id, des_entry, des_template FROM t_design WHERE des_template = '%s';";
/**
* SQL Request : get design by page id type
*
* @var string
*/
var $req_get_design_by_page_id_type = "SELECT des_id, des_entry, des_template FROM t_design WHERE des_type = '%s' AND des_page_id = %d;";
/**
* SQL Request : Select by primary key
*
* @var string
*/
var $req_select_by_primary_key = "SELECT des_type, des_page_id, des_title,
des_entry, des_template, des_level
FROM t_design
WHERE des_id = %d;";
/**
* SQL Request : Select all
*
* @var string
*/
var $req_select_all = "SELECT des_type, des_page_id, des_title,
des_entry, des_template, des_level, des_id
FROM t_design ;";
/**
* SQL Request : Select product design
*
* @var string
*/
var $req_select_product_design = "SELECT des_id, des_entry, des_template FROM t_design WHERE des_type='PRODUCT' AND des_page_id IN %s;";
/**
* SQL Request : Insert
*
* @var string
*/
var $req_insert = "INSERT INTO t_design(des_type, des_page_id, des_title, des_entry, des_template, des_level) VALUES ('%s', %d, '%s', @des_entry@, '%s', @des_level@);";
/**
* SQL Request : Delete design list
*
* @var string
*/
var $req_delete_design_list = "DELETE FROM t_design WHERE des_id IN %s;";
/**
* SQL Request : Valid link design sub links
*
* @var string
*/
var $valid_link_design_sub_links = "SELECT max( des_level )
FROM t_design
WHERE des_page_id =%d
AND des_type = 'LINK'
AND des_level <=%d;";
/**
* SQL Request : valid link design
*
* @var string
*/
var $valid_link_design = "SELECT des_id
FROM t_design
WHERE des_id=%d
AND (
(
des_type = 'SPE_LINK'
)
OR (
des_page_id =%d
AND des_type = 'LINK'
AND des_level
IN (%d)
)
);";
/**
* array already loaded
*
* @var array
*/
var $m_array_already_loader = array();
/**
* Constructor, init the requests and objects
*
* @return TDesign
*/
function TDesign() {
global $g_object_loader;
$this->m_object_format =& $g_object_loader->getFormat();
$this->m_object_dbconnexion =& $g_object_loader->getDbConnexion();
$tihs->m_page_id["TRASH"] = 70;
$this->m_type["LINK"]="LINK";
$this->m_type["DETAIL"]="DETAIL";
$this->m_type["CONTAINER"]="CONTAINER";
$this->m_type["SPECIAL_LINK"]="SPE_LINK";
$this->m_type["SPECIAL_DETAIL"]="SPE_DETAIL";
$this->m_type["PRODUCT"]="PRODUCT";
$this->m_r_type = array_flip($this->m_type);
$this->m_entry_exec["ALWAYS_BEFORE_SESSION_DESTROY"] = "ALWAYS_BEFORE";
$this->m_entry_exec["ALWAYS"] = "ALWAYS";
$this->m_entry_exec["NOTIFCACHED"] = "CACHED";
$this->m_entry_exec["ALWAYS_AFTER"] = "ALWAYS_AFTER";
$this->m_r_entry_exec = array_flip($this->m_entry_exec);
$this->m_design_list = array();
}
// xIsNotValid
// **********
/**
* Parameter Integrity checker
*
* @access private
* @param string $p_value
* @return bool TRUE if not valid
*/
function isNotValidDesId($p_value) {
return $this->m_object_format->isNotUnsignedInteger($p_value, 8);
}
/**
* Parameter Integrity checker
*
* @access private
* @param string $p_value
* @return bool TRUE if not valid
*/
function xIsNotValidDesType($p_value) {
return $this->m_object_format->isNotEnum($p_value, $this->m_r_type);
}
/**
* Parameter Integrity checker
*
* @access private
* @param string $p_value
* @return bool TRUE if not valid
*/
function xIsNotValidDesPageId($p_value) {
return $this->m_object_format->isNotUnsignedInteger($p_value, 8);
}
/**
* Parameter Integrity checker
*
* @access private
* @param string $p_value
* @return bool TRUE if not valid
*/
function isNotValidDesTitle($p_value) {
return $this->m_object_format->isNotVarchar($p_value, 32);
}
/**
* Parameter Integrity checker
*
* @access private
* @param string $p_value
* @return bool TRUE if not valid
*/
function isNotValidDesEntry($p_value) {
return $this->m_object_format->isNotVarchar($p_value, 255);
}
/**
* Parameter Integrity checker
*
* @access private
* @param string $p_value
* @return bool TRUE if not valid
*/
function isNotValidDesTemplate($p_value) {
return $this->m_object_format->isNotVarchar($p_value, 255);
}
/**
* Parameter Integrity checker
*
* @access private
* @param string $p_value
* @return bool TRUE if not valid
*/
function xIsNotValidDesLevel($p_value) {
return $this->m_object_format->isNotUnsignedInteger($p_value, 3);
}
/**
* Add member design list
*
* @param array $p_design
*/
function addMemberDesignList($p_design) {
if (0<count($p_design)) {
$this->m_design_list = array_merge($this->m_design_list,$p_design);
}
}
/**
* Get member design list
*
* @param array $r_result
*/
function getMemberDesignList(&$r_result) {
$r_result = $this->m_design_list;
}
////////
// FO //
////////
/**
* Get all the entry to exec
*
* Renvoit la liste des types du champs des_entry_exe
*
* @param array $r_result
*/
function getEntryExec(&$r_result)
{
$r_result = $this->m_entry_exec;
}
/**
* Get the designs in an array
*
* Renvoit les designs contenus dans un tableau et un tableau contenant les templates ayant du t_content et un tableau contenant cette liste indexée par le nom du tpl
*
* @param array $p_design_list_array
* @param array $r_result
* @return bool TRUE on error
*/
function getDesignListByArray($p_design_list_array, &$r_result) {
$r_result = $name_indexed_list = array();
if (0<count($p_design_list_array)) {
$parameters = array("(".implode(",",array_unique($p_design_list_array)).")");
$result = array();
if ($this->m_object_dbconnexion->makeSqlQuery($this->req_get_design_list_by_array, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
while ($row = mysql_fetch_row($result)) {
$r_result[$row[0]]['des_entry'] = $row[1];
$r_result[$row[0]]['des_entry_parameter'] = $row[2];
$r_result[$row[0]]['des_entry_exec'] = $this->m_r_entry_exec[$row[3]];
$r_result[$row[0]]['des_template'] = $row[4];
$name_indexed_list[$row[4]] = array("des_id"=>$row[0], "des_entry"=>$row[1], "startup_loaded"=>TRUE);
}
}
//print_r_net($name_indexed_list);
$this->addMemberDesignList($name_indexed_list);
return false;
}
/**
* Get design by template
*
* @param integer $p_design_template_name
* @param array $r_result
* @return bool TRUE on error
*/
function getDesignByTemplateName($p_design_template_name, &$r_result) {
$r_result = array();
if ($this->isNotValidDesTemplate($p_design_template_name))
return onErrorThrow(true,plici_lang("lang_error_internal"));
$result = array();
$parameters = array($p_design_template_name);
if ($this->m_object_dbconnexion->makeSqlQuery($this->req_get_design_by_template_name, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
while ($row = mysql_fetch_row($result)) {
$r_result = array("des_id"=>$row[0], "des_entry"=>$row[1], "startup_loaded"=>FALSE);
}
return false;
}
/**
* Get the template to use to print products
*
* Renvoit le fichier template a utiliser pour afficher la fiche produit
* @param integer $p_page_id
* @param array $r_result
* @return bool TRUE on error
*/
function getProductPageDesign($p_page_id, &$r_result) {
$r_result = "";
if ($this->xIsNotValidDesPageId($p_page_id))
return onErrorThrow(true,plici_lang("lang_error_pkpageid"));
$result = array();
$parameters = array("(0, ".$p_page_id.")");
if ($this->m_object_dbconnexion->makeSqlQuery($this->req_select_product_design, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
$list = array();
while ($row = mysql_fetch_row($result)) {
array_push($list, array("des_id"=> $row[0], "des_entry"=>$row[1], "des_template"=>$row[2]) );
}
// Il y a forcement le résultat par défaut. Si plus on prend celui associé a la page
$r_result = 1<count($list)?$list[1]:$list[0];
return false;
}
////////
// BO //
////////
/**
* Test if a deesign can be used into a container
*
* Indique si une apparence peut être utilisé au niveau du conteneur réclamé
*
* @access private
* @param integer $p_des_id
* @param integer $p_page_des_id
* @param integer $p_level
* @param array $r_result
* @return bool TRUE on error
*/
function isValidDesignForContainer($p_des_id, $p_page_des_id, $p_level, &$r_result) {
$r_result = false;
if ($this->isNotValidDesID($p_des_id))
return onErrorThrow(true,plici_lang("lang_error_internal"));
if ($this->xIsNotValidDesPageId($p_page_des_id))
return onErrorThrow(true,plici_lang("lang_error_internal"));
if ($this->xIsNotValidDesLevel($p_level))
return onErrorThrow(true,plici_lang("lang_error_internal"));
$parameters = $result = array();
array_push($parameters, $p_page_des_id);
array_push($parameters, $p_level);
if ($this->m_object_dbconnexion->makeSqlQuery($this->valid_link_design_sub_links, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
$tem_row = mysql_fetch_row($result);
$max_des_level = $tem_row[0];
$parameters = $result = array();
array_push($parameters, $p_des_id);
array_push($parameters, $p_page_des_id);
array_push($parameters, $max_des_level);
if ($this->m_object_dbconnexion->makeSqlQuery($this->valid_link_design, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
$r_result = 0>=mysql_num_rows($result)?false:true;
return false;
}
/**
* Get the list of designs of type $p_page_type linked to the page
*
* Renvoit la liste de design de type $p_page_type associée a la page
*
* @param string $p_page_type
* @param integer $p_page_id
* @param array $r_result
* @return bool TRUE on error
*/
function getDesignList($p_page_type, $p_page_id, &$r_result) {
return $this->getDesignListByTypeAndIdPageList($p_page_type, array($p_page_id), $r_result);
}
/**
* Get design list by type and page list
*
* @param string $p_page_type
* @param array $p_liste_page_id
* @param array $r_result
* @return bool TRUE on error
*/
function getDesignListByTypeAndIdPageList($p_page_type, $p_liste_page_id, &$r_result) {
$r_result = array();
if ($this->xIsNotValidDesType($p_page_type))
return onErrorThrow(true,plici_lang("lang_error_internal"));
$list_page_id = array();
for($i=0; $i<count($p_liste_page_id); $i++) {
if ((null != $p_liste_page_id[$i]) && ($this->xIsNotValidDesPageId($p_liste_page_id[$i])))
return onErrorThrow(true,plici_lang("lang_error_pagedesid"));
if (0 != $p_liste_page_id[$i])
array_push($list_page_id ,$p_liste_page_id[$i]);
}
$request = $this->req_get_design_list;
$parameters = array();
array_push($parameters, $this->m_type[$p_page_type]);
switch ($p_page_type) {
case "PRODUCT" :
case "DETAIL" :
if (0>=count($list_page_id)) {
$request = str_replace('@des_page_id@', '', $request);
break;
}
default :
$request = str_replace('@des_page_id@', "AND des_page_id IN %s", $request);
array_push($parameters, "(".implode(",", $p_liste_page_id).")");
break;
}
$result = array();
if ($this->m_object_dbconnexion->makeSqlQuery($request, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
$r_result_count = 0;
while ($row = mysql_fetch_row($result)) {
$r_result[$r_result_count]['des_id'] = $row[0];
$r_result[$r_result_count]['des_page_id'] = $row[1];
$r_result[$r_result_count]['des_title'] = $row[2];
$r_result[$r_result_count]['des_level'] = $row[3];
$r_result_count++;
}
return false;
}
/**
* Get design
*
* @param integer $p_design_id
* @param array $r_result
* @return bool TRUE on error
*/
function getDesign($p_design_id, &$r_result) {
$r_result = array();
if ($this->isNotValidDesId($p_design_id))
return onErrorThrow(true,plici_lang("lang_error_internal"));
if ($this->xIsRemembered("d_".$p_design_id, $r_remembered_object)) {
$r_result = $r_remembered_object;
return false;
}
$parameters = array($p_design_id);
$result = array();
//$this->m_object_dbconnexion->debug_is_on = true;
if ($this->m_object_dbconnexion->makeSqlQuery($this->req_select_by_primary_key, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
//$this->m_object_dbconnexion->debug_is_on = false;
while ($row = mysql_fetch_row($result)) {
$r_result['des_id'] = $p_design_id;
$r_result['des_type'] = $this->m_r_type[$row[0]];
$r_result['des_page_id'] = $row[1];
$r_result['des_title'] = $row[2];
$r_result['des_entry'] = $row[3];
$r_result['des_template'] = $row[4];
$r_result['des_level'] = $row[5];
}
$this->xRemember("d_".$p_design_id, $r_result);
return false;
}
/**
* Get designs
*
* @param array $r_result_all
* @return bool TRUE on error
*/
function xGetDesigns(&$r_result_all) {
$r_result_all = array();
$parameters = array();
$result = array();
if ($this->m_object_dbconnexion->makeSqlQuery($this->req_select_all, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
while ($row = mysql_fetch_row($result)) {
$r_result = array();
$r_result['des_id'] = $row[6];
$r_result['des_type'] = $this->m_r_type[$row[0]];
$r_result['des_page_id'] = $row[1];
$r_result['des_title'] = $row[2];
$r_result['des_entry'] = $row[3];
$r_result['des_template'] = $row[4];
$r_result['des_level'] = $row[5];
array_push($r_result_all, $r_result);
}
return false;
}
/**
* insert
*
* @param string $p_des_type 'CONTAINER', 'LINK', 'DETAIL', 'SPE_LINK', 'SPE_DETAIL', 'PRODUCT'
* @param integer $p_des_page_id
* @param string $p_page_type
* @param string $p_des_title
* @param string $p_des_entry
* @param string $p_des_template
* @param integer $p_des_level
* @param array $r_result
* @return bool TRUE on error
*/
function insert($p_des_type, $p_des_page_id, $p_page_type, $p_des_title, $p_des_entry, $p_des_template, $p_des_level, &$r_result) {
$r_result = -1;
global $g_object_loader;
$g_object_message =& $g_object_loader->getMessage();
onErrorThrow($this->xIsNotValidDesType($p_des_type) || (null==$p_des_type),plici_lang("lang_error_field"));
onErrorThrow($this->xIsNotValidDesPageId($p_des_page_id),plici_lang("lang_error_field"));
switch ($p_des_type) {
case "DETAIL":
break;
default :
onErrorThrow(0 == $p_des_page_id,plici_lang("lang_error_field"));
break;
}
onErrorThrow($this->isNotValidDesTitle($p_des_title) || (null==$p_des_title),plici_lang("lang_error_field"));
onErrorThrow($this->isNotValidDesEntry($p_des_entry),plici_lang("lang_error_internal"));
onErrorThrow($this->isNotValidDesTemplate($p_des_template) || (null==$p_des_template), 'invalidDesTemplate', $function_name, EFN_4j1xcbCPhuRqXbmSuIiDQjS0jouyAfWa);
if (null != $p_des_level) {
onErrorThrow($this->xIsNotValidDesLevel($p_des_level),plici_lang("lang_error_internal"));
} else {
onErrorThrow("LINK"==$p_des_type,plici_lang("lang_error_internal"));
}
//Vérification - Pour faire plus beau, il faudrait recharger les informations à partir du des_page_ids
switch ($p_des_type) {
case "CONTAINER" :
case "LINK" : onErrorThrow("CONTAINER" != $p_page_type,plici_lang("lang_error_field"));
break;
case "DETAIL" : $p_des_page_id = 0;
break;
case "SPECIAL_LINK" :
case "SPECIAL_DETAIL" : onErrorThrow("SYSTEM" == $p_page_type,plici_lang("lang_error_field"));
break;
default :
break;
}
if ($g_object_message->thereIsAnError()) {
return true;
}
$parameters = array();
$request = $this->req_insert;
array_push($parameters, $this->m_type[$p_des_type]);
array_push($parameters, $p_des_page_id);
array_push($parameters, trim($p_des_title));
if (null == $p_des_entry) {
$request = str_replace("@des_entry@", " null ", $request);
} else {
$request = str_replace("@des_entry@", " '%s' ", $request);
array_push($parameters, trim($p_des_entry));
}
array_push($parameters, trim($p_des_template));
if (null == $p_des_level) {
$request = str_replace("@des_level@", " null ", $request);
} else {
$request = str_replace("@des_level@", " %d ", $request);
array_push($parameters, $p_des_level);
}
$result = array();
if ($this->m_object_dbconnexion->makeSqlQueryWithId($request, $parameters, $result, $r_result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
$this->xClearRemember("d_".$r_result);
$this->xClearRemember("l_".$p_des_page_id."_".$p_des_type);
return false;
}
/**
* Get link design id for insertion
*
* @param integer $p_page_id
* @param array $r_result
* @return bool TRUE on error
*/
function getLinkDesignIdForInsertion($p_page_id, &$r_result) {
$r_result = array();
if ($this->xIsNotValidDesPageId($p_page_id))
return onErrorThrow(true,plici_lang("lang_error_pkpageid"));
if ($this->m_page_id["TRASH"] != $p_page_id) { //Si ce n'est pas la page poubelle
$parameters = $result =array();
array_push($parameters, $p_page_id);
if ($this->m_object_dbconnexion->makeSqlQuery($this->req_get_default_link_design, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
$ind = 0;
while ($row = mysql_fetch_row($result)) {
while($ind<=$row[1]) {
$r_result[$ind] = $row[0];
$ind++;
}
}
}
return false;
}
/**
* Get Detail design id for insertion
*
* @param array $r_result
* @return bool TRUE on error
*/
function getDetailDesignIdForInsertion(&$r_result) {
$r_result = -1;
$parameters = $result =array();
if ($this->m_object_dbconnexion->makeSqlQuery($this->req_get_default_detail_design, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
while ($row = mysql_fetch_row($result)) {
$r_result = $row[0];
}
return false;
}
///////////
// ADMIN //
///////////
/**
* Delete a design
* Delete all the designs by type associated to a page id.
* Return into $r_result the list of files to delete
*
* Supprime toutes les apparences d'un certain type associées à un id de page. Va renvoyer la liste des fichiers supprimables
*
* @param string $p_des_type
* @param integer $p_page_id
* @param array $r_result
* @return bool TRUE on error
*/
function delete($p_des_type, $p_page_id, &$r_result){
$r_result = array();
$r_result["entry"] = $r_result["template"] = array();
if ($this->xIsNotValidDesType($p_des_type))
return onErrorThrow(TRUE,plici_lang("lang_error_field"));
if ($this->xIsNotValidDesPageId($p_page_id))
return onErrorThrow(TRUE,plici_lang("lang_error_pkpageid"));
$parameters = $result = array();
array_push($parameters, $this->m_type[$p_des_type]);
array_push($parameters, $p_page_id);
if ($this->m_object_dbconnexion->makeSqlQuery($this->req_get_design_by_page_id_type, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
$design_list = $entry_file = $template_file = array();
while ($row = mysql_fetch_row($result)) {
array_push($design_list, $row[0]);
if ((null != $row[1]) && (0<strlen($row[1])))
array_push($entry_file, $row[1]);
if ((null != $row[2]) && (0<strlen($row[2])))
array_push($template_file, $row[2]);
}
//Suppression des apparences
$design_deleted = -1;
if (0<count($design_list)) {
$parameters = $result = array();
array_push($parameters, "(".implode(",",$design_list).")");
if ($this->m_object_dbconnexion->makeSqlQuery($this->req_delete_design_list, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
$design_deleted = mysql_affected_rows();
}
//Création de la liste des fichiers entréer a supprimer - ON NE PEUT PAS ETRE SUR CAR LES FICHIERS ENTREE SONT PARTAGES AVEC TOUS LES CLIENTS
$r_result["entry"] = $entry_file;
//Création de la liste des fichiers template a supprimer
for ($i=0; $i<count($template_file); $i++) {
if ($this->m_object_dbconnexion->makeSqlQuery("SELECT count(des_id) FROM t_design WHERE des_template='".$template_file[$i]."';", $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
$row = mysql_fetch_row($result);
if (1==$row[0])
array_push($r_result["template"], $template_file[$i]);
}
return false;
}
/**
* Check integrity
*
* @param array $r_resut_final
* @return bool TRUE on error
*/
function _check(&$r_resut_final) {
$function_name = "_check";
$r_result_get_all = array();
global $g_object_siteinformation;
$this->xGetDesigns($r_result_get_all);
$r_resut_final = array();
// des_id,des_type,des_page_id,des_title,des_entry,des_template,des_level
foreach ($r_result_get_all as $value) {
// test si ce design sert pour une page
// soit des_id = page_link_des_id ou page_detail_des_id
// soit des_id = page_des_id
$find_utility = "";
$request = "SELECT count(*) FROM t_page WHERE page_link_des_id=".$value['des_id'].";";
$parameters = $result = array();
if ($this->m_object_dbconnexion->makeSqlQuery($request, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_selectnoflinkdes"));
}
//$result = mysql_query($request);
$row = mysql_fetch_row($result);
$r_result = $row[0];
if ($r_result > 0)
$find_utility .= "|page_link_des_id";
$request = "SELECT count(*) FROM t_page WHERE page_detail_des_id=%d;";
$parameters = $result = array();
$parameters[] = $value['des_id'];
if ($this->m_object_dbconnexion->makeSqlQuery($request, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_selectnofdetaildes"));
}
//$result = mysql_query($request);
$row = mysql_fetch_row($result);
$r_result = $row[0];
//Une page de détail, ou de produit peut exister mais être associé a personne
if (($r_result > 0) || ((0 == $value['des_type']) && (("DETAIL" == $value['des_type']) || ("SPE_DETAIL" == $value['des_type']) || ("PRODUCT" == $value['des_type']))))
$find_utility .= "|page_detail_des_id";
$request = "SELECT count(*) FROM t_page WHERE page_id=%d;";
$parameters = $result = array();
$parameters[] = $value['des_page_id'];
if ($this->m_object_dbconnexion->makeSqlQuery($request, $parameters, $result)) {
return onErrorThrow(true,plici_lang("lang_error_selectnofdes"));
}
//$result = mysql_query($request);
$row = mysql_fetch_row($result);
$r_result = $row[0];
if ($r_result > 0)
$find_utility .= "|des_page_id";
// si on a pas trouvé d'utilité au design, on le signale
if ($find_utility == "") {
$to_write = $value['des_id']."|".$value['des_type']."|".$value['des_page_id']."|".$value['des_title']."|".$value['des_entry']."|".$value['des_template']."|".$value['des_level'];
$to_write .= "<br/> delete from t_design where des_type='".$value['des_type']."' and des_page_id ='".$value['des_page_id']."' and des_title='".$value['des_title']."' and des_template='".$value['des_template']."';";
array_push($r_resut_final, array(
'col1' => 'AUCUNE PAGE LIEE'
,'col2'=> $to_write));
} else {
// si il sert, on test que les fichiers utiles soient bien en action
if (!file_exists($g_object_siteinformation->getFrontSiteEntry().PLICI_MY_DIRECTORY."/".$value['des_entry'])
&& !file_exists($g_object_siteinformation->getFrontSiteEntry().PLICI_MY_DIRECTORY."/".$value['des_entry'])) {
$to_write = $value['des_id']."|".$value['des_type']."|".$value['des_page_id']."|".$value['des_title']."|".$value['des_entry']."|".$value['des_template']."|".$value['des_level'];
$to_write .= "<br/> delete from t_design where des_type='".$value['des_type']."' and des_page_id ='".$value['des_page_id']."' and des_title='".$value['des_title']."' and des_template='".$value['des_template']."';";
array_push($r_resut_final, array(
'col1' => 'des_entry INEXISTANT'
,'col2'=> $to_write));
}
if (!$g_object_siteinformation->getExistTemplateNotCompiledFilePath($value['des_template'], $r_not_used, true,$this->m_object_dbconnexion->m_database_name)) {
$to_write = $value['des_id']."|".$value['des_type']."|".$value['des_page_id']."|".$value['des_title']."|".$value['des_entry']."|".$value['des_template']."|".$value['des_level'];
$to_write .= "<br/> delete from t_design where des_type='".$value['des_type']."' and des_page_id ='".$value['des_page_id']."' and des_title='".$value['des_title']."' and des_template='".$value['des_template']."';";
array_push($r_resut_final, array(
'col1' => 'des_template INEXISTANT'
,'col2'=> $to_write));
}
}
}
$to_write = sizeof($r_result_get_all);
array_push($r_resut_final, array(
'col1' => 'NB lignes lues'
,'col2'=> $to_write));
$r_result = $r_resut_final;
return false;
}
}
?>

Documentation generated on Tue, 25 Mar 2008 15:36:22 +0100 by phpDocumentor 1.3.2

Source for file t_design.class.php