Example #1
0
 function GetChartLink($src, $row)
 {
     if ($src != "" && is_array($row)) {
         $cntrow = count($row);
         $lnk = $src;
         $sdt = $this->SeriesDateType;
         $xdt = $this->XAxisDateFormat;
         $ndt = $this->ChartType == 20 ? $this->NameDateFormat : "";
         if ($sdt != "") {
             $xdt = $sdt;
         }
         if (preg_match("/&t=([^&]+)&/", $lnk, $m)) {
             $tblcaption = $GLOBALS["ReportLanguage"]->TablePhrase($m[1], 'TblCaption');
         } else {
             $tblcaption = "";
         }
         for ($i = 0; $i < $cntrow; $i++) {
             // Link format: %i:Parameter:FieldType%
             if (preg_match("/%" . $i . ":([^%:]*):([\\d]+)%/", $lnk, $m)) {
                 $fldtype = ewr_FieldDataType($m[2]);
                 if ($i == 0) {
                     // Format X SQL
                     $lnk = str_replace($m[0], ewr_Encrypt(ewr_ChartXSQL("@" . $m[1], $fldtype, $row[$i], $xdt)), $lnk);
                 } elseif ($i == 1) {
                     // Format Series SQL
                     $lnk = str_replace($m[0], ewr_Encrypt(ewr_ChartSeriesSQL("@" . $m[1], $fldtype, $row[$i], $sdt)), $lnk);
                 } else {
                     $lnk = str_replace($m[0], ewr_Encrypt("@" . $m[1] . " = " . ewr_QuotedValue($row[$i], $fldtype)), $lnk);
                 }
             }
         }
         return "javascript:" . ewr_DrillDownJs($lnk, $this->ID, $tblcaption, $this->UseDrillDownPanel, "div_" . $this->ID, FALSE);
     } else {
         return "";
     }
 }
        $sWhereWrk = "";
        // Call Lookup selecting
        $Page->Lookup_Selecting($Page->dateCreated, $sWhereWrk);
        if ($sWhereWrk != "") {
            $sSqlWrk .= " WHERE " . $sWhereWrk;
        }
        $sSqlWrk .= " ORDER BY YEAR(`dateCreated`)";
        ?>
<input type="hidden" name="s_sv_dateCreated" id="s_sv_dateCreated" value="s=<?php 
        echo ewr_Encrypt($sSqlWrk);
        ?>
&amp;f0=<?php 
        echo ewr_Encrypt("`dateCreated` = {filter_value}");
        ?>
&amp;t0=133&amp;ds=Year&amp;df=5&amp;dlm=<?php 
        echo ewr_Encrypt($Page->dateCreated->FldDelimiter);
        ?>
"></span>
</div>
</div>
</div>
</form>
<script type="text/javascript">
fJop_Position_Vs_Job_Offered_Candidatessummary.Init();
fJop_Position_Vs_Job_Offered_Candidatessummary.FilterList = <?php 
        echo $Page->GetFilterList();
        ?>
;
</script>
<!-- Search form (end) -->
<?php 
Example #3
0
    echo $wrkonchange;
    ?>
>
<?php 
    $sSqlWrk = "SELECT DISTINCT DATE_FORMAT(`timeta`, '%d/%m/%Y'), DATE_FORMAT(`timeta`, '%d/%m/%Y') AS `DispFld` FROM `view1`";
    $sWhereWrk = "DATE_FORMAT(`timeta`, '%d/%m/%Y') LIKE '{query_value}%'";
    // Call Lookup selecting
    $Page->Lookup_Selecting($Page->timeta, $sWhereWrk);
    if ($sWhereWrk != "") {
        $sSqlWrk .= " WHERE " . $sWhereWrk;
    }
    $sSqlWrk .= " ORDER BY DATE_FORMAT(`timeta`, '%d/%m/%Y')";
    $sSqlWrk .= " LIMIT " . EWR_AUTO_SUGGEST_MAX_ENTRIES;
    ?>
<input type="hidden" name="q_sv_timeta" id="q_sv_timeta" value="s=<?php 
    echo ewr_Encrypt($sSqlWrk);
    ?>
">
<script type="text/javascript">
fview1rpt.CreateAutoSuggest("sv_timeta", false);
</script>
</span>
</div>
</div>
<div class="ewRow"><input type="submit" name="btnsubmit" id="btnsubmit" class="btn btn-primary" value="<?php 
    echo $ReportLanguage->Phrase("Search");
    ?>
">
<input type="reset" name="btnreset" id="btnreset" class="btn hide" value="<?php 
    echo $ReportLanguage->Phrase("Reset");
    ?>