コード例 #1
0
ファイル: shared.inc.php プロジェクト: kktsvetkov/1double.com
function getWeeks($week)
{
    global $MONTHS;
    global $span;
    //razgrafawa se za 2 meseca ot tekuschtata data
    //wsyaka data se pada petyk-a ot nachaloto na
    //kino sedmicata
    $Weeks = '';
    $friday = getNextWeek();
    //sledwaschtiya petyk
    $now = $friday - 604800;
    //tozi petyk
    //if (!$week) $week = $friday;
    $range = 8;
    //select boks za osem sedmici
    //manage offset
    if ($span > 0) {
        $range += intval(($now - $span) / 604800);
        $now = $span;
    }
    if ($week && $week < $now) {
        $range += intval(($now - $week) / 604800);
        $now = $week;
    }
    for ($i = 0; $i < $range; $i++) {
        $koga = $now + $i * 604800;
        $dokoga = $koga + 518401;
        $godina1 = date('Y', $koga);
        $godina2 = date('Y', $dokoga);
        if ($godina1 == $godina2) {
            $godina1 = '';
        }
        $datata = date('d ', $koga) . $MONTHS[intval(date('m', $koga))] . " {$godina1}";
        $datata .= date(' - d ', $dokoga) . $MONTHS[intval(date('m', $dokoga))] . " {$godina2}";
        if ($week && $week >= $koga && $week <= $dokoga) {
            $Weeks .= "<option value=\"{$koga}\" SELECTED>{$datata}";
        } else {
            $Weeks .= "<option value=\"{$koga}\">{$datata}";
        }
    }
    return $Weeks;
}
コード例 #2
0
ファイル: admin.php プロジェクト: kktsvetkov/1double.com
function setCharts()
{
    global $SUBS, $PARAM, $MSG;
    global $tbl_1d_charts, $tbl_1d_kino_charts, $tbl_1d_videodvd_charts, $tbl_1d_films, $tbl_1d_videodvd;
    global $MONTHS, $MONTHS2;
    // check chart length
    $query = "SELECT Length, Type\n\t\tFROM {$tbl_1d_charts}\n\t\tORDER BY ID = " . dbQuote($PARAM['PLACES']) . " DESC ";
    $result = runQuery($query, 'setCharts()', 'GET_CHART_LENGTH_AND_TYPE');
    if ($row = db_fetch_row($result)) {
        $max = $row[0];
        $type = $row[1];
    } else {
        adminMenu();
        return;
    }
    //iztriwane
    if ($PARAM['Delete'] == 1) {
        reset($PARAM);
        $Films = '0';
        while (list($k, $v) = each($PARAM)) {
            if (ereg('^c_([0-9]+)$', $k, $R)) {
                $Films .= ",{$R['1']}";
            }
        }
        //get chart type
        $query = "SELECT Type\n\t\t\tFROM {$tbl_1d_charts}\n\t\t\tWHERE ID = " . dbQuote($PARAM['PLACES']);
        $result = runQuery($query, 'setCharts()', 'GET_CHART_TYPE2');
        if ($row = db_fetch_row($result)) {
            $type = $row[0];
        } else {
            $SUBS['ERROR'] = $MSG[20008];
        }
        switch ($type) {
            case 'videodvd':
                $query = "DELETE FROM {$tbl_1d_videodvd_charts} WHERE ID IN ({$Films})";
                break;
            case 'kino':
                $query = "DELETE FROM {$tbl_1d_kino_charts} WHERE ID IN ({$Films})";
                break;
        }
        if ($Films == '0') {
            $SUBS['ERROR'] = $MSG[20008];
        }
        if ($SUBS['ERROR']) {
            $SUBS['ERROR'] = fileParse('_admin_error.htmlt');
        } else {
            runQuery($query, 'setCharts()', 'DEL_CHART_RECORDS');
            $SUBS['COMMAND'] = $PARAM['cmd'] . "&err=20030&WHEN=" . $PARAM['WEEK'] . "&WEEK=" . $PARAM['WEEK'] . "&WHERE=" . $PARAM['WHERE'] . "&PLACES=" . $PARAM['PLACES'];
            printPage('_admin_done.htmlt');
            return;
        }
    }
    //add chart record
    if ($PARAM['Add'] == 1) {
        $SUBS['ERROR'] = '';
        if ($PARAM['NO'] == '') {
            //poziciya w klasaciyata
            $SUBS['ERROR'] = $MSG[20097];
        }
        if ($SUBS['ERROR'] == '' && !is_numeric($PARAM['NO'])) {
            $SUBS['ERROR'] = $MSG[20099];
        }
        //poziciyata dali e cefira
        if ($SUBS['ERROR'] == '' && $PARAM['NO'] > $max) {
            $SUBS['ERROR'] = $MSG[20099];
        }
        //poziciyata dali e po-golyama ot poziciite w klasaciyata
        if ($SUBS['ERROR'] == '' && $PARAM['NO'] < 0) {
            $SUBS['ERROR'] = $MSG[20099];
        }
        //poziciyata dali e po-malka ot nula
        //tipa na filma
        switch ($PARAM['TYPE']) {
            case 'list':
                //list
                if ($SUBS['ERROR'] == '' && $PARAM['FILMS'] == 0) {
                    $SUBS['ERROR'] = $MSG[20026];
                }
                $film = $PARAM['FILMS'];
                break;
            case 'raw':
                //raw
                if ($SUBS['ERROR'] == '' && $PARAM['FILM'] == '') {
                    $SUBS['ERROR'] = $MSG[20027];
                }
                $film = $PARAM['FILM'];
                break;
            default:
                if ($SUBS['ERROR'] == '') {
                    $SUBS['ERROR'] = $MSG[20028];
                }
        }
        switch ($type) {
            case 'kino':
                if ($SUBS['ERROR'] == '' && $PARAM['WEEKS'] == '') {
                    $SUBS['ERROR'] = $MSG[20098];
                }
                //sedmici w klasaciyata
                if ($SUBS['ERROR'] == '' && !is_numeric($PARAM['WEEKS'])) {
                    $SUBS['ERROR'] = $MSG[20100];
                }
                //sedmicite dali sa cefira
                if ($SUBS['ERROR'] == '' && $PARAM['SCREENS'] == '') {
                    $SUBS['ERROR'] = $MSG[20101];
                }
                //ekrani na klasaciyata
                if ($SUBS['ERROR'] == '' && !is_numeric($PARAM['SCREENS'])) {
                    $SUBS['ERROR'] = $MSG[20102];
                }
                //ekranite dali sa cefira
                if ($SUBS['ERROR'] == '' && $PARAM['BO'] == '') {
                    $SUBS['ERROR'] = $MSG[20103];
                }
                //sedmichen prihod na klasaciyata
                /*if (($SUBS['ERROR'] =='' ) && (!is_numeric($PARAM['BO'])))
                		$SUBS['ERROR'] = $MSG[20104];	//sedmichen prihod dali sa cefira*/
                if ($SUBS['ERROR'] == '' && $PARAM['CBO'] == '') {
                    $SUBS['ERROR'] = $MSG[20105];
                }
                //obscht prihod na klasaciyata
                /*if (($SUBS['ERROR'] =='' ) && (!is_numeric($PARAM['CBO'])))
                		$SUBS['ERROR'] = $MSG[20106];	//obscht prihod dali sa cefira*/
                break;
            case 'videodvd':
                if ($SUBS['ERROR'] == '' && $PARAM['WEEKS'] == '') {
                    $SUBS['ERROR'] = $MSG[20098];
                }
                //sedmici w klasaciyata
                if ($SUBS['ERROR'] == '' && !is_numeric($PARAM['WEEKS'])) {
                    $SUBS['ERROR'] = $MSG[20100];
                }
                //sedmicite dali sa cefira
                break;
        }
        if ($SUBS['ERROR'] == '') {
            if ($PARAM['id'] == '') {
                switch ($type) {
                    case 'videodvd':
                        $query = "INSERT INTO {$tbl_1d_videodvd_charts} (\n\t\t\t\t\t\t\t\tChartID,\n\t\t\t\t\t\t\t\tNo,\n\t\t\t\t\t\t\t\tType,\n\t\t\t\t\t\t\t\tFilm,\n\t\t\t\t\t\t\t\tWeeks,\n\t\t\t\t\t\t\t\ttsWhen\n\t\t\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['PLACES']) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['NO']) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['TYPE']) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($film) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['WEEKS']) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['WEEK']) . " )";
                        break;
                    case 'kino':
                        $query = "INSERT INTO {$tbl_1d_kino_charts} (\n\t\t\t\t\t\t\t\tChartID,\n\t\t\t\t\t\t\t\tNo,\n\t\t\t\t\t\t\t\tType,\n\t\t\t\t\t\t\t\tFilm,\n\t\t\t\t\t\t\t\tBoxOffice,\n\t\t\t\t\t\t\t\tcumBoxOffice,\n\t\t\t\t\t\t\t\tWeeks,\n\t\t\t\t\t\t\t\tScreens,\n\t\t\t\t\t\t\t\ttsWhen\n\t\t\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['PLACES']) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['NO']) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['TYPE']) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($film) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['BO']) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['CBO']) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['WEEKS']) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['SCREENS']) . ",\n\t\t\t\t\t\t\t\t" . dbQuote($PARAM['WEEK']) . " )";
                        break;
                }
            } else {
                switch ($type) {
                    case 'videodvd':
                        $query = "UPDATE {$tbl_1d_videodvd_charts} SET\n\t\t\t\t\t\t\t\tChartID = " . dbQuote($PARAM['PLACES']) . ",\n\t\t\t\t\t\t\t\tNo = " . dbQuote($PARAM['NO']) . ",\n\t\t\t\t\t\t\t\tType = " . dbQuote($PARAM['TYPE']) . ",\n\t\t\t\t\t\t\t\tFilm = " . dbQuote($film) . ",\n\t\t\t\t\t\t\t\tWeeks = " . dbQuote($PARAM['WEEKS']) . ",\n\t\t\t\t\t\t\t\ttsWhen = " . dbQuote($PARAM['WEEK']) . " \n\t\t\t\t\t\t\tWHERE ID = " . dbQuote($PARAM['id']);
                        break;
                    case 'kino':
                        $query = "UPDATE {$tbl_1d_kino_charts} SET\n\t\t\t\t\t\t\t\tChartID = " . dbQuote($PARAM['PLACES']) . ",\n\t\t\t\t\t\t\t\tNo = " . dbQuote($PARAM['NO']) . ",\n\t\t\t\t\t\t\t\tType = " . dbQuote($PARAM['TYPE']) . ",\n\t\t\t\t\t\t\t\tFilm = " . dbQuote($film) . ",\n\t\t\t\t\t\t\t\tBoxOffice = " . dbQuote($PARAM['BO']) . ",\n\t\t\t\t\t\t\t\tcumBoxOffice = " . dbQuote($PARAM['CBO']) . ",\n\t\t\t\t\t\t\t\tWeeks = " . dbQuote($PARAM['WEEKS']) . ",\n\t\t\t\t\t\t\t\tScreens = " . dbQuote($PARAM['SCREENS']) . ",\n\t\t\t\t\t\t\t\ttsWhen = " . dbQuote($PARAM['WEEK']) . " \n\t\t\t\t\t\t\tWHERE ID = " . dbQuote($PARAM['id']);
                        break;
                }
            }
            $result = runQuery($query, 'setCharts()', 'SAVE_CHART');
            $SUBS['COMMAND'] = $PARAM['cmd'] . "&err=20107&PLACES=" . $PARAM['PLACES'] . "&WHEN=" . $PARAM['WEEK'] . "&WEEK=" . $PARAM['WEEK'];
            printPage('_admin_done.htmlt');
            return;
        } else {
            $SUBS['ERROR'] = fileParse('_admin_error.htmlt');
        }
    }
    ////----[Mrasnika's] Edition 12.10.2002
    if ($PARAM['WHEN']) {
        $PARAM['Year1'] = date('Y', $PARAM['WHEN']);
        $PARAM['Month1'] = date('m', $PARAM['WHEN']);
        $PARAM['Day1'] = date('d', $PARAM['WHEN']);
    } else {
        if ($PARAM['Day1'] && $PARAM['Month1'] && $PARAM['Year1']) {
            $PARAM['WHEN'] = 1 + strToTime($PARAM['Day1'] . ' ' . $MONTHS2[$PARAM['Month1']] . ' ' . $PARAM['Year1']);
        } else {
            $PARAM['WHEN'] = getNextWeek();
        }
    }
    $SUBS['PREV'] = week($PARAM['WHEN']) - 518400;
    $SUBS['NEXT'] = week($PARAM['WHEN']) + 1026800;
    //show charts records
    switch ($type) {
        case 'kino':
            $query = "SELECT\t{$tbl_1d_kino_charts}.ID,\n\t\t\t\tChartID,\n\t\t\t\tNo,\n\t\t\t\tType,\n\t\t\t\tFilm,\n\t\t\t\tBoxOffice,\n\t\t\t\tcumBoxOffice,\n\t\t\t\tWeeks,\n\t\t\t\tScreens,\n\t\t\t\ttsWhen,\n\t\t\t\t\n\t\t\t\t{$tbl_1d_films}.Title,\n\t\t\t\t{$tbl_1d_films}.OriginalTitle\n\n\t\t\t\tFROM {$tbl_1d_kino_charts}\n\t\t\t\tLEFT JOIN {$tbl_1d_films}\n\t\t\t\t\tON {$tbl_1d_kino_charts}.Type = 'list'\n\t\t\t\t\t\tAND {$tbl_1d_films}.ID = {$tbl_1d_kino_charts}.Film\n\t\t\t\tWHERE {$tbl_1d_kino_charts}.ChartID = " . dbQuote($PARAM['PLACES']) . "\n\t\t\t\t\tAND {$tbl_1d_kino_charts}.tsWhen >= " . week($PARAM['WHEN']) . "\n\t\t\t\t\tAND {$tbl_1d_kino_charts}.tsWhen <= (" . week($PARAM['WHEN']) . "+604799)\n\t\t\t\tORDER BY {$tbl_1d_kino_charts}.No,\n\t\t\t\t\t{$tbl_1d_kino_charts}.BoxOffice";
            break;
        case 'videodvd':
            $query = "SELECT\t{$tbl_1d_videodvd_charts}.ID,\n\t\t\t\tChartID,\n\t\t\t\tNo,\n\t\t\t\tType,\n\t\t\t\tFilm,\n\t\t\t\tWeeks,\n\t\t\t\tWeeks,\n\t\t\t\tWeeks,\n\t\t\t\tWeeks,\n\t\t\t\ttsWhen,\n\t\t\t\t\n\t\t\t\t{$tbl_1d_films}.Title,\n\t\t\t\t{$tbl_1d_films}.OriginalTitle\n\n\t\t\t\tFROM {$tbl_1d_videodvd_charts}\n\t\t\t\tLEFT JOIN {$tbl_1d_films}\n\t\t\t\t\tON {$tbl_1d_videodvd_charts}.Type = 'list'\n\t\t\t\t\t\tAND {$tbl_1d_films}.ID = {$tbl_1d_videodvd_charts}.Film\n\t\t\t\tWHERE {$tbl_1d_videodvd_charts}.ChartID = " . dbQuote($PARAM['PLACES']) . "\n\t\t\t\t\tAND {$tbl_1d_videodvd_charts}.tsWhen >= " . week($PARAM['WHEN']) . "\n\t\t\t\t\tAND {$tbl_1d_videodvd_charts}.tsWhen <= (" . week($PARAM['WHEN']) . "+604799)\n\t\t\t\tORDER BY {$tbl_1d_videodvd_charts}.No ";
            break;
    }
    $result = runQuery($query, 'setCharts()', 'GET_CHART_RECORDS');
    while ($row = db_fetch_row($result)) {
        $SUBS['CHECK'] = $row[0];
        $SUBS['CHARTID'] = $row[1];
        $SUBS['NO2'] = sprintf("%02d", $row[2]);
        if ($row[3] == 'list') {
            if ($row[10]) {
                $SUBS['TITLE'] = htmlEncode($row[10]);
            } else {
                $SUBS['TITLE'] = htmlEncode($row[11]);
            }
            $SUBS['MOVIE'] = $SUBS['ACTION'] . "?cmd=insertfilm&ID={$row['4']}";
        } else {
            $SUBS['TITLE'] = htmlEncode($row[4]);
            $SUBS['MOVIE'] = "javascript:alert('{$MSG['20031']}')";
        }
        $SUBS['PRATI'] = $row[9];
        switch ($type) {
            case 'kino':
                $SUBS['BO2'] = $row[5];
                $SUBS['CBO2'] = $row[6];
                $SUBS['SCREENS2'] = $row[8];
                $SUBS['WEEKS2'] = $row[7];
                $SUBS['SHOWCHARTS'] .= fileParse('_admin_charts_row.htmlt');
                break;
            case 'videodvd':
                $SUBS['WEEKS2'] = $row[7];
                $SUBS['SHOWCHARTS'] .= fileParse('_admin_charts_row2.htmlt');
                break;
        }
        if ($PARAM['Add'] != 1 && $PARAM['id'] == $row[0]) {
            //load form
            $PARAM['PLACES'] = $row[1];
            $PARAM['TYPE'] = $row[3];
            if ($row[3] != 'list') {
                $PARAM['FILM'] = $row[4];
            } else {
                $PARAM['FILMS'] = htmlEncode($row[4]);
            }
            $PARAM['WEEK'] = $row[9];
            $PARAM['NO'] = $row[2];
            switch ($type) {
                default:
                    //kino
                    $PARAM['BO'] = $row[5];
                    $PARAM['CBO'] = $row[6];
                    $PARAM['WEEKS'] = $row[7];
                    $PARAM['SCREENS'] = $row[8];
            }
        }
    }
    //get charts
    $SUBS['CHARTS'] = $PARAM['PLACES'];
    $query = "SELECT ID, Title\n \t\tFROM {$tbl_1d_charts}";
    $result = runQuery($query, 'setCharts()', 'GET_CHARTS');
    while ($row = db_fetch_row($result)) {
        ////----[Mrasnika's] Edition 12.10.2002
        // if ($row[0] == $PARAM['chartid'])
        //	$SUBS['CHARTS'] .= "<OPTION value=\"$row[0]\" SELECTED>".htmlEncode($row[1]);
        //	else $SUBS['CHARTS'] .= "<OPTION value=\"$row[0]\">".htmlEncode($row[1]);
        if (!$s1) {
            //store default chart
            $s1 = $row[0];
            $s2 = $row[1];
        }
        if ($row[0] == $PARAM['PLACES']) {
            $SUBS['CHARTTITLE'] = htmlEncode($row[1]);
        }
        if ($row[0] == $PARAM['PLACES']) {
            $SUBS['PLACES'] .= "<OPTION value=\"{$row['0']}\" SELECTED>" . htmlEncode($row[1]);
        } else {
            $SUBS['PLACES'] .= "<OPTION value=\"{$row['0']}\">" . htmlEncode($row[1]);
        }
    }
    if (!$SUBS['CHARTTITLE']) {
        //no default chart
        $SUBS['CHARTS'] = $s1;
        $SUBS['CHARTTITLE'] = htmlEncode($s2);
    }
    //get oldest week
    switch ($type) {
        default:
            //kino
            $query = "SELECT\tmin({$tbl_1d_kino_charts}.tsWhen)\n\t\t\t\tFROM\t{$tbl_1d_kino_charts}\n\t\t\t\tGROUP BY {$tbl_1d_kino_charts}.ChartID\n\t\t\t\tORDER BY {$tbl_1d_kino_charts}.ChartID=" . dbQuote($PARAM['PLACES']) . " DESC";
            $result = runQuery($query, 'setCharts()', 'GET_OLDEST_WEEK_KINO');
            if ($row = db_fetch_row($result)) {
                $span = $row[0];
            }
            break;
        case 'videodvd':
            //videodvd
            $query = "SELECT\tmin({$tbl_1d_videodvd_charts}.tsWhen)\n\t\t\t\tFROM\t{$tbl_1d_videodvd_charts}";
            $result = runQuery($query, 'setCharts()', 'GET_OLDEST_WEEK_VIDEO');
            if ($row = db_fetch_row($result)) {
                $span = $row[0];
            }
            break;
    }
    if (!$span) {
        $span = getNextWeek();
    }
    ////----[Mrasnika's] Edition 12.10.2002
    // $SUBS['WEEK'] = getWeeks($PARAM['WEEK']);
    // $SUBS['WHEN'] = getWeeks($PARAM['WHEN']);
    //compatibility
    if (!$PARAM['WHEN']) {
        //no date applied
        if (!$PARAM['Day1'] || !$PARAM['Month1'] || !$PARAM['Year1']) {
            $PARAM['WHEN'] = getNextWeek();
            $PARAM['Year1'] = date('Y', $PARAM['WHEN']);
            $PARAM['Month1'] = date('m', $PARAM['WHEN']);
            $PARAM['Day1'] = date('d', $PARAM['WHEN']);
        } else {
            $PARAM['WHEN'] = 1 + strToTime($PARAM['Day1'] . ' ' . $MONTHS2[$PARAM['Month1']] . ' ' . $PARAM['Year1']);
        }
    } else {
        //load date form
        $PARAM['Year1'] = date('Y', $PARAM['WHEN']);
        $PARAM['Month1'] = date('m', $PARAM['WHEN']);
        $PARAM['Day1'] = date('d', $PARAM['WHEN']);
    }
    if ($span > $PARAM['WHEN']) {
        //ima data, no e po-malka ot naj-starata klasaciya
        $SUBS['COMMAND'] = $PARAM['cmd'] . "&WHEN={$span}&PLACES=" . $PARAM['PLACES'];
        printPage('_admin_done.htmlt');
        return;
    }
    $Year2 = 1 + date('Y', max($PARAM['WHEN'], time()));
    $Year1 = date('Y', $span);
    for ($i = $Year1; $i <= $Year2; $i++) {
        if ($i == $PARAM['Year1']) {
            $SUBS['YEAR1'] .= "<OPTION value=\"{$i}\" selected>{$i}";
        } else {
            $SUBS['YEAR1'] .= "<OPTION value=\"{$i}\">{$i}";
        }
    }
    for ($i = 1; $i <= 12; $i++) {
        if ($i == $PARAM['Month1']) {
            $SUBS['MONTH1'] .= "<OPTION value=\"{$i}\" selected>" . $MONTHS[$i];
        } else {
            $SUBS['MONTH1'] .= "<OPTION value=\"{$i}\">" . $MONTHS[$i];
        }
    }
    for ($i = 1; $i <= 31; $i++) {
        if ($i == $PARAM['Day1']) {
            $SUBS['DAY1'] .= "<OPTION value=\"{$i}\" selected>" . sprintf('%02d', $i);
        } else {
            $SUBS['DAY1'] .= "<OPTION value=\"{$i}\">" . sprintf('%02d', $i);
        }
    }
    $SUBS['WEEK'] = $PARAM['WHEN'];
    $SUBS['DISPLAYWEEK'] = displayWeek($SUBS['WEEK']);
    //get films
    switch ($type) {
        case 'kino':
            $query = "SELECT\t{$tbl_1d_films}.ID,\n\t\t\t\tTitle,\n\t\t\t\tOriginalTitle\n\t\t\tFROM {$tbl_1d_films}\n\t\t\tLEFT JOIN {$tbl_1d_videodvd}\n\t\t\t\tON {$tbl_1d_videodvd}.FilmID = {$tbl_1d_films}.ID\n\t\t\tWHERE\t{$tbl_1d_videodvd}.ID IS NULL\n\t\t\tGROUP BY {$tbl_1d_films}.ID\n\t\t\tORDER BY OriginalTitle !='' DESC, Title='' DESC";
            break;
        case 'videodvd':
            $query = "SELECT\t{$tbl_1d_films}.ID, Title\n\t\t\tFROM {$tbl_1d_films}\n\t\t\tLEFT JOIN {$tbl_1d_videodvd}\n\t\t\t\tON {$tbl_1d_videodvd}.FilmID = {$tbl_1d_films}.ID\n\t\t\tWHERE\t{$tbl_1d_videodvd}.ID IS NOT NULL\n\t\t\tGROUP BY {$tbl_1d_films}.ID\n\t\t\tORDER BY Title DESC";
            break;
    }
    $result = runQuery($query, 'setCharts()', 'GET_FILMS');
    while ($row = db_fetch_row($result)) {
        //fix titles
        if (!$row[1]) {
            $row[1] = $row[2];
        }
        if ($PARAM['FILMS'] == $row[0]) {
            ////----[Mrasnika's] Edition 12.10.2002
            // $SUBS['FILM'] .= "\n<option value=\"$row[0]\" selected>".htmlEncode("$row[1] $row[2] ");
            // else $SUBS['FILM'] .= "\n<option value=\"$row[0]\">".htmlEncode("$row[1] $row[2] ");
            $SUBS['FILM'] .= "\n<option value=\"{$row['0']}\" selected>" . htmlEncode($row[1]);
        } else {
            $SUBS['FILM'] .= "\n<option value=\"{$row['0']}\">" . htmlEncode($row[1]);
        }
    }
    // display
    $SUBS['TYPE' . strToUpper($PARAM['TYPE'])] = ' checked ';
    $SUBS['FILM2'] = htmlEncode($PARAM['FILM']);
    $SUBS['NO'] = htmlEncode($PARAM['NO']);
    switch ($type) {
        default:
            //kino
            $SUBS['WEEKS'] = htmlEncode($PARAM['WEEKS']);
            $SUBS['SCREENS'] = htmlEncode($PARAM['SCREENS']);
            $SUBS['BO'] = htmlEncode($PARAM['BO']);
            $SUBS['CBO'] = htmlEncode($PARAM['CBO']);
            $SUBS['DISPLAYCHART'] = fileParse("_admin_charts_kino.htmlt");
            break;
        case 'videodvd':
            //video & dvd
            $SUBS['WEEKS'] = htmlEncode($PARAM['WEEKS']);
            $SUBS['DISPLAYCHART'] = fileParse("_admin_charts_videodvd.htmlt");
            break;
    }
    $SUBS['ID'] = htmlEncode($PARAM['id']);
    if ($PARAM['err'] != '' && $SUBS['ERROR'] == '') {
        $SUBS['ERROR'] = $MSG[$PARAM['err']];
        $SUBS['ERROR'] = fileParse('_admin_error.htmlt');
    }
    printPage('_admin_charts.htmlt');
}
コード例 #3
0
$SUBS['NO'] = $PARAM['NO'];
$SUBS['TYPE' . strtoupper($PARAM['TYPE'])] = ' checked';
//get oldest week
$query = "SELECT min(tsWhen) FROM {$tbl_1d_agenda}";
$result = runQuery($query, 'manageAgenda()', 'GET_OLDEST_WEEK');
if ($row = db_fetch_row($result)) {
    global $span;
    $span = $row[0];
}
////----[Mrasnika's] Edition 02.10.2002
// $SUBS['WHEN'] = getWeeks($PARAM['WHEN']);
//compatibility
if (!$PARAM['WHEN']) {
    //no date applied
    if (!$PARAM['Day1'] || !$PARAM['Month1'] || !$PARAM['Year1']) {
        $PARAM['WHEN'] = getNextWeek();
        $PARAM['Year1'] = date('Y', $PARAM['WHEN']);
        $PARAM['Month1'] = date('m', $PARAM['WHEN']);
        $PARAM['Day1'] = date('d', $PARAM['WHEN']);
    } else {
        $PARAM['WHEN'] = 1 + strToTime($PARAM['Day1'] . ' ' . $MONTHS2[$PARAM['Month1']] . ' ' . $PARAM['Year1']);
    }
} else {
    //load date form
    $PARAM['Year1'] = date('Y', $PARAM['WHEN']);
    $PARAM['Month1'] = date('m', $PARAM['WHEN']);
    $PARAM['Day1'] = date('d', $PARAM['WHEN']);
}
if ($span > $PARAM['WHEN']) {
    //ima data, no e po-malka ot naj-starata programa
    $SUBS['COMMAND'] = $PARAM['cmd'] . "&WHERE=" . $PARAM['WHERE'] . "&WHEN={$span}&WEEK={$span}&PLACES=" . $PARAM['PLACES'];