Archives
= UNIX_TIMESTAMP( '" . $zDateStartBase . "' ) AND `timestamp` <= UNIX_TIMESTAMP( '" . $zDateEndBase . "')";
}
$tozValues = "";
if (isset($_POST['txtValueAll']) && $_POST['txtValueAll']!= '')
{
$tzValues = explode('|||',$_POST['txtValueAll']);
foreach($tzValues as $values)
{
if ($values != '')
$zWhereFileName .= " AND (filename like '%" . $values . "%') ";
}
}
$zSql = "SELECT *, DATE_FORMAT(DATE( FROM_UNIXTIME( `timestamp` ) ), '%d/%m/%Y' )AS pDate FROM file_managed where filemime = 'application/pdf' AND " . $zWhereFileDateBetween . ' AND ' . $zWhereFileName;
/*echo($zSql);*/
$results = $db->query($zSql);
$zBlock = "
"; if (isset ($_GET['type'])) { echo(''); $zBlock = ""; } else { if (!isset($_POST['type2'])) { echo(''); } else { echo(''); } } if ($iCount ==0) { $zBlock = "No record ..."; } echo($zBlock); ?>
- ";
$zPath = "sites/default/files/";
$iCount = 0;
foreach($results as $result)
{
$zBlock .= "
- " . $result->filename . " "; $iCount++; } $zBlock .="
"; if (isset ($_GET['type'])) { echo(''); $zBlock = ""; } else { if (!isset($_POST['type2'])) { echo(''); } else { echo(''); } } if ($iCount ==0) { $zBlock = "No record ..."; } echo($zBlock); ?>