Nur Izzati Zulkifli
109 lines
3.8 KiB
PHP
109 lines
3.8 KiB
PHP
@extends('layouts.app')
|
|
|
|
@section('content')
|
|
<div class="container">
|
|
<div class="row justify-content-center">
|
|
<div class="col-md-12">
|
|
@if ($message = Session::get('success'))
|
|
<div class="alert alert-success">
|
|
<p>{{ $message }}</p>
|
|
</div>
|
|
@endif
|
|
<?php
|
|
echo " <table class='table table-striped' id='cawangan'>";
|
|
echo " <thead>";
|
|
echo " <tr>";
|
|
echo " <th>#</th>";
|
|
echo " <th>Cawangan</th>";
|
|
//echo " <th>Tarikh Lelong</th>";
|
|
echo " <th>Batch Lelong</th>";
|
|
echo " <th>Tarikh Lelong</th>";
|
|
echo " <th>Import Data</th>";
|
|
echo " <th>Senarai Lelongan</th>";
|
|
echo " <th>Export Data</th>";
|
|
echo " </tr>";
|
|
echo " </thead>";
|
|
echo "<tbody>";
|
|
|
|
$count = 0;
|
|
// $result = mysql_query("SELECT * FROM cawangan_lelong");
|
|
$results = DB::select('select * from cawangan');
|
|
foreach($results as $row)
|
|
{
|
|
$caw_ip = $row->caw_ip;
|
|
$caw_dbuser = $row->caw_dbuser;
|
|
$caw_dbpass = $row->caw_dbpass;
|
|
$caw_dbname = $row->caw_dbname;
|
|
$caw_name = $row->caw_name;
|
|
$caw_id = $row->id;
|
|
|
|
//dd($caw_ip);
|
|
|
|
$db = mysqli_connect($caw_ip,$caw_dbuser, $caw_dbpass);
|
|
if (!$db)
|
|
{
|
|
echo "<p style='color:#F00'>Server Down: $con[caw_dbname]/$con[caw_name]</p>";
|
|
continue;
|
|
die('Could not connect: ' . mysqli_error());
|
|
}
|
|
mysqli_select_db($db,$caw_dbname);
|
|
$count++;
|
|
|
|
$result_tender = mysqli_query($db,"SELECT *, lelong.batchno as batch, DATE_FORMAT(tarikh, '%d/%m/%Y') AS tarikh FROM batchlel
|
|
JOIN lelong ON (lelong.batchno = batchlel.batchno)
|
|
where norujukan NOT IN(select norujukan FROM gadai where sttebus = 'L' OR sttebus = 'H') and lelong.hargajual = '0.00' and lelong.nopembeli = '0' ORDER BY `batchlel`.`tarikh` ASC");
|
|
$row_tender = mysqli_fetch_array($result_tender);
|
|
|
|
$result_tender1 = mysqli_query($db,"SELECT MAX(batchno) as batchno
|
|
FROM batchlel");
|
|
$row_tender1 = mysqli_fetch_array($result_tender1);
|
|
|
|
$batchno = $row_tender['batch'];
|
|
$tarikh = $row_tender['tarikh'];
|
|
|
|
echo "<tr>";
|
|
echo "<td>$count</td>";
|
|
echo "<td>$caw_name</td>";
|
|
//echo "<td>$tarikh</td>";
|
|
echo "<td>$batchno</td>";
|
|
echo "<td>$tarikh</td>";
|
|
echo "<td><a class='btn btn-info' href='export_tolelong/$caw_id/$batchno'><i class='fa fa-delete'></i>Import Data</a></td>";
|
|
echo "<td><a class='btn btn-success' href='list_lelongan_caw/$caw_id/$batchno'><i class='fa fa-delete'></i>Lihat Senarai</a></td>";
|
|
echo "<td><a class='btn btn-warning' href='export_tolelong_livecaw/$caw_id/$batchno'><i class='fa fa-success'></i>Export Data</a></td>";
|
|
echo "</tr>";
|
|
|
|
}
|
|
echo "</table>"?>
|
|
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<script>
|
|
//Enable tooltips everywhere
|
|
$(function () {
|
|
$('[data-toggle="tooltip"]').tooltip()
|
|
})
|
|
function confirm() {
|
|
$.confirm({
|
|
title: 'Confirmation',
|
|
content: 'Anda pasti?',
|
|
type: 'orange',
|
|
typeAnimated: true,
|
|
buttons: {
|
|
Simpan: {
|
|
btnClass: 'btn-warning',
|
|
action: function () {
|
|
$("#formeditconnection").submit();
|
|
}
|
|
},
|
|
Batal: {
|
|
btnClass: 'btn-default',
|
|
action: function () {}
|
|
}
|
|
}
|
|
});
|
|
}
|
|
|
|
</script>
|
|
@endsection
|