<?php

include '../../include/conf.inc.php';
include '../../include/functions.inc.php';
include '../../include/classes/mysql.inc.php';
include '../../include/classes/utils.class.php';
header('Content-type: text/css');
$expireOffcet = '3600';
header('Cache-Control: max-age='.$expireOffcet.', public');
header('Expires: '.gmdate(RFC1123, time() + $expireOffcet).' GMT');

$cacheFile = getCacheFile();
if(is_file($cacheFile) && !cacheExpired($cacheFile)) {
  readfile($cacheFile);
  exit; 
}

ob_start();
$pageId = intval($_GET['pid']);
$SITEID = intval($_GET['sid']);
$sql = "SELECT
          ep.class,
          pt.csstag,
          pt.csstag2,
          pt.tag,
          pt.islink,
          pt.ishover,
          IFNULL(eps.val, ep.val) AS val,
          IF(eps.val IS NULL, 1, 0) AS isdefault,
          IFNULL(eps.width, ep.width) AS width,
          IFNULL(eps.height, ep.height) AS height,
          IF(ep.class IS NULL OR ep.class='' OR LEFT(ep.class,3)='###',CONCAT('.style', IFNULL(es.id,'0'),' ',SUBSTRING(ep.class, 4), IF(pt.islink=1,' a',' '), IF(pt.ishover=1,' a:hover',' ')), IFNULL(ep.class,'')) AS classname
        FROM
          elementproperties AS ep
        INNER JOIN
          propertytypes AS pt
        ON
          pt.id=ep.type_id
        LEFT JOIN
          elementstyles AS es
        ON
          ep.elementtype_id=es.elementtype_id AND
          es.site_id=$SITEID AND
          es.id IN
          ".(intval($_GET['cels'])?"
          (SELECT DISTINCT
                      e.style_id
                    FROM
                      pages_elements AS pel
                    INNER JOIN elements AS e ON e.id=pel.element_id
                    WHERE pel.page_id=$pageId AND e.site_id=$SITEID
                    ORDER BY pel.weight DESC)
          ":"
          (SELECT style_id FROM elements WHERE assigned=1)
          ")."

        LEFT JOIN
          elementproperties_sites eps
        ON
          eps.style_id=es.id AND
          eps.property_id=ep.id";
$sql = "SELECT
          ep.class,
          pt.csstag,
          pt.csstag2,
          pt.tag,
          pt.islink,
          pt.ishover,
          IFNULL(eps.val, ep.val) AS val,
          IF(eps.val IS NULL, 1, 0) AS isdefault,
          IFNULL(eps.width, ep.width) AS width,
          IFNULL(eps.height, ep.height) AS height,
          IF(ep.class IS NULL OR ep.class='' OR LEFT(ep.class,3)='###',CONCAT('.style', IFNULL(es.id,'0'),' ',SUBSTRING(ep.class, 4), IF(pt.islink=1,' a',' '), IF(pt.ishover=1,' a:hover',' ')), IFNULL(ep.class,'')) AS classname1,
          CONCAT(REPLACE(ep.class,'###',CONCAT('.style', IFNULL(es.id,'0'))),IF(pt.islink=1,' a',' '), IF(pt.ishover=1,' a:hover',' ')) AS classname
        FROM
          elementproperties AS ep
        INNER JOIN
          propertytypes AS pt
        ON
          pt.id=ep.type_id
        LEFT JOIN
          elementstyles AS es
        ON
          ep.elementtype_id=es.elementtype_id AND
          es.site_id=$SITEID AND
          es.id IN
          ".(intval($_GET['cels'])?"
          (SELECT DISTINCT
                      e.style_id
                    FROM
                      pages_elements AS pel
                    INNER JOIN elements AS e ON e.id=pel.element_id
                    WHERE pel.page_id=$pageId AND e.site_id=$SITEID
                    ORDER BY pel.weight DESC)
          ":"
          (SELECT style_id FROM elements WHERE assigned=1)
          ")."

        LEFT JOIN
          elementproperties_sites eps
        ON
          eps.style_id=es.id AND
          eps.property_id=ep.id";

//echo "/*\n$sql\n*/";


$res = DB::Query($sql);
$tmp = array();
while($row = DB::FetchArray($res)){
  $tmp[$row['classname']][] = $row;
}
foreach ($tmp as $k=>$v){
  echo "$k{";
  foreach ($v as $vv) {
    if(!$vv['val'])// || mb_strtoupper($vv['val']) == 'TRANSPARENT')
      continue;

    if($vv['tag'] == 'IMAGE'){
      $imgPath = Site::GetDesignPreviewPath($SITEID);
      if($vv['isdefault'])
        $imgPath = DESIGN_PREVIEW_PATH;
      echo $vv['csstag'].$imgPath.$vv['val'].$vv['csstag2'];
      //echo 'width: '.$vv['width'].'px;';
      //echo 'height: '.$vv['height'].'px;';
    }
  	else
  	  echo (mb_strtoupper($vv['val']) == 'TRANSPARENT'?str_replace('#', 'transparent', $vv['csstag']):$vv['csstag'].$vv['val']).$vv['csstag2'];
  }
  echo "}\n";
}
$css = ob_get_contents();
file_put_contents($cacheFile, $css);
header('Content-Length: '.mb_strlen($css));
ob_end_flush();
?>