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); ?> &f0=<?php echo ewr_Encrypt("`dateCreated` = {filter_value}"); ?> &t0=133&ds=Year&df=5&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
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"); ?>