?>
">
<?php
echo str_pad($row['month'], 2, "0", STR_PAD_LEFT);
?>
- <?php
echo $row['year'];
?>
</a>
</td>
<?php
if ($_SESSION['level'] == 1) {
?>
<td style="text-align:center">
<?php
echo $model->getNameById('users', $row['user_id']);
?>
</td>
<?php
}
?>
<td style="text-align:right"><?php
echo number_format($row['doanhthu']);
?>
</td>
<td style="text-align:right"><?php
echo number_format($row['congno']);
?>
</td>
</td>
<td>
<a href="index.php?mod=houserent&act=form&id=<?php
echo $row['id'];
?>
">
<?php
echo $row['name'];
?>
</a>
<br />
Địa chỉ : <?php
echo $row['address'];
?>
, Phường <?php
echo $model->getNameById('ward', $row['ward_id']);
?>
, <?php
echo $model->getNameById('district', $row['district_id']);
?>
, <?php
echo $model->getNameById('city', $row['city_id']);
?>
</td>
<td align="center"><?php
echo date('d-m-Y H:i', $row['created_at']);
?>
</td>
<td align="center"><?php
echo date('d-m-Y H:i', $row['updated_at']);
?>
&act=form&id=<?php
echo $row['object_id'];
?>
" target="_blank">
<?php
echo $detail['name'];
?>
</a>
<br />
Người thuê :
<a href="index.php?mod=customers&act=form&id=<?php
echo $row['customer_id'];
?>
" target="_blank">
<?php
echo $model->getNameById("customers", $row['customer_id']);
?>
</a>
</td>
<td style="text-align:right"><?php
echo number_format($row['price']);
?>
</td>
<td style="text-align:center"><?php
echo number_format($row['no_person']);
?>
</td>
<td style="text-align:center"><?php
echo $row['no_month'];
?>
tháng</td>
<td width="30%">
<a style="font-size:19px;color:#B10007" href="index.php?mod=product&act=form&id=<?php
echo $row['id'];
?>
&cate_type_id=<?php
echo $row['cate_type_id'];
?>
">
<?php
echo $row['name_vi'];
?>
</a> <br>
<span class="title-value">Loại SP :</span>
<span class="value"><?php
echo $model->getNameById('cate_type', $row['cate_type_id']);
?>
</span><br>
<span class="title-value">Giá :</span>
<span class="value"><?php
echo number_format($row['price']);
?>
</span><br>
<?php
if ($row['is_sale'] == 1) {
?>
<span class="title-value">Giá khuyến mãi:</span>
<span class="value"><?php
echo number_format($row['price_sale']);
?>
</span><br>
}
?>
</td>
<td width="50%">
<a style="font-size:19px;color:#B10007" href="index.php?mod=articles&act=form&id=<?php
echo $row['id'];
?>
">
<?php
echo $row['name_vi'];
?>
</a>
<br>
<strong style="font-size:12px"><?php
echo $model->getNameById('articles_cate', $row['cate_id']);
?>
</strong>
</td>
<td style="text-align:center;width: 1%;white-space:nowrap">
<div class="checkbox">
<input data-value="<?php
echo $row['id'];
?>
" data-table="articles" data-column="is_hot" class="change-column" type="checkbox" <?php
if ($row['is_hot'] == 1) {
echo "checked";
}
?>
>
</div>
$i = ($page - 1) * LIMIT;
if (!empty($list['data'])) {
foreach ($list['data'] as $key => $row) {
$i++;
?>
<tr>
<td><?php
echo $i;
?>
</td>
<td><?php
echo $row['name'];
?>
</td>
<td><?php
echo $model->getNameById('city', $row['city_id']);
?>
</td>
<td><?php
echo date('d-m-Y', $row['created_at']);
?>
</td>
<td style="white-space:nowrap">
<a href="index.php?mod=district&act=form&id=<?php
echo $row['id'];
?>
" class="btn btn-sm btn-warning">
Chỉnh sửa
</a>
<a href="javascript:;" alias="<?php
echo $row['name'];
$month = isset($_GET['month']) ? (int) $_GET['month'] : -1;
$year = isset($_GET['year']) ? (int) $_GET['year'] : -1;
$user_id = isset($_GET['user_id']) ? (int) $_GET['user_id'] : -1;
$arrTotal = $model->getDoanhThuTotalUser($user_id, $month, $year);
require_once 'PHPExcel.php';
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set document properties
$objPHPExcel->getProperties()->setCreator("HoangNH")->setLastModifiedBy("HoangNH")->setTitle("Office 2007 XLSX vinawatch.com")->setSubject("Office 2007 XLSX vinawatch.com")->setDescription("")->setKeywords("")->setCategory("");
// Add some data
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', 'Tháng')->setCellValue('B1', 'Năm')->setCellValue('C1', 'Doanh thu')->setCellValue('D1', 'Công nợ')->setCellValue('E1', 'Mod');
$i = 1;
if (!empty($arrTotal)) {
foreach ($arrTotal as $value) {
$i++;
$name = $model->getNameById('users', $value['user_id']);
// Add some data
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, str_pad($value['month'], 0, STR_PAD_LEFT))->setCellValue('B' . $i, $value['year'])->setCellValue('C' . $i, $value['doanhthu'])->setCellValue('D' . $i, $value['congno'])->setCellValue('E' . $i, $name);
}
}
// Rename worksheet
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(300);
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(300);
$objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(300);
$objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(300);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
</div>
<?php
if ($object_type == 1) {
?>
<fieldset>
<legend style="background-color:#ffcccc">Tiền dịch vụ</legend>
<?php
foreach ($serviceSelectedArr as $key => $value) {
//var_dump($value['cal_type']);
?>
<div class="col-md-12" style="border:1px solid #CCC; padding:10px;margin-bottom:10px">
<p style="font-weight:bold;font-size:15px;text-transform:uppercase;background-color:#CCC;padding:5px">
<?php
echo $model->getNameById("services", $value['service_id']);
?>
</p>
<?php
if ($value['cal_type'] == 1) {
?>
Tính theo phòng : <span class="price"><?php
echo number_format($arrServiceHouse[$value['service_id']]['price']);
?>
</span>
<input type="hidden" name="service_id[]" value="<?php
echo $value['service_id'];
?>
">
<input type="hidden" class="total" name="service_fee[<?php
echo $value['service_id'];
<div class="row">
<div class="col-md-12">
<button class="btn btn-primary btn-sm right" onclick="location.href='index.php?mod=reportdoanhthu&act=list'">Xem tổng doanh tu</button>
<div class="box-header">
<h3 class="box-title">Report chi tiết doanh thu : <span style="color:red"> tháng <?php
echo str_pad($month, 2, "0", STR_PAD_LEFT);
?>
- <?php
echo $year;
?>
</span>
<?php
if ($user_id > 0) {
?>
của mod <span style="color:blue"><?php
echo $model->getNameById('users', $user_id);
?>
</span>
<?php
}
?>
</h3>
</div><!-- /.box-header -->
<div class="box">
<div class="box-body">
<div class="panel panel-default">
<div class="panel-heading">Tìm kiếm</div>
<div class="panel-body">
<form class="form-inline">
?>
">
<?php
echo $row['name'];
?>
</a>
<br />
Nhà : <?php
echo $houseDetail['name'];
?>
<br />
Địa chỉ : <?php
echo $houseDetail['address'];
?>
, Phường <?php
echo $model->getNameById('ward', $row['ward_id']);
?>
, <?php
echo $model->getNameById('district', $row['district_id']);
?>
, <?php
echo $model->getNameById('city', $row['city_id']);
?>
</td>
<td>
<?php
if ($row['status'] == 1) {
echo '<h4><span class="label label-lg label-success">Đang trống</span></h4>';
}
if ($row['status'] == 2) {
echo '<h4><span class="label label-warning">Đã cọc</span></h4>';
