blob: 5da44038df62aa2d16626bdfcc050416ffe73e3c (
plain)
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
|
<?php
use app\models\market\Market_repository as Market;
// reply_json([
// 'pool' => Market::echo(True)
// ]); die();
$shorts = Market::echo(True);
?><!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.6.0/styles/default.min.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.6.0/highlight.min.js"></script>
<!-- and it's easy to individually load additional languages -->
<!--
<script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.6.0/languages/go.min.js"></script>
-->
<script src="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.6.0/languages/sql.min.js" integrity="sha512-efGcw9G3wD5/VEKACpydwQLvsYs8/QEWGLqnrMp+cEF5jFVdJmbmf3+D+y1LmoQR1IbtzO9XUCTeZhJ1riqX1A==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.6.0/styles/atom-one-light.min.css" integrity="sha512-o5v54Kh5PH0dgnf9ei0L+vMRsbm5fvIvnR/XkrZZjN4mqdaeH7PW66tumBoQVIaKNVrLCZiBEfHzRY4JJSMK/Q==" crossorigin="anonymous" referrerpolicy="no-referrer" />
<!--
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/highlight.js/11.6.0/styles/atom-one-dark.min.css" integrity="sha512-Jk4AqjWsdSzSWCSuQTfYRIF84Rq/eV0G2+tu07byYwHcbTGfdmLrHjUSwvzp5HvbiqK4ibmNwdcG49Y5RGYPTg==" crossorigin="anonymous" referrerpolicy="no-referrer" />
-->
<style>
body { font-size: .92em; }
h3, h4, pre, code { font-family: 'JetBrains Mono NL', 'Consolas','Monaco', 'monospace', monospace; }
h3 { padding: 2em 1.5em .5em; }
h4 { padding: .5em 2em; }
</style>
</head>
<body>
<?php foreach($shorts as $label => $sql) : ?>
<?php
$args = explode('_by:', $label)[1];
$argsArray = explode('_', $args);
?>
<h3><?=$label?></h3>
<pre><code class="language-sql">
<?=$sql?></code></pre>
<h4>apply:</h4>
<pre><code class="language-php">
use Registrty;
use app\models\market\Market_repository as Market;
// ...
Registry::use('database')->runQuery(
Market::pull('<?=$label?>'),
[
<?php foreach($argsArray as $holder) : ?>
'<?=$holder?>' => ...,
<?php endforeach; ?>
]
);
</code></pre>
<?php endforeach; ?>
<script>hljs.highlightAll();</script>
</body>
</html>
|