Révision e45ece5c
| b/doc/conf.py | ||
|---|---|---|
| 50 | 50 |
# built documents. |
| 51 | 51 |
# |
| 52 | 52 |
# The short X.Y version. |
| 53 |
version = '0.1.24'
|
|
| 53 |
version = '0.1.25'
|
|
| 54 | 54 |
# The full version, including alpha/beta/rc tags. |
| 55 |
release = '0.1.24'
|
|
| 55 |
release = '0.1.25'
|
|
| 56 | 56 |
|
| 57 | 57 |
# The language for content autogenerated by Sphinx. Refer to documentation |
| 58 | 58 |
# for a list of supported languages. |
| b/src/cl_name.MVC.php | ||
|---|---|---|
| 1 |
<?php |
|
| 2 |
function pre_print_r($obj) {
|
|
| 3 |
echo "<PRE>"; |
|
| 4 |
print_r($obj); |
|
| 5 |
echo "</PRE>"; |
|
| 6 |
} |
|
| 7 |
|
|
| 8 |
$results = $this->myQuery("SELECT cl_passages.ID, cl_storage.ID, cl_passages.passage, cl_passages.date_of_freezing, cl_passages.Author, cl_storage.container, cl_storage.rack, cl_storage.box, cl_storage.field_y, cl_storage.field_x FROM `cl_passages`, `cl_storage` WHERE cl_passages.name='" . $this->rec . "' AND cl_storage.cl_passages=cl_passages.ID");
|
|
| 9 |
|
|
| 10 |
$cl_passages_ids = array(); |
|
| 11 |
$cl_storage_ids = array(); |
|
| 12 |
|
|
| 13 |
$table_of_passages = "<table class=\"pme-main\"><tr class=\"pme-navigation\"> |
|
| 14 |
<th class=\"pme-header\">Passage</th> |
|
| 15 |
<th class=\"pme-header\">Date of freezing</th> |
|
| 16 |
<th class=\"pme-header\">Author</th> |
|
| 17 |
<th class=\"pme-header\">Storage</th> |
|
| 18 |
</tr>"; |
|
| 19 |
|
|
| 20 |
while ($row = mysql_fetch_array($results)) {
|
|
| 21 |
// pre_print_r($row); |
|
| 22 |
$cl_passages_ids[] = $row[0]; |
|
| 23 |
$cl_storage_ids[] = $row[1]; |
|
| 24 |
$table_of_passages .= "<tr class=\"pme-row-0\"> |
|
| 25 |
<td class=\"pme-cell-0\">" . $row["passage"] . "</td> |
|
| 26 |
<td class=\"pme-cell-0\">" . $row["date_of_freezing"] . "</td> |
|
| 27 |
<td class=\"pme-cell-0\">" . $row["Author"] . "</td> |
|
| 28 |
<td class=\"pme-cell-0\">c" . $row["container"] . " r" . $row["rack"] . " b" . $row["box"] . " " . $row["field_y"] . "" . $row["field_x"] . "</td> |
|
| 29 |
</tr>"; |
|
| 30 |
|
|
| 31 |
} |
|
| 32 |
|
|
| 33 |
$table_of_passages .= "</table>"; |
|
| 34 |
|
|
| 35 |
// pre_print_r($ids); |
|
| 36 |
|
|
| 37 |
|
|
| 38 |
$link_to_paasages = "<a href=\"http://minideb/labstocks/cl_passages.php?action=ADV_SEARCH&col_0=name&cond_0=%3D&input_0=$this->rec\">all passages (" . count(array_unique($cl_passages_ids)) . ")</a>";
|
|
| 39 |
|
|
| 40 |
|
|
| 41 |
|
|
| 42 |
$to_be_post_list_content .= <<<EOD |
|
| 43 |
<div class="sheet"> |
|
| 44 |
$link_to_paasages |
|
| 45 |
$table_of_passages |
|
| 46 |
</div> |
|
| 47 |
EOD; |
|
| 48 |
|
|
| 49 |
?> |
|
| b/src/cl_name.php | ||
|---|---|---|
| 166 | 166 |
'column' => 'id') |
| 167 | 167 |
); |
| 168 | 168 |
|
| 169 |
// TRIGGER |
|
| 170 |
$opts['triggers']['select']['pre'][] = 'cl_name.MVC.php'; |
|
| 171 |
$opts['triggers']['update']['pre'][] = 'cl_name.MVC.php'; |
|
| 172 |
|
|
| 169 | 173 |
require("footers.php");
|
| 170 | 174 |
?> |
| b/src/cl_passages.MVC.php | ||
|---|---|---|
| 1 |
<?php |
|
| 2 |
function pre_print_r($obj) {
|
|
| 3 |
echo "<PRE>"; |
|
| 4 |
print_r($obj); |
|
| 5 |
echo "</PRE>"; |
|
| 6 |
} |
|
| 7 |
|
|
| 8 |
$results = $this->myQuery("SELECT cl_storage.ID, cl_storage.container, cl_storage.rack, cl_storage.box, cl_storage.field_y, cl_storage.field_x FROM `cl_storage` WHERE cl_storage.cl_passages='" . $this->rec . "'");
|
|
| 9 |
|
|
| 10 |
|
|
| 11 |
$table_of_passages = "<table class=\"pme-main\"><tr class=\"pme-navigation\"> |
|
| 12 |
<th class=\"pme-header\">Storage</th> |
|
| 13 |
</tr>"; |
|
| 14 |
|
|
| 15 |
while ($row = mysql_fetch_array($results)) {
|
|
| 16 |
// pre_print_r($row); |
|
| 17 |
$cl_passages_ids[] = $row[0]; |
|
| 18 |
$cl_storage_ids[] = $row[1]; |
|
| 19 |
$table_of_passages .= "<tr class=\"pme-row-0\"> |
|
| 20 |
<td class=\"pme-cell-0\">c" . $row["container"] . " r" . $row["rack"] . " b" . $row["box"] . " " . $row["field_y"] . "" . $row["field_x"] . "</td> |
|
| 21 |
</tr>"; |
|
| 22 |
|
|
| 23 |
} |
|
| 24 |
|
|
| 25 |
$table_of_passages .= "</table>"; |
|
| 26 |
|
|
| 27 |
// pre_print_r($ids); |
|
| 28 |
|
|
| 29 |
|
|
| 30 |
|
|
| 31 |
|
|
| 32 |
$to_be_post_list_content .= <<<EOD |
|
| 33 |
<div class="sheet"> |
|
| 34 |
$table_of_passages |
|
| 35 |
</div> |
|
| 36 |
EOD; |
|
| 37 |
|
|
| 38 |
?> |
|
| b/src/cl_passages.php | ||
|---|---|---|
| 188 | 188 |
'column' => 'id') |
| 189 | 189 |
); |
| 190 | 190 |
|
| 191 |
// TRIGGER |
|
| 192 |
$opts['triggers']['select']['pre'][] = 'cl_passages.MVC.php'; |
|
| 193 |
$opts['triggers']['update']['pre'][] = 'cl_passages.MVC.php'; |
|
| 194 |
|
|
| 191 | 195 |
|
| 192 | 196 |
require("footers.php");
|
| 193 | 197 |
?> |
Formats disponibles : Unified diff