Exemplo n.º 1
0
    $groupby = "";
}
if ($groupby == "") {
    $formList->fields = "jj AS element, count(id) AS cpt, sum(nb_aff) AS cpt_nb_aff, sum(nb_click) AS cpt_nb_click";
    $formList->orderby = $orderby;
} else {
    $formList->fields = "{$groupby} AS element, count(id) AS cpt, sum(nb_aff) AS cpt_nb_aff, sum(nb_click) AS cpt_nb_click";
    $formList->groupby = $groupby;
    $listCols[0]["label"] = $label;
}
//
//
// Filtres /////////////////////////////////////// ????
//
$formList->clause_where();
$count_datas = $formList->get_datas();
//echoa($formList->datasList);
$barmax = 600;
$affmax = 0;
if (count($formList->datasList) > 0) {
    foreach ($formList->datasList as $keyId => $datas) {
        if ($datas["cpt_nb_aff"] > $affmax) {
            $affmax = $datas["cpt_nb_aff"];
        }
    }
    include DOS_INCPAGES_ADMIN . "list-beforeLoop.php";
    $listRow = array();
    foreach ($formList->datasList as $keyId => $datas) {
        $valeurs = array();
        include DOS_INCPAGES_ADMIN . "list-inLoop.php";
        $lgbar_aff = $datas["cpt_nb_aff"] * $barmax / $affmax;
Exemplo n.º 2
0
 public function maj_media_inside($idParent)
 {
     global $myAdmin;
     global $__POST;
     global $idCurrent;
     global $thisSite;
     $copy__POST = $__POST;
     $copy__POST2 = $__POST;
     foreach ($copy__POST as $field => $val) {
         // on cherche les champs commencant par fieldMedia__ qui indique qu'il y a des champs médias
         if (strpos($field, "fieldMedia__") === 0) {
             $liste = unserialize($val);
             if ($liste["type"] == "video") {
                 $type = $liste["type"] . "-" . $copy__POST["typeVideo"];
             } else {
                 $type = $liste["type"];
             }
             //echoa("<hr>");
             //echoa($type);
             //echoa($liste["field_media"]);
             //echoa($__POST);
             $field_media = $liste["field_media"];
             $idMedia = $liste["idMedia"];
             $prefixe = substr($field, strlen("fieldMedia__"), 100) . "__";
             $len_prefixe = strlen($prefixe);
             // on vide avant de remplir avec les données d'un nouveau média
             $__POST["fichier_media"] = "";
             $__POST["titre_media"] = "";
             $__POST["fichier_destination"] = "";
             $__POST["lien_destination"] = "";
             $__POST["cible_destination"] = "";
             if (count($myAdmin->LIST_LANG_DATAS) > 1) {
                 foreach ($myAdmin->LIST_LANG_DATAS as $clg => $nlg) {
                     $__POST["fichier_media_" . $clg] = "";
                     $__POST["titre_media_" . $clg] = "";
                     $__POST["fichier_destination_" . $clg] = "";
                     $__POST["lien_destination_" . $clg] = "";
                     $__POST["cible_destination_" . $clg] = "";
                 }
             }
             // echoa($copy__POST2);
             $emptyControl = array();
             foreach ($copy__POST2 as $field2 => $val2) {
                 // on cherche les champs médias correspondant
                 if (strpos($field2, $prefixe) === 0) {
                     // echoa($field2." : ".$val2);
                     $fieldOk = substr($field2, $len_prefixe, 100);
                     // on ajoute des éléments avec un nom de champs que set_datas pourra exploiter
                     $__POST[$fieldOk] = $val2;
                     foreach ($myAdmin->LIST_LANG_DATAS as $clg => $nlg) {
                         $__POST[$fieldOk . "_" . $clg] = $val2;
                     }
                     //echoa("." . $fieldOk . " : " . $val2);
                     if ($liste["type"] == "link" && strpos($fieldOk, "lien_destination") === 0) {
                         $emptyControl[] = $fieldOk;
                     }
                     if ($liste["type"] != "link" && strpos($fieldOk, "fichier_media") === 0) {
                         $emptyControl[] = $fieldOk;
                     }
                 }
             }
             //$__POST 2
             //echoa($emptyControl);
             // echoa($__POST);
             $empty = 0;
             foreach ($emptyControl as $fieldOk) {
                 //  echoa("-" . $liste["field_media"]."__" . $fieldOk);
                 if ($copy__POST2[$liste["field_media"] . "__" . $fieldOk] == "") {
                     $empty++;
                 }
             }
             // echoa($empty);
             if ($empty == count($emptyControl)) {
                 if ($idMedia != "") {
                     // on supprime le media
                     $myDeleteM = new myDelete(__FILE__);
                     $myDeleteM->table = $thisSite->PREFIXE_TBL_GEN . "medias";
                     $myDeleteM->where = "id=:id";
                     $myDeleteM->whereValue["id"] = array($idMedia, PDO::PARAM_STR);
                     $result = $myDeleteM->execute();
                 }
                 continue;
             }
             $idCurrent = 0;
             // attention, on remet à blanc l'IdCurrent du parent. (on le remet à jour à la fin)
             $formMaj2 = new formMaj();
             $formMaj2->maj_media_inside = true;
             $formMaj2->tables = $thisSite->PREFIXE_TBL_GEN . "medias";
             $formMaj2->fields = "*";
             $formMaj2->where = "id=:id";
             $formMaj2->whereValue["id"] = array($idMedia, PDO::PARAM_INT);
             $formMaj2->multiLang = true;
             $formMaj2->clause_where();
             // attribution par défaut si première image de l'Id_parent
             $formList2 = new formList();
             $formList2->tables = $thisSite->PREFIXE_TBL_GEN . "medias";
             $formList2->fields = "id";
             $formList2->where = "lg='" . $myAdmin->LANG_DATAS . "' AND field_media='" . $field_media . "' AND type='" . $type . "'";
             if ($idParent > 0) {
                 $formList2->where .= " AND id_parent=" . $idParent;
             }
             $formList2->clause_where();
             $count_datas = $formList2->get_datas();
             if ($count_datas == 0) {
                 if ($type == "image" || $type == "video") {
                     $__POST["image_principale"] = 1;
                 }
             }
             if (!isset($__POST["actif"])) {
                 $__POST["actif"] = 1;
             }
             $__POST["type"] = $type;
             $__POST["field_media"] = $field_media;
             //$this->tables . "." .
             $__POST["id_parent"] = $idParent;
             $formMaj2->set_datas();
             $idCurrent = $idParent;
             // on remet à jour l'IdCurrent du parent.
         }
         // if(strpos($field, "fieldMedia__")===0)
     }
     //$__POST
 }