diff options
Diffstat (limited to 'admin/survey/classes/class.SurveyAapor.php')
| -rw-r--r-- | admin/survey/classes/class.SurveyAapor.php | 590 |
1 files changed, 590 insertions, 0 deletions
diff --git a/admin/survey/classes/class.SurveyAapor.php b/admin/survey/classes/class.SurveyAapor.php new file mode 100644 index 0000000..1418f60 --- /dev/null +++ b/admin/survey/classes/class.SurveyAapor.php @@ -0,0 +1,590 @@ +<?php
+
+class SurveyAapor {
+
+ private $userBy = array();
+ private $_surveyId;
+ private $_aapor = array();
+
+ public $usability = array();
+ public $userByStatus = array();
+ //public $cntUserByStatus = array('valid'=>0, 'nonvalid'=>0, 'invitation'=>0);
+ public $cntUserByStatus = array();
+ public $appropriateStatus = array(6,5);
+ public $unAppropriateStatus = array('6l','5l',4,3);
+ public $invitationStatus = array(2,1,0);
+ public $testDataCount = 0;
+
+ public $cntValidRedirections = 0; // Stejemo vlejavne referale (ki vsebujejo tekst)
+ public $cntNonValidRedirections = 0; // Stejemo neveljavne referale (ki ne vsebujejo teksta)
+ public $userRedirections = array(3=>0,4=>0,5=>0,6=>0,'valid' => array('email'=>0),'email'=>0,'direct'=>0); // za porazdelitev redirekcij na anketo
+ public $maxRedirection = 0; // koliko je maksimalno število klikov (za primerno širino diva)
+ public $maxCharRedirection = 0; // max stevilo znakovv v "host" (za lepsi izpis redirekcij)
+
+ public $realUsersByStatus_all = 0; // skupaj frekvenc
+ public $realUsersByStatus = array(); // frekvenca po posameznem statusu (uposeteva da ce je kdo koncal anketo jo je tudi zacel)
+ public $respondentLangArray = array(); # grupiranje po jezikih
+
+ public $tmp_direct = 0;
+ public $emailStatus = array(0,1,2);
+
+ function __construct($cntAnswers,$answers,$surveyId) {
+ global $lang;
+
+ $this->cntUserByStatus = $cntAnswers;
+ $this->userByStatus = $answers;
+ $this->_surveyId = $surveyId;
+ //$this->izracunajPodatke($this->_surveyId);
+ //error_log("ID: ".$surveyId);
+
+ $sur = new SurveyUsableResp($surveyId, $generateDatafile=false);
+
+ if(!$sur->hasDataFile())
+ echo $lang['srv_dashboard_no_file']; // Ce se ni zgenerirana datoteka s podatki izpisemo error
+ else
+ $this->usability = $sur->calculateData(); // Dobimo array z usability podatki
+ //var_dump($this->usability);
+
+ $page = $_GET['m'];
+
+ if(strcmp($page,'aapor2') == 0)
+ $this->calculateFullAapor();
+ else if(strcmp($page,'aapor1') == 0)
+ $this->calculateAapor();
+ }
+
+ function calculateAapor() {
+ global $lang;
+ $s6 = (int)$this->userByStatus['valid'][6];
+ $s5 = (int)$this->userByStatus['valid'][5];
+ $s6l = (int)$this->userByStatus['nonvalid']['6l'];
+ $s5l = (int)$this->userByStatus['nonvalid']['5l'];
+ $s4 = (int)$this->userByStatus['nonvalid'][4];
+ $s3 = (int)$this->userByStatus['nonvalid'][3];
+ $s2 = (int)$this->userByStatus['nonvalid'][2];
+ $s1 = (int)$this->userByStatus['nonvalid'][1];
+ $s0 = (int)$this->userByStatus['nonvalid'][0];
+ $s_1 = (int)$this->userByStatus['nonvalid'][-1];
+
+
+
+ /* debug
+ echo '<br>'.$s6;
+ echo '<br>'.$s5;
+ echo '<br>'.$s6l;
+ echo '<br>'.$s5l;
+ echo '<br>'.$s4;
+ echo '<br>'.$s3;
+ echo '<br>'.$s2;
+ echo '<br>'.$s1;
+ echo '<br>'.$s0;
+ echo '<br>'.$s_1;
+ */
+
+ /* Po starem še
+ * $rr1 = @$s6 / ( ($s6+$s5)+($s6l+$s5l+$s4+$s3+$s1)+($s2+$s0));
+ $rr2 = @($s6+$s5) / ( ($s6+$s5)+($s6l+$s5l+$s4+$s3+$s1)+($s2+$s0));
+ $rr3 = @$s6 / ( ($s6+$s5)+($s6l+$s5l+$s4+$s3+$s1)+0.5*($s2+$s0));
+ $rr4 = @($s6+$s5) / ( ($s6+$s5)+($s6l+$s5l+$s4+$s3+$s1)+0.5*($s2+$s0));
+ $rr5 = @$s6 / ( ($s6+$s5)+($s6l+$s5l+$s4+$s3+$s1));
+ $rr6 = @($s6+$s5) / ( ($s6+$s5)+($s6l+$s5l+$s4+$s3+$s1));
+
+ $con1 = @($s6+$s5+$s6l+$s5l+$s4+$s3) / ( ($s6+$s5)+($s6l+$s5l+$s4+$s3+$s1)+($s2+$s0));
+ $con2 = @($s6+$s5+$s6l+$s5l+$s4+$s3) / ( ($s6+$s5)+($s6l+$s5l+$s4+$s3+$s1)+0.5*($s2+$s0));
+ $con3 = @($s6+$s5+$s6l+$s5l+$s4+$s3) / ( ($s6+$s5)+($s6l+$s5l+$s4+$s3+$s1));
+
+ $pror = @($s6+$s5) / ( ($s6+$s5)+($s6l+$s5l+$s4+$s3+$s1));
+ $comr = @($s6+$s5) / ( ($s6+$s5)+($s6l+$s5l+$s4+$s3+$s1));
+
+
+
+
+ pregledovanje
+ $crr = $pror * $comr;
+ */
+
+
+ //$this->izracunajPodatke($this->_surveyId);
+ $usable = $this->usability['usable'];
+ $partusable = $this->usability['partusable'];
+ $all = $this->usability['all'];
+ $niodgo = (int)$this->_answwers['invitation'][1];
+ $rr1_apro = 0;
+ $rr2_apro = 0;
+ $rr5_apro = 0;
+ $rr6_apro = 0;
+ if($all > 0){
+ $rr1_apro = $this->formatNumber(($usable)/$all,3,'');
+ //$rr5_apro = $this->formatNumber(($usable)/($all-$niodgo),3,'');
+ $rr2_apro = $this->formatNumber(($usable+$partusable)/$all,3,'');
+ //$rr6_apro = $this->formatNumber(($usable+$partusable)/($all-$niodgo),3,'');
+ }
+
+ echo '<div class="floatLeft">';
+ //echo 'Uporabni: '.$usability['usable'].'<br> Delno uporabni: '.$usability['partusable'].'<br> Vsi:'.$usability['all'].'<br><br>';
+ echo '<b>'.$lang['srv_aapor_show_approximate_calculation'].'</b><br>';
+ echo '<label>RR1\': '.$rr1_apro.'</label><br>';
+ echo '<label>RR2\': '.$rr2_apro.'</label><br>';
+ //echo '<label>RR5\': '.$rr5_apro.'</label><br>';
+ //echo '<label>RR6\': '.$rr6_apro.'</label><br>';
+ echo '</div>';
+ /*echo '<b>AAPOR response rate glede na 1KA statuse:</b>';
+ echo '<br />RR1 = '.$this->formatNumber($rr1,3,'');
+ echo '<br />RR2 = '.$this->formatNumber($rr2,3,'');
+ echo '<br /><span class="red strong">RR3 = '.$this->formatNumber($rr3,3,'').'</span>';
+ echo '<br />RR4 = '.$this->formatNumber($rr4,3,'');
+ echo '<br />RR5 = '.$this->formatNumber($rr5,3,'');
+ echo '<br />RR6 = '.$this->formatNumber($rr6,3,'');
+ echo '<br />';
+ echo '<br /><b>Contact rates:</b>';
+ echo '<br />CON1 = '.$this->formatNumber($con1,3,'');
+ echo '<br />CON2 = '.$this->formatNumber($con2,3,'');
+ echo '<br />CON3 = '.$this->formatNumber($con3,3,'');
+ echo '<br />';
+ echo '<br /><b>AAPOR paneli:</b>';
+ echo '<br />Profile rate: PROR = '.$this->formatNumber($pror,3,'');
+ echo '<br />Completion rate: COMR = '.$this->formatNumber($comr,3,'');
+ echo '<br />';
+ echo '<br /><b>Cumulative response rate:</b>';
+ echo '<br />CUMRR = '.$this->formatNumber($crr,3,'');*/
+
+ //echo '</div>';
+
+ echo '<div class="floatLeft" style="margin-left:50px">';
+ echo '<b>Statusi:</b>';
+ echo '<br/>';
+ $arrayStatusi = array('6'=>$s6,'6l'=>$s6l,'5'=>$s5,'5l'=>$s5l,'4'=>$s4,'3'=>$s3,'2'=>$s2,'1'=>$s1,'0'=>$s0);
+ foreach ($arrayStatusi as $status => $value) {
+ echo '<span class="dashboard_status_span">' . $lang['srv_userstatus_'.$status] . ' ('.$status.') :</span>' . $value
+ . '<br/>';
+ }
+ echo '<br /><br/>';
+
+ echo 'Povezave:<br/>';
+ // echo '<a href="http://www.aapor.org/For_Researchers/4683.htm" target="_blank">';
+ echo '<a href="https://www.esomar.org/knowledge-and-standards/research-resources/aapor-standard-definitions.php" target="_blank">';
+ echo 'Standard Definitions – Final Dispositions of Case Codes and Outcome Rates for Surveys (PDF)';
+ echo '</a>';
+ echo '</div>';
+ echo '<br class="clr"/>';
+ }
+
+ function calculateFullAapor(){
+ global $lang;
+
+ echo '<div class="floatLeft">';
+ echo '<h2>'.$lang['srv_lnk_AAPOR2'].'</h2>';
+ echo'
+ <form id="aaporForm">
+ <input type="hidden" name="anketa" value="'.$this->_surveyId.'" />
+ <table id="aapor_table">
+ <tbody>
+ <tr>
+ <td></td><td><label>'.$lang['srv_aapor_show_approximate'].'</label><input onchange="prikazi('.$this->_surveyId.')" id="prikazipriblizek" type="checkbox" name="prikaziPriblizek" /></td>
+ </tr>
+ <tr>
+ <td><span class="main_title_aapor">Returne questionaire (1.0)</span></td><td><input class="main_aapor main_title_aapor" type="text" name="rq" readonly/></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Complete (1.1)</span></td><td><input onchange="calculateReturne()" class="input_aapor category_span" type="text" name="complete" /></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Partial or break-off (1.2)</span></td><td><input onchange="calculateReturne()" class="input_aapor category_span" type="text" name="partial" /></td>
+ </tr>
+ <tr>
+ <td><span class="main_title_aapor">Eligible (2.0)</span></td><td><input class="main_aapor main_title_aapor" type="text" name="eligible" readonly/></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Refusal (2.11)</span></td><td><input class="read_aapor category_span" type="text" name="refusal" readonly/></td>
+ </tr>
+ <tr>
+ <td><span class="subcategory1_span">Explicit refusal (2.111)</span></td><td><input onchange="calculateRefusal()" class="input_aapor subcategory1_span" type="text" name="refusalEx" /></td>
+ </tr>
+ <tr>
+ <td><span class="subcategory1_span">Implicit refusal (2.112)</span></td><td><input class="read_aapor subcategory1_span" type="text" name="refusalIm" readonly/></td>
+ </tr>
+ <tr>
+ <td><span class="subcategory2_span">Logged on to survay, did not complete any items (2.1121)</span></td><td><input onchange="calculateRefusalIm()" class="input_aapor subcategory2_span" type="text" name="loggedNotComplete" /></td>
+ </tr>
+ <tr>
+ <td><span class="subcategory2_span">Read receipt confirmation, refusal (2.1122)</span></td><td><input onchange="calculateRefusalIm()" class="input_aapor subcategory2_span" type="text" name="readReceiptConfirmation" /></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Brak-off or partial with insufficient information (2.12)</span></td><td><input onchange="calculateEligible()" class="input_aapor category_span" type="text" name="breakOff" /></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Not-Contact (2.20)</span></td><td><input onchange="calculateEligible()" class="read_aapor category_span" type="text" name="nonContact" readonly/></td>
+ </tr>
+ <tr>
+ <td><span class="subcategory1_span">Respondenr was unavailable during field period (2.26)</span></td><td><input onchange="calculateNonContact()" class="input_aapor subcategory1_span" type="text" name="respondentUnavailable" /></td>
+ </tr>
+ <tr>
+ <td><span class="subcategory1_span">Completed questionnaire, but not retuned during field period (2.27)</span></td><td><input onchange="calculateNonContact()" class="input_aapor subcategory1_span" type="text" name="completedNotReturned" /></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Other (2.30)</span></td><td><input onchange="calculateEligible()" class="read_aapor category_span" type="text" name="otherEligible" readonly/></td>
+ </tr>
+ <tr>
+ <td><span class="subcategory1_span">Language barrier (2.33)</span></td><td><input onchange="calculateOtherEligible()" class="input_aapor subcategory1_span" type="text" name="languageBarrier" /></td>
+ </tr>
+ <tr>
+ <td><span class="main_title_aapor">Unknown eligible, "non-interview" (3.0)</span></td><td><input class="main_aapor main_title_aapor" type="text" name="unknownEligible" readonly/></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Nothing known about respondent or address (3.10)</span></td><td><input onchange="calculateUnknownEligibility()" class="read_aapor category_span" type="text" name="nothingKnown" readonly/></td>
+ </tr>
+ <tr>
+ <td><span class="subcategory1_span">No invitation sent (3.11)</span></td><td><input onchange="calculateNothingKnownRespondent()" class="input_aapor subcategory1_span" type="text" name="noInvitation" /></td>
+ </tr>
+ <tr>
+ <td><span class="subcategory1_span">Nothing ever returned (3.19)</span></td><td><input onchange="calculateNothingKnownRespondent()" class="input_aapor subcategory1_span" type="text" name="nothingReturned" /></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Invitation returned undelivered (3.30)</span></td><td><input onchange="calculateUnknownEligibility()" class="input_aapor category_span" type="text" name="invitationReturnedUndelivered" /></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Invitation returned with forwarding information (3.40)</span></td><td><input onchange="calculateUnknownEligibility()" class="input_aapor category_span" type="text" name="invitationReturnedForwarding" /></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Other (3.90)</span></td><td><input onchange="calculateUnknownEligibility()" class="read_aapor category_span" type="text" name="otherUnknownEligible" readonly/></td>
+ </tr>
+ <tr>
+ <td><span class="subcategory1_span">Returned from a unsampled email address (3.91)</span></td><td><input onchange="calculateOtherUnknownEligibility()" class="input_aapor subcategory1_span" type="text" name="returnedUnsampledEmail" /></td>
+ </tr>
+ <tr>
+ <td><span class="main_title_aapor">Not eligible, Returned (4.0)</span></td><td><input class="main_aapor main_title_aapor" type="text" name="notEligible" readonly/></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Selected Respondent Screende Out of Sample (4.10)</span></td><td><input onchange="calculateNotEligible()" class="input_aapor category_span" type="text" name="selectedRespondent" /></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Quota Filled (4.80)</span></td><td><input onchange="calculateNotEligible()" class="read_aapor category_span" type="text" name="quotaFilled" readonly/></td>
+ </tr>
+ <tr>
+ <td><span class="subcategory1_span">Duplicate Listing (4.81)</span></td><td><input onchange="calculateQuotaFilled()" class="input_aapor subcategory1_span" type="text" name="duplicateListing" /></td>
+ </tr>
+ <tr>
+ <td><span class="category_span">Other (4.90)</span></td><td><input onchange="calculateNotEligible()" class="input_aapor category_span" type="text" name="otherNotEligible" /></td>
+ </tr>
+ <tr id="totalSub">
+ <td class="totalSubTd">Skupna vsota:</td><td><span class="totalSubSpan"></span></td>
+ </tr>
+ <tr id="totalSub">
+ <td class="totalSubTd">'.$lang['srv_statistic_sum_all'].'</td><td><span class="totalSubDatabaseSpan"></span></td>
+ </tr>
+ <tr>
+ <td class="aaporSpace"></td>
+ </tr>
+ <tr>
+ <td><span class="main_title_aapor aapor_e">e <span style="font-size: 70%">['.$lang['srv_statistic_e_description'].']<span></span></td><td><input class="input_aapor" type="text" name="e" /></td>
+ </tr>
+ <tr>
+ <td colspan="2"><span class="floatLeft spaceRight aaporButton"><div class="buttonwrapper"><a class="ovalbutton ovalbutton_orange btn_savesettings" href="#" onclick="getCallculationAapor('.$this->_surveyId.')"><span>'.$lang['srv_aapor_calculation'].'</span></a></div></span></td>
+ </tr>
+ </tbody>
+ </table>
+ </form>
+ ';
+ echo '</div>';
+ echo '<div class="floatLeft show_calculation">';
+ echo '<h2>'.$lang['srv_aapor_show_calculation'].'</h2>';
+ echo '<table>
+ <tbody>
+ <tr>
+ <td>RR1:</td><td><span id="rr1"></span></td>
+ </tr>
+ <tr>
+ <td>RR2:</td><td><span id="rr2"></span></td>
+ </tr>
+ <tr>
+ <td>RR3:</td><td><span id="rr3"></span></td>
+ </tr>
+ <tr>
+ <td>RR4:</td><td><span id="rr4"></span></td>
+ </tr>
+ <tr>
+ <td>RR5:</td><td><span id="rr5"></span></td>
+ </tr>
+ <tr>
+ <td>RR6:</td><td><span id="rr6"></span></td>
+ </tr>
+ </tbody>
+ </table>';
+ echo '</div>';;
+ }
+ function calculationForFullAapor(){
+ $data = array();
+ $rr1 = 0;
+ $rr2 = 0;
+ $rr3 = 0;
+ $rr4 = 0;
+ $rr5 = 0;
+ $rr6 = 0;
+
+ $refusal = $_POST['refusal'];
+ $refusal = $refusal=='' || !is_numeric($refusal) ? 0:$refusal;
+
+ $breakOff = $_POST['breakOff'];
+ $breakOff = $breakOff=='' || !is_numeric($breakOff) ? 0:$breakOff;
+
+ $invitationReturnedUndelivered = $_POST['invitationReturnedUndelivered'];
+ $invitationReturnedUndelivered = $invitationReturnedUndelivered=='' || !is_numeric($invitationReturnedUndelivered) ? 0:$invitationReturnedUndelivered;
+
+ $invitationReturnedForwarding = $_POST['invitationReturnedForwarding'];
+ $invitationReturnedForwarding = $invitationReturnedForwarding=='' || !is_numeric($invitationReturnedForwarding) ? 0:$invitationReturnedForwarding;
+
+ $otherUnknownEligible = $_POST['otherUnknownEligible'];
+ $otherUnknownEligible = $otherUnknownEligible=='' || !is_numeric($otherUnknownEligible) ? 0:$otherUnknownEligible;
+
+ $i = $_POST['complete'];
+ $i = $i=='' || !is_numeric($i) ? 0:$i;
+
+ $p = $_POST['partial'];
+ $p = $p=='' || !is_numeric($p) ? 0:$p;
+
+ $r = $refusal+$breakOff;
+
+ $nc = $_POST['nonContact'];
+ $nc = $nc=='' || !is_numeric($nc) ? 0:$nc;
+
+ $o = $_POST['otherEligible'];
+ $o = $o == '' || !is_numeric($o) ? 0:$o;
+
+ $uh = $_POST['nothingKnown'];
+ $uh = $uh=='' || !is_numeric($uh) ? 0:$uh;
+
+ $uo = $invitationReturnedUndelivered + $invitationReturnedForwarding + $otherUnknownEligible;
+
+ $e = $_POST['e'];
+ $e = $e=='' || !is_numeric($e) ? 100:$e;
+ if($e > 100 || $e<0){
+ $e = 100;
+ }
+ $e = $e/100;
+ //error_log("E je ".$e);
+ $sub1 = $i+$p+$r+$nc+$o+$uh+$uo;
+ $sub2 = $i+$p+$r+$nc+$o+$e*($uh+$uo);
+ $sub3 = $i+$p+$r+$nc+$o;
+
+ //error_log($refusal." - ".$breakOff." - ".$invitationReturnedUndelivered." - ".$invitationReturnedForwarding." - ".$otherUnknownEligible." - ".$i."- ".$p." - ".$r." - ".$nc." - ".$o." - ".$uh." - ".$uo." - ".$e);
+
+ if($sub1 > 0){
+ $rr1 = $i/($sub1);
+ $rr2 = ($i+$p)/($sub1);
+ }
+ if($sub2 > 0){
+ $rr3 = $i/($sub2);
+ $rr4 = ($i+$p)/($sub2);
+ }
+ if($sub3 > 0){
+ $rr5 = $i/($sub3);
+ $rr6 = ($i+$p)/($sub3);
+ }
+
+ $data['rr1'] = $this->formatNumber($rr1,3,'');
+ $data['rr2'] = $this->formatNumber($rr2,3,'');
+ $data['rr3'] = $this->formatNumber($rr3,3,'');
+ $data['rr4'] = $this->formatNumber($rr4,3,'');
+ $data['rr5'] = $this->formatNumber($rr5,3,'');
+ $data['rr6'] = $this->formatNumber($rr6,3,'');
+
+ echo json_encode($data);
+ }
+
+ function izracunajPodatke($id){
+ /*$sur = new SurveyUsableResp($id, $generateDatafile=false);
+
+ if($sur->hasDataFile())
+ $this->usability = $sur->calculateData(); // Dobimo array z usability podatki*/
+ $qry_string = "SELECT id, language, last_status, lurker, inv_res_id, referer FROM srv_user WHERE ank_id = '".$id."' AND preview = '0' AND deleted='0'";
+ $qry = sisplet_query($qry_string);
+
+ if (mysqli_num_rows($qry) > 0) {
+ $user_id_to_check_link = array(); # id-ji uporabnikov pri katerih imamo direkten klik. naknadno ugotavljamo ali je slučajno e-mail vabilo
+ while ($row = mysqli_fetch_assoc($qry)) {
+ if ((int)$row['testdata'] > 0) {
+ $this->testDataCount++;
+ }
+ // dodamo statuse
+ if (in_array($row['last_status'], $this->appropriateStatus))
+ {
+ # če ni lurker je ok
+ if ($row['lurker'] == 0)
+ {
+ $this->userByStatus['valid'][$row['last_status']] += 1;
+ $this->cntUserByStatus['valid'] += 1;
+ }
+ else
+ {
+ # če je lurker ga dodamo k neveljavnim
+ $this->userByStatus['nonvalid'][$row['last_status'].'l'] += 1;
+ $this->cntUserByStatus['nonvalid'] += 1;
+ }
+ }
+ # neveljavne enote
+ else if (in_array($row['last_status'], $this->unAppropriateStatus))
+ {
+ $this->userByStatus['nonvalid'][$row['last_status']] += 1;
+ $this->cntUserByStatus['nonvalid'] += 1;
+ }
+ # emaili
+ else if (in_array($row['last_status'], $this->invitationStatus))
+ {
+ $this->userByStatus['invitation'][$row['last_status']] += 1;
+ $this->cntUserByStatus['invitation'] += 1;
+ }
+
+ #polovimo redirekte
+ if (in_array((int)$row['last_status'], $this->invitationStatus))
+ {
+ # email vabila ... ne lovimo redirektov
+ # podatek o referalu je prazen lahko da email ni bil poslan, ali pa gre za direkten link
+ #$this->cntNonValidRedirections += 1;
+ #$this->userRedirections[(int)$row['last_status']] += 1;
+ }
+ else {
+ # če so vabila
+ if ($row['inv_res_id'] != null )
+ {
+ $this->cntValidRedirections += 1;
+ $this->userRedirections["valid"]['email'] += 1;
+ $this->maxRedirection = max($this->maxRedirection , $this->userRedirections["valid"]['email']);
+ }
+ # če imamo referal
+ else if ($row['referer'] != "")
+ {
+ $parsed = parse_url($row['referer']);
+ $this->cntValidRedirections += 1;
+ $this->userRedirections["valid"][$parsed['host']] += 1;
+ $this->maxCharRedirection = max($this->maxCharRedirection , strlen ($parsed['host']) );
+ $this->maxRedirection = max($this->maxRedirection , $this->userRedirections["valid"][$parsed['host']] );
+ }
+ # če ne je najbrž direkten link
+ else
+ {
+ # shranimo id_userjev za katere nato ugotavljamo ali je link res direkten ali obstaja kaksen zapis da je slo preko e-maila
+ $user_id_to_check_link[] = $row['id'];
+ $this->tmp_direct +=1;
+ }
+ }
+ #polovimo jezike
+ if (isset($respondentLangArray[$row['language']]))
+ {
+ $respondentLangArray[$row['language']] ++;
+ }
+ else
+ {
+ $respondentLangArray[$row['language']] = 1;
+ }
+ }
+ }
+
+ # od direktnega klika odštejemo e-mail vabila
+ if (count($user_id_to_check_link)> 0) {
+ $qry_stringEmail = "SELECT COUNT(*) as cnt FROM srv_userstatus WHERE usr_id IN (".implode(',', $user_id_to_check_link).") AND status IN (".implode(',', $this->emailStatus).")";
+ $qryEmail = sisplet_query($qry_stringEmail);
+ $rwsEmail = mysqli_fetch_assoc($qryEmail);
+ $this->userRedirections["email"] = (int)$rwsEmail['cnt'];
+ $this->userRedirections["direct"] = (int)$this->tmp_direct - (int)$rwsEmail['cnt'];
+ }
+ // prestejemo max stevilo klikov za lepsi izris tabele
+ $this->maxRedirection = max($this->maxRedirection , $this->userRedirections["2"], $this->userRedirections["1"], $this->userRedirections["0"],$this->userRedirections["direct"], $this->userRedirections['email']);
+
+ # izracunamo realne frekvence po statusih
+ # Klik na anketo - vsak ki je končal anketo (itd...) je "najbrž" tudi kliknil na anketo..
+ $this->realUsersByStatus_all = $this->userByStatus['valid'][6]
+ + $this->userByStatus['valid'][5]
+ + $this->userByStatus['nonvalid']['5l']
+ + $this->userByStatus['nonvalid']['6l']
+ + $this->userByStatus['nonvalid'][4]
+ + $this->userByStatus['nonvalid'][3]
+ + $this->userByStatus['nonvalid'][-1];
+ // Klik na prvo stran - vsak ki je končal anketo (itd...) je "najbrž" tudi kliknil na anketo..
+ # končal anketo => 6
+ $this->realUsersByStatus[6] = array('cnt'=>$this->userByStatus['valid'][6], 'percent'=>0);
+ # začel izpolnjevat => 5 = 6 + 5
+ $this->realUsersByStatus[5] = array('cnt'=>$this->userByStatus['valid'][5]+$this->realUsersByStatus[6]['cnt'], 'percent'=>0);
+ # Koliko ljudi je dejansko končalo anketo ne glede na to ali so lurkerji 6 + 6l
+ $this->realUsersByStatus['6ll'] = array('cnt'=>$this->userByStatus['nonvalid']['6l']+$this->realUsersByStatus[6]['cnt'], 'percent'=>0);
+ # delno izpolnjena 4ll => 6 + 5 + 6l + 5l
+ $this->realUsersByStatus['5ll'] = array('cnt'=>$this->userByStatus['nonvalid']['6l']+$this->userByStatus['nonvalid']['5l']+$this->realUsersByStatus[5]['cnt'], 'percent'=>0);
+ # klik na prvo stran => 4 = 6 + 6l + 5l + 5 + 4
+ $this->realUsersByStatus['4ll'] = array('cnt'=>$this->userByStatus['nonvalid'][4]+$this->realUsersByStatus['5ll']['cnt'], 'percent'=>0);
+ # klik na anketo => 3 = 6 + 6l + 5l + 5 + 4 + 3
+ $this->realUsersByStatus['3ll'] = array('cnt'=>$this->userByStatus['nonvalid'][3]+$this->userByStatus['nonvalid'][-1]+$this->realUsersByStatus['4ll']['cnt'], 'percent'=>0);
+ //if ($this->emailInvitation == 1)
+ {
+ $this->realUsersByStatus['email']
+ = array('cnt'=>(isset($this->userByStatus['valid']['email'])?$this->userByStatus['valid']['email']:0), 'percent'=>0);
+ }
+
+ $qry_string = "SELECT * FROM srv_invitations_recipients WHERE ank_id='".$id."' AND deleted='0'";
+ $qry = sisplet_query($qry_string);
+ $this->userByStatus['invitation'][0]=0;
+ $this->userByStatus['invitation'][1]=0;
+ $this->userByStatus['invitation'][2]=0;
+ while ($row = mysqli_fetch_assoc($qry)) {
+ if(in_array($row['last_status'], $this->invitationStatus)){
+ $this->userByStatus['invitation'][$row['last_status']] += 1;
+ }
+ }
+ }
+ function prikaziPriblizek(){
+ $data = array();
+ error_log("Id v metodi priblizek: ".$this->_surveyId);
+
+ /*$ss = new SurveyStatistic();
+ $ss->Init($this->_surveyId);
+ $ss->PrepareDateView();
+ $this->userByStatus = $ss->getUserByStatus();*/
+ //$this->izracunajPodatke($id);
+ //var_dump($this->cntUserByStatus);
+
+ $usable = $this->usability['usable'];
+ $partusable = $this->usability['partusable'];
+ $unusable = $this->usability['unusable'];
+ $status3 = $this->userByStatus['nonvalid'][3];
+ $status4 = $this->userByStatus['nonvalid'][4];
+ $status34 = 0;
+ $status0 = $this->userByStatus['invitation'][0];
+ $status2 = $this->userByStatus['invitation'][2];
+ $status02 = 0;
+ $status1 = $this->userByStatus['invitation'][1];
+ //if(!is_null($status3) && !is_null($status4) && is_int($status3) && is_int($status4)){
+ $status34 = $status3+$status4;
+ //}
+ //if(!is_null($status0) && !is_null($status2) && is_int($status0) && is_int($status2)){
+ $status02 = $status0+$status2;
+ //}
+
+ $skupaj = $this->cntUserByStatus['valid']+$this->cntUserByStatus['nonvalid']+$this->cntUserByStatus['invitation'];
+
+ $data['usable'] = is_null($usable) || !is_int($usable) ? 0 : $usable;
+ $data['partusable'] = is_null($partusable) || !is_int($partusable) ? 0 : $partusable;
+ $data['unusable'] = is_null($unusable) || !is_int($unusable) ? 0 : $unusable;
+ $data['status1'] = is_null($status1) || !is_int($status1) ? 0 : $status1;
+ $data['status34'] = $status34;
+ $data['status02'] = $status02;
+ $data['skupaj'] = $skupaj;
+
+ echo json_encode($data);
+ }
+
+ /** Lepo oblikuje number string
+ *
+ * @param float $value
+ * @param int $digit
+ * @param string $sufix
+ * @return string
+ */
+ function formatNumber ($value, $digit = 0, $sufix = "") {
+ if ($value <> 0 && $value != null)
+ $result = round($value, $digit);
+ else
+ $result = "0";
+ $result = number_format($result, $digit, '.', ',') . $sufix;
+
+ return $result;
+ }
+
+}
|