1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
|
<?php
/***************************************
* Description: Datum
*
* Vprašanje je prisotno:
* tip 8
*
* Autor: Robert Šmalc
* Created date: 09.03.2016
*****************************************/
namespace App\Controllers\Vprasanja;
// Osnovni razredi
use App\Controllers\Controller;
use App\Controllers\HelperController as Helper;
use App\Controllers\LanguageController as Language;
use App\Models\Model;
use enkaParameters;
// Iz admin/survey
// Vprašanja
class DatumController extends Controller
{
public function __construct()
{
parent::getGlobalVariables();
}
/************************************************
* Get instance
************************************************/
private static $_instance;
public static function getInstance()
{
if (self::$_instance)
return self::$_instance;
return new DatumController();
}
public function display($spremenljivka, $oblika)
{
$row = Model::select_from_srv_spremenljivka($spremenljivka);
$loop_id = get('loop_id') == null ? " IS NULL" : " = '" . get('loop_id') . "'";
$spremenljivkaParams = new enkaParameters($row['params']);
$selected = Model::getOtherValue($spremenljivka);
# pogledamo ali imamo kak zapis v srv_data_vrednost. potem je to najbrž missing
$is_missing = false;
$srv_data_vrednost = array();
# če je bilo vprašanje preskočeno se je vs srv_data_vrednost zapisalo -2, če se potem uporabnik vrne, in spremeni pogojno vprašanje
# se potem datum ni prikazoval. ke je bilo v bazi -2, zato sem dal da naj poišče samo če vrednost ni -2
$sql2_c = sisplet_query("SELECT vre_id FROM srv_data_vrednost" . get('db_table') . " WHERE spr_id='$spremenljivka' AND usr_id='" . get('usr_id') . "' AND loop_id $loop_id AND vre_id NOT IN ('-1','-2')");
while ($row2_c = mysqli_fetch_assoc($sql2_c)) {
$srv_data_vrednost[$row2_c['vre_id']] = true;
$is_missing = true;
}
echo '<div class="variabla' . $oblika['cssFloat'] . '">' . "\n";
$sql1 = sisplet_query("SELECT text FROM srv_data_text" . get('db_table') . " WHERE spr_id='$spremenljivka' AND usr_id='" . get('usr_id') . "' AND loop_id $loop_id");
$row1 = mysqli_fetch_array($sql1);
echo '<input type="text" id="vrednost_' . $spremenljivka . '" name="vrednost_' . $spremenljivka . '" value="' . $row1['text'] . '"
onkeyup="checkBranching();" ' . ($is_missing ? ' disabled' : '') . ' readonly="true"> ';
echo '</div>' . "\n";
$array_others = array();
$sql_other = sisplet_query("SELECT id,naslov FROM srv_vrednost WHERE spr_id='$spremenljivka' AND vrstni_red > 0 AND other != '0' ORDER BY vrstni_red");
while ($other = mysqli_fetch_array($sql_other)) {
# imamo polje drugo - ne vem, zavrnil...
$_id = 'missing_value_spremenljivka_' . $spremenljivka . '_vrednost_' . $other['id'];
if ($srv_data_vrednost[$other['id']]) {
$sel = true;
} else {
$sel = false;
}
# če nimamo missingov in je trenutni enak izbranemu, ali če imamo misinge inje trenutni enak izbranemu misingu
$_checked = ($sel ? ' checked' : '');
// Ali skrivamo missing ne vem in ga prikazemo sele ob opozorilu
$hide_missing = false;
$already_set_mv = array();
$sql_grid_mv = sisplet_query("SELECT naslov, other FROM srv_vrednost WHERE spr_id='" . $spremenljivka . "' AND other != 0");
while ($row_grid_mv = mysqli_fetch_array($sql_grid_mv)) {
$already_set_mv[$row_grid_mv['other']] = $row_grid_mv['naslov'];
}
if ((($row['alert_show_99'] > 0 && isset($already_set_mv['-99']) && $already_set_mv['-99'] == $other['naslov'])
|| ($row['alert_show_98'] > 0 && isset($already_set_mv['-98']) && $already_set_mv['-98'] == $other['naslov'])
|| ($row['alert_show_97'] > 0 && isset($already_set_mv['-97']) && $already_set_mv['-97'] == $other['naslov']))
&& $_checked == ''
)
$hide_missing = true;
$naslov = Language::getInstance()->srv_language_vrednost($other['id']);
if ($naslov != '') $other['naslov'] = $naslov;
echo '<div class="variabla' . $oblika['cssFloat'] . ' missing" id="vrednost_if_' . $other['id'] . '"' . ' ' . ($hide_missing ? ' style="display:none"' : '') . '>';
echo '<label for="' . $_id . '">';
echo '<input type="checkbox" name="vrednost_mv_' . $spremenljivka . '[]" id="' . $_id . '" value="' . $other['id'] . '"' . $_checked . ' onclick="checkBranching(); checkMissing(this);"> ';
// Font awesome checkbox
echo '<span class="enka-checkbox-radio" '.((Helper::getCustomCheckbox() != 0) ? 'style="font-size:' . Helper::getCustomCheckbox() . 'px;"' : '').'></span>';
echo '' . $other['naslov'] . '</label>';
echo '</div>';
}
# če smo v quick_view mode ne omogočamo
if (get('quick_view') == false) {
$date_element = "#vrednost_" . $spremenljivka;
// Ce izbiramo tudi cas - V DELU
$timepicker = ($spremenljivkaParams->get('date_withTime') > 0) ? 'true' : 'false';
?>
<script type="text/javascript">
$(document).ready(function () {
datepicker("<?=$date_element?>", <?=($_GET['a'] != 'preview_spremenljivka' ? 'true' : 'false')?>, <?=$timepicker?>);
<?php
# dodamo date range
echo Helper::getDatepickerRange($spremenljivka, $date_element);
echo '$( "' . $date_element . '" ).datepicker( "option", "closeText", \'' . self::$lang['srv_clear'] . '\');';
echo '$( "' . $date_element . '" ).datepicker( "option", "showOn", \'button\');';
echo '$( "' . $date_element . '" ).datepicker( "option", "showButtonPanel", true);';
// Gumb pocisti vrednost na dnu
echo '$("' . $date_element . '").datepicker( "option", {
beforeShow: function( input ) {
setTimeout(function() {
var clearButton = $(input )
.datepicker( "widget" )
.find( ".ui-datepicker-close" );
clearButton.unbind("click").bind("click",function(){$.datepicker._clearDate( input );});
}, 1 );
}
});';
// Moznost, da so disablani specificni datumi - V DELU
if(false){
$disabled_dates = array('01-01-2017', '03-01-2017');
// Ce imamo kaksen datum nastavljen
if(!empty($disabled_dates)){
$disabled_dates_string = implode('","', $disabled_dates);
$disabled_dates_string = '"'.$disabled_dates_string.'"';
echo '$("' . $date_element . '").datepicker("option", "beforeShowDay", DisableSpecificDates);';
echo 'function DisableSpecificDates(date) {
var disableddates = ['.$disabled_dates_string.'];
var string = jQuery.datepicker.formatDate(\'dd-mm-yy\', date);
return [disableddates.indexOf(string) == -1];
}';
}
}
// TODO zakaj je tole? - $condition manjka in itak ne dela
# mogoče za missinge pr datumu ??
/*echo
'$("input#text_' . $condition . '").bind("keyup", {}, function(e) {' .
' checkBranchingDate(); $(\'#vrednost_' . $spremenljivka . '\').trigger(\'change\'); return false; ' .
'});';*/
?>
});
</script>
<?php
}
}
}
|
