PHP save_paulo_entries_from_file Examples

Example #1

File: paulo_entries.php Project: RadioCampusFrance/podcast-rccf

function get_paulo_entries($date, $hour, $bdd, $path, $duration = 1)
{
    $result = array();
    if ($bdd == null) {
        return $result;
    }
    $fullhour = "" . $hour;
    if (strlen($fullhour) == 1) {
        $fullhour = "0" . $fullhour;
    }
    $datetime = $date . " " . $fullhour . ":00:00";
    $file_logs = "";
    if (nb_day_from_today($date) > 1) {
        $file_logs = $path . "/paulo/" . $date . ".txt";
        if (file_exists($file_logs)) {
            $array = get_paulo_entries_from_file($file_logs);
            return filterbyhour($array, $hour, $duration);
        } else {
            $datetimebegin = $date . " " . "00:00:00";
            $datetimeend = $date . " " . "23:59:59";
            $sql = "Select * From titres_paulo where (begin >= " . $bdd->quote($datetimebegin) . " and begin <= " . $bdd->quote($datetimeend) . ") or (end >= " . $bdd->quote($datetimebegin) . " and end <= " . $bdd->quote($datetimeend) . ") order by begin;";
            $prep = $bdd->query($sql);
            $prep->execute();
            for ($i = 0; $row = $prep->fetch(); $i++) {
                $subtime = explode(" ", $row["begin"]);
                $subhour = explode(":", $subtime[1]);
                $result[$subhour[0]][] = array("title" => $row["title"], "author" => $row["author"], "time" => $subtime[1]);
            }
            if (save_paulo_entries_from_file($file_logs, $result)) {
                $sql = "DELETE From titres_paulo where (begin >= " . $bdd->quote($datetimebegin) . " and begin <= " . $bdd->quote($datetimeend) . ") or (end >= " . $bdd->quote($datetimebegin) . " and end <= " . $bdd->quote($datetimeend) . ");";
                $prep = $bdd->query($sql);
                $prep->execute();
            }
            return filterbyhour($result, $hour, $duration);
        }
    }
    $sql = "Select * From titres_paulo where (begin >= " . $bdd->quote($datetime) . " and begin <= DATE_ADD(" . $bdd->quote($datetime) . ", INTERVAL " . $duration . " HOUR)) or (end >= " . $bdd->quote($datetime) . " and end <= DATE_ADD(" . $bdd->quote($datetime) . ", INTERVAL " . $duration . " HOUR)) order by begin;";
    $prep = $bdd->query($sql);
    $prep->execute();
    for ($i = 0; $row = $prep->fetch(); $i++) {
        $subtime = explode(" ", $row["begin"]);
        $result[] = array("title" => $row["title"], "author" => $row["author"], "time" => $subtime[1]);
    }
    return $result;
}

Example #2

File: paulo-sql2file.php Project: RadioCampusFrance/podcast-rccf

function convert_paulo_entries($date, $duration = 1)
{
    global $bdd;
    $result = array();
    if ($bdd == null) {
        return $result;
    }
    $fullhour = "" . $hour;
    if (strlen($fullhour) == 1) {
        $fullhour = "0" . $fullhour;
    }
    $datetimebegin = $date . " " . "00:00:00";
    $datetimeend = $date . " " . "23:59:59";
    if (nb_day_from_today($date) < 7) {
        return true;
    }
    $file_logs = "paulo/" . $date . ".txt";
    if (file_exists($file_logs)) {
        $sql = "DELETE From titres_paulo where (begin >= " . $bdd->quote($datetimebegin) . " and begin <= " . $bdd->quote($datetimeend) . ") or (end >= " . $bdd->quote($datetimebegin) . " and end <= " . $bdd->quote($datetimeend) . ");";
        echo $sql . "<br/>";
        $prep = $bdd->query($sql);
        $prep->execute();
        return false;
    }
    $sql = "Select * From titres_paulo where (begin >= " . $bdd->quote($datetimebegin) . " and begin <= " . $bdd->quote($datetimeend) . ") or (end >= " . $bdd->quote($datetimebegin) . " and end <= " . $bdd->quote($datetimeend) . ") order by begin;";
    $prep = $bdd->query($sql);
    $prep->execute();
    for ($i = 0; $row = $prep->fetch(); $i++) {
        $subtime = explode(" ", $row["begin"]);
        $subhour = explode(":", $subtime[1]);
        $result[$subhour[0]][] = array("title" => $row["title"], "author" => $row["author"], "time" => $subtime[1]);
    }
    if ($file_logs != "") {
        if (save_paulo_entries_from_file($file_logs, $result)) {
            /*$sql = "DELETE From titres_paulo where (begin >= ".$bdd->quote($datetime)." and begin <= DATE_ADD(".$bdd->quote($datetime).", INTERVAL ".$duration." HOUR)) or (end >= ".$bdd->quote($datetime)." and end <= DATE_ADD(".$bdd->quote($datetime).", INTERVAL ".$duration." HOUR));";
              $prep = $bdd->query($sql);
              $prep->execute();*/
        }
    }
    return true;
}

Example #3

File: edit-paulo-entries.php Project: RadioCampusFrance/podcast-rccf

                 if (save_paulo_entries_from_file($file_logs, $array)) {
                     echo "<p>L'ajout a été fait correctement.</p>";
                 } else {
                     echo "<p>Erreur pendant l'ajout au fichier.</p>";
                 }
             }
         } else {
             if (strcmp($action, "ajouter_horaire") == 0) {
                 $horaire_action = $_GET['horaire_action'];
                 if (!isset($horaire_action)) {
                     echo "<p><strong>Erreur&nbsp;:</strong> impossible d'ajouter l'horaire: informations incomplètes.</p>";
                 } else {
                     if (!isset($array[$horaire_action])) {
                         copy($file_logs, $file_logs_backup);
                         $array[$horaire_action] = array();
                         if (save_paulo_entries_from_file($file_logs, $array)) {
                             echo "<p>L'ajout a été fait correctement.</p>";
                         } else {
                             echo "<p>Erreur pendant l'ajout au fichier.</p>";
                         }
                     } else {
                         echo "<p><strong>Erreur&nbsp;:</strong> impossible d'ajouter l'horaire: l'horaire existe déjà.</p>";
                     }
                 }
             }
         }
     }
 }
 foreach ($array as $key => $heure) {
     echo "<h2>Horaire " . $key . "</h2>\n";
     echo "<table>\n";