-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy path__mocks_8timesort_8php_source.html
91 lines (89 loc) · 12.5 KB
/
__mocks_8timesort_8php_source.html
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
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.13"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<title>GravityView: _mocks.timesort.php Source File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/searchdata.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="custom-doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr style="height: 56px;">
<td id="projectlogo"><img alt="Logo" src="logo.png"/></td>
<td id="projectalign" style="padding-left: 0.5em;">
<div id="projectname">GravityView
 <span id="projectnumber">2.17</span>
</div>
<div id="projectbrief">The best, easiest way to display Gravity Forms entries on your website.</div>
</td>
</tr>
</tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.13 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
<script type="text/javascript" src="menudata.js"></script>
<script type="text/javascript" src="menu.js"></script>
<script type="text/javascript">
$(function() {
initMenu('',true,false,'search.php','Search');
$(document).ready(function() { init_search(); });
});
</script>
<div id="main-nav"></div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
onkeydown="return searchBox.OnSearchSelectKey(event)">
</div>
<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0"
name="MSearchResults" id="MSearchResults">
</iframe>
</div>
<div id="nav-path" class="navpath">
<ul>
<li class="navelem"><a class="el" href="dir_b991dd203557c1647cca2d1663310531.html">future</a></li> </ul>
</div>
</div><!-- top -->
<div class="header">
<div class="headertitle">
<div class="title">_mocks.timesort.php</div> </div>
</div><!--header-->
<div class="contents">
<a href="__mocks_8timesort_8php.html">Go to the documentation of this file.</a><div class="fragment"><div class="line"><a name="l00001"></a><span class="lineno"> 1</span> <?php</div><div class="line"><a name="l00002"></a><span class="lineno"> 2</span> <span class="keyword">namespace </span><a class="code" href="namespace_g_v_1_1_mocks.html">GV\Mocks</a>;</div><div class="line"><a name="l00003"></a><span class="lineno"> 3</span> <span class="comment"></span></div><div class="line"><a name="l00004"></a><span class="lineno"> 4</span> <span class="comment">/**</span></div><div class="line"><a name="l00005"></a><span class="lineno"> 5</span> <span class="comment"> * Time merge calls.</span></div><div class="line"><a name="l00006"></a><span class="lineno"> 6</span> <span class="comment"> *</span></div><div class="line"><a name="l00007"></a><span class="lineno"> 7</span> <span class="comment"> * Might be in GF_Query soon.</span></div><div class="line"><a name="l00008"></a><span class="lineno"> 8</span> <span class="comment"> */</span></div><div class="line"><a name="l00009"></a><span class="lineno"><a class="line" href="class_g_v_1_1_mocks_1_1_g_f___query___call___t_i_m_e_s_o_r_t.html"> 9</a></span> <span class="keyword">class </span><a class="code" href="class_g_v_1_1_mocks_1_1_g_f___query___call___t_i_m_e_s_o_r_t.html">GF_Query_Call_TIMESORT</a> <span class="keyword">extends</span> \GF_Query_Call {</div><div class="line"><a name="l00010"></a><span class="lineno"><a class="line" href="class_g_v_1_1_mocks_1_1_g_f___query___call___t_i_m_e_s_o_r_t.html#ad7643a466f4038ebabe49ab902120ea7"> 10</a></span>  <span class="keyword">public</span> <span class="keyword">function</span> <a class="code" href="class_g_v_1_1_mocks_1_1_g_f___query___call___t_i_m_e_s_o_r_t.html#ad7643a466f4038ebabe49ab902120ea7">timesort_sql</a>( $query ) {</div><div class="line"><a name="l00011"></a><span class="lineno"> 11</span>  global $wpdb;</div><div class="line"><a name="l00012"></a><span class="lineno"> 12</span> </div><div class="line"><a name="l00013"></a><span class="lineno"> 13</span>  list( $column, $sql ) = $this->parameters;</div><div class="line"><a name="l00014"></a><span class="lineno"> 14</span>  $meta_table = \GFFormsModel::get_entry_meta_table_name();</div><div class="line"><a name="l00015"></a><span class="lineno"> 15</span> </div><div class="line"><a name="l00016"></a><span class="lineno"> 16</span>  $alias = $query->_alias( $column->field_id, $column->source, <span class="charliteral">'m'</span> );</div><div class="line"><a name="l00017"></a><span class="lineno"> 17</span> </div><div class="line"><a name="l00018"></a><span class="lineno"> 18</span> <span class="comment">/*</span></div><div class="line"><a name="l00019"></a><span class="lineno"> 19</span> <span class="comment">SELECT v,</span></div><div class="line"><a name="l00020"></a><span class="lineno"> 20</span> <span class="comment">IF(</span></div><div class="line"><a name="l00021"></a><span class="lineno"> 21</span> <span class="comment">POSITION('pm' IN v) > 0,</span></div><div class="line"><a name="l00022"></a><span class="lineno"> 22</span> <span class="comment"></span></div><div class="line"><a name="l00023"></a><span class="lineno"> 23</span> <span class="comment">(</span></div><div class="line"><a name="l00024"></a><span class="lineno"> 24</span> <span class="comment">SUBSTRING_INDEX(v, ':', 1)</span></div><div class="line"><a name="l00025"></a><span class="lineno"> 25</span> <span class="comment">+ IF(SUBSTRING_INDEX(v, ':', 1) < 12, 12, 0)</span></div><div class="line"><a name="l00026"></a><span class="lineno"> 26</span> <span class="comment">) * 60,</span></div><div class="line"><a name="l00027"></a><span class="lineno"> 27</span> <span class="comment"></span></div><div class="line"><a name="l00028"></a><span class="lineno"> 28</span> <span class="comment">SUBSTRING_INDEX(v, ':', 1) * 60</span></div><div class="line"><a name="l00029"></a><span class="lineno"> 29</span> <span class="comment">) +</span></div><div class="line"><a name="l00030"></a><span class="lineno"> 30</span> <span class="comment">RIGHT(IF(</span></div><div class="line"><a name="l00031"></a><span class="lineno"> 31</span> <span class="comment">POSITION('m' IN v) > 0,</span></div><div class="line"><a name="l00032"></a><span class="lineno"> 32</span> <span class="comment">SUBSTRING_INDEX(v, ' ', 1),</span></div><div class="line"><a name="l00033"></a><span class="lineno"> 33</span> <span class="comment">v</span></div><div class="line"><a name="l00034"></a><span class="lineno"> 34</span> <span class="comment">),2) t1</span></div><div class="line"><a name="l00035"></a><span class="lineno"> 35</span> <span class="comment"></span></div><div class="line"><a name="l00036"></a><span class="lineno"> 36</span> <span class="comment">FROM meta;</span></div><div class="line"><a name="l00037"></a><span class="lineno"> 37</span> <span class="comment">*/</span></div><div class="line"><a name="l00038"></a><span class="lineno"> 38</span> </div><div class="line"><a name="l00039"></a><span class="lineno"> 39</span>  <span class="comment">// Detect if 'pm' is in the time field</span></div><div class="line"><a name="l00040"></a><span class="lineno"> 40</span>  $pm_exists = <span class="stringliteral">"POSITION('pm' IN $alias.`meta_value`)"</span>;</div><div class="line"><a name="l00041"></a><span class="lineno"> 41</span>  </div><div class="line"><a name="l00042"></a><span class="lineno"> 42</span>  <span class="comment">// Transform a pm time into minutes ((hour + (12 if hour > 12 else 0)) * 60)</span></div><div class="line"><a name="l00043"></a><span class="lineno"> 43</span>  $minutes_12 = <span class="stringliteral">"(SUBSTRING_INDEX($alias.`meta_value`, ':', 1) + IF(SUBSTRING_INDEX($alias.`meta_value`, ':', 1) < 12, 12, 0)) * 60"</span>;</div><div class="line"><a name="l00044"></a><span class="lineno"> 44</span> </div><div class="line"><a name="l00045"></a><span class="lineno"> 45</span>  <span class="comment">// Transform a 24-hour time into minutes (hour * 60), maybe compensate 12 am = 0</span></div><div class="line"><a name="l00046"></a><span class="lineno"> 46</span>  $minutes_24 = <span class="stringliteral">"(SUBSTRING_INDEX($alias.`meta_value`, ':', 1) - IF(POSITION('am' IN $alias.`meta_value`) AND SUBSTRING_INDEX($alias.`meta_value`, ':', 1) = '12', 12, 0)) * 60"</span>;</div><div class="line"><a name="l00047"></a><span class="lineno"> 47</span> </div><div class="line"><a name="l00048"></a><span class="lineno"> 48</span>  <span class="comment">// Minutes</span></div><div class="line"><a name="l00049"></a><span class="lineno"> 49</span>  $minutes = <span class="stringliteral">"RIGHT(IF(POSITION('m' IN $alias.`meta_value`), SUBSTRING_INDEX($alias.`meta_value`, ' ', 1), $alias.`meta_value`), 2)"</span>;</div><div class="line"><a name="l00050"></a><span class="lineno"> 50</span> </div><div class="line"><a name="l00051"></a><span class="lineno"> 51</span>  <span class="comment">// Combine the insanity :)</span></div><div class="line"><a name="l00052"></a><span class="lineno"> 52</span>  $condition = <span class="stringliteral">"IF($pm_exists, $minutes_12, $minutes_24) + $minutes"</span>;</div><div class="line"><a name="l00053"></a><span class="lineno"> 53</span> </div><div class="line"><a name="l00054"></a><span class="lineno"> 54</span>  <span class="keywordflow">return</span> <span class="stringliteral">"(SELECT $condition)"</span>;</div><div class="line"><a name="l00055"></a><span class="lineno"> 55</span>  }</div><div class="line"><a name="l00056"></a><span class="lineno"> 56</span> }</div><div class="ttc" id="namespace_g_v_1_1_mocks_html"><div class="ttname"><a href="namespace_g_v_1_1_mocks.html">GV\Mocks</a></div><div class="ttdef"><b>Definition:</b> <a href="__mocks_8isnull_8php_source.html#l00002">_mocks.isnull.php:2</a></div></div>
<div class="ttc" id="class_g_v_1_1_mocks_1_1_g_f___query___call___t_i_m_e_s_o_r_t_html_ad7643a466f4038ebabe49ab902120ea7"><div class="ttname"><a href="class_g_v_1_1_mocks_1_1_g_f___query___call___t_i_m_e_s_o_r_t.html#ad7643a466f4038ebabe49ab902120ea7">GV\Mocks\GF_Query_Call_TIMESORT\timesort_sql</a></div><div class="ttdeci">timesort_sql( $query)</div><div class="ttdef"><b>Definition:</b> <a href="__mocks_8timesort_8php_source.html#l00010">_mocks.timesort.php:10</a></div></div>
<div class="ttc" id="class_g_v_1_1_mocks_1_1_g_f___query___call___t_i_m_e_s_o_r_t_html"><div class="ttname"><a href="class_g_v_1_1_mocks_1_1_g_f___query___call___t_i_m_e_s_o_r_t.html">GV\Mocks\GF_Query_Call_TIMESORT</a></div><div class="ttdoc">Time merge calls. </div><div class="ttdef"><b>Definition:</b> <a href="__mocks_8timesort_8php_source.html#l00009">_mocks.timesort.php:9</a></div></div>
</div><!-- fragment --></div><!-- contents -->
<!-- start footer part -->
<hr class="footer"/>
<script type="text/javascript">
jQuery( document ).ready( function( $ ) {
$( 'a.anchor[id^=_filters],a.anchor[id^=_actions]' ).each( function() {
$( this )
.text('#')
.attr( 'href', function() {
return '#' + $( this ).attr( 'id' );
}).prependTo( $( this ).parent('dt' ).next('dd') );
});
});
</script>
</body>
</html>