?> "> <?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>';