require_once '../conf/login.php';
$mssqlConn = sqlsrv_connect($serverName, $connectionInfo);
if ($mssqlConn === false) {
die(print_r(sqlsrv_errors(), true));
}
//Получаем полную информацию для каждой вкладки.
$tab = $_POST['tab'];
$predicate = $_POST['queryId'];
//Функиции получения данных и отрисовки таблицы
//GetInfo($mssqlConn,$tab);
//Формируем заголовоки столбцов таблицы и строки для поиска
$thead = MakeTableHead(GetTableHeaders($mssqlConn, $tab), $tab);
//Содержимое таблицы
$tbody = GetTableData($mssqlConn, $tab, $predicate);
//Отрисовка таблицы
DrawTable($thead, $tbody);
function GetTableHeaders($conn, $table)
{
$queryFields = "Select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME ='" . $table . "'";
$resultFields = sqlsrv_query($conn, $queryFields) or die(print_r(sqlsrv_errors(), true));
return $resultFields;
}
function MakeTableHead($th, $tid)
{
//Заголовоки столбцов
$headersCount = 0;
$tableHead = '<table class="table" border="1" id="' . $tid . 'Table"> <thead><tr>';
while ($row = sqlsrv_fetch_array($th, SQLSRV_FETCH_NUMERIC)) {
$tableHead .= '<td>' . $row[0] . '</td>';
$headersCount++;
}
</td>
<td>
<input type="checkbox" name="exclude_washing" id="exclude_washing" value="Y" <?=($with_out_washing == true )? "checked=\"checked\"" : "" ?> />
</td>
</tr>
<tr>
<td>
<button><?=GetMessage('FORM_LABEL_CALCULATE')?></button>
</td>
</tr>
</table>
</form>
</div>
<div id="result-container">
<?=( (isset( $result["TO"] ) == true)? DrawTable ( $result, $with_out_washing ) : '' )?>
<br/><br/>
<?//=( (isset( $result["TO"] ) == true)? DrawTable2( $result, $with_out_washing ) : '' )?>
</div>
<script>
$(function() {
$( "#slider" ).slider();
$( "#run_at_year" ).spinner({ value: <?=($ry > 0 )? $ry : 20000 ?>, min: 10000, max: 400000, step:1000});
$( "#years_of_work" ).spinner({min: 1, max: 10, step:1});
var mileage = $( "#mileage" ).spinner({min:10000,step:1000,value:$(this).attr('value')});
var discount = $( "#discount" ).spinner({step:0.5,});
var chassis = $( "#chassis" );
