PHP Paminnelse_sql::getAktivaByPaminnelseの例

コード例 #1

ファイル: paminnelser.php プロジェクト: krillo/motiomera

<?php

require_once $_SERVER['DOCUMENT_ROOT'] . '/php/init.php';
$allaPaminnelser = Paminnelse_sql::listAll();
if (DEBUG) {
    echo "--- DEBUG INFORMATION -----------------\n";
}
foreach ($allaPaminnelser as $paminnelse) {
    $medlemsLista = Paminnelse_sql::getAktivaByPaminnelse($paminnelse);
    if (count($medlemsLista)) {
        $query = str_replace(array('#medlemslista#', '#sql_id#'), array(implode(', ', $medlemsLista), $paminnelse->getId()), $paminnelse->getQuery());
        $resultat = array();
        $yttre_mall = $paminnelse->getMeddelandeId() ? Paminnelse_meddelanden::loadById($paminnelse->getMeddelandeId()) : '';
        $yttre_mall_code = html_entity_decode($yttre_mall->getMall());
        $res = mysql_query($query) or die(mysql_error() . "\n" . $query);
        while ($data = mysql_fetch_assoc($res)) {
            if (isset($data['epost'])) {
                $key = $data['epost'];
                $title = $paminnelse->getTitel();
                $content = $paminnelse->getInreMall();
                foreach ($data as $field => $value) {
                    $content = str_replace('#' . $field . '#', $value, $content);
                    $title = str_replace('#' . $field . '#', $value, $title);
                }
                ob_start();
                eval($yttre_mall_code);
                $resultat[$data['epost']]['text'] = ob_get_clean();
                $resultat[$data['epost']]['subject'] = $title;
            }
        }
        if (count($resultat)) {

コード例 #2

ファイル: paminnelser_provkorsql.php プロジェクト: krillo/motiomera

<?php

require_once $_SERVER["DOCUMENT_ROOT"] . "/php/init.php";
Security::demand(ADMIN);
$smarty = new AdminSmarty();
$smarty->assign("pagetitle", "Provkör påminnelse");
if (!isset($_GET['qid']) || !is_numeric($_GET['qid'])) {
    throw new Paminnelse_sqlException("Felaktigt SQL-ID angivet", 1);
}
$query = Paminnelse_sql::loadById($_GET['qid']);
$yttre_mall = $query->getMeddelandeId() ? Paminnelse_meddelanden::loadById($query->getMeddelandeId()) : '';
$yttre_mall_code = html_entity_decode($yttre_mall->getMall());
$medlemsLista = Paminnelse_sql::getAktivaByPaminnelse($query);
if (!count($medlemsLista) && isset($_GET['fake']) && $_GET['fake']) {
    $medlemsLista = $db->valuesAsArray('SELECT id FROM mm_medlem ' . 'WHERE epostBekraftad = 1 ' . 'ORDER BY RAND() LIMIT 0, 20');
}
if (count($medlemsLista)) {
    $theQuery = str_replace(array('#medlemslista#', '#sql_id#'), array(implode(', ', $medlemsLista), $query->getId()), $query->getQuery());
    $allResults = $db->allValuesAsArray($theQuery);
    $resultat = array();
    foreach ($allResults as $key => $data) {
        if (isset($data['epost'])) {
            $key = $data['epost'];
        }
        $title = $query->getTitel();
        $content = $query->getInreMall();
        foreach ($data as $field => $value) {
            $content = str_replace('#' . $field . '#', $value, $content);
            $title = str_replace('#' . $field . '#', $value, $title);
        }
        ob_start();