- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 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
<?php
$c = array();
$addQ = '';
$check = 1;
$q = 'SELECT in_hold.condition_id FROM in_hold WHERE in_hold.condition_id = 3';
$res = mysqli_query($db,$q);
while($row = mysqli_fetch_array($res))
array_push($c, $row['condition_id']);
$c = array_unique($c);
switch(count($c)) {
case 0:$check = 0;
break;
default:$check=3;
}
if(!$check)
echo 'Нет данных';
else
{
$iter = 3;
$query = "SELECT
*
FROM in_hold
LEFT JOIN cpa_types ON in_hold.spa_id = cpa_types.id
LEFT JOIN accounts_cpa ON in_hold.acc_id = accounts_cpa.id
LEFT JOIN currency ON in_hold.cur_id = currency.id
LEFT JOIN in_hold_condition ON in_hold.condition_id = in_hold_condition.id
WHERE in_hold.condition_id = '$iter' AND MONTH(final_date) = MONTH(NOW()) AND YEAR(final_date) = YEAR(NOW()) ORDER BY in_hold.final_date";
printf( '<div class="nopad3">');
echo '<table class= "table mytbl table-striped table-bordered boo-table table-condensed" cellspacing="0" cellpadding="1" >';
echo '<thead><tr><th>CPA</th><th>Аккаунт</th><th>Сумма</th><th>Дата Готовности</th><th>Дата Вывода</th></tr></thead>';
$result = mysqli_query($db,$query);
while($row = mysqli_fetch_array($result))
{
echo '<tr>';
echo '<td class="left">'.$row['cpa'].'</td>';
echo '<td class="left">'.$row['accs'].'</td>';
echo '<td class="right">'.$row['sum'].'</td>';
if($iter != 1){
echo '<td>';
if($row['layout_date'] == '0000-00-00' || $row['layout_date'] == '1970-01-01')
echo "";
else
echo date('d.m.Y', strtotime($row['layout_date']));
echo '</td>';
echo '<td>'.date('d.m.Y', strtotime($row['final_date'])).'</td>';
}
else
{
echo '<td>';
if($row['layout_date'] == '0000-00-00' || $row['layout_date'] == '1970-01-01')
echo "";
else
echo date('d.m.Y', strtotime($row['layout_date']));
echo '</td>';
}
echo '</tr>';
}
echo '</table></div>';
}
?>
guest 13.12.2016 17:34 # −1
bayan 13.12.2016 17:36 # −1
zenn1989 16.12.2016 09:47 # 0
Еще в
обернуть и ваааще на мобильных дИвайсах заработаеД!111