<?php
namespace
Home\Model;
use
Think\Model;
class
YmdModel
extends
Model{
public
function
__construct(){
$this
->dbYimudi = M('yimudi');
$this
->dbYimudiUse = M('yimudi_use');
$this
->dbYimudiInfo = M('yimudi_info');
$this
->dbYimudiCi = M('yimudi_ci');
}
public
function
getYimudiOne(
$condition
,
$field
){
if
(!
$condition
) {
return
false;
}
else
{
return
$this
->dbYimudiUse->table('yimudi_use yu,yimudi y')->where(' yu.yimudi_id = y.yimudi_id'.
$condition
)->field(
$field
)->find();
}
}
public
function
getYimudiUseCount(
$condition
){
if
(!
$condition
) {
return
false;
}
else
{
return
$this
->dbYimudiUse->where(
$condition
)->
count
();
}
}
public
function
getEchangeYimudiCount(
$condition
){
if
(!
$condition
) {
return
false;
}
else
{
return
$this
->dbYimudiUse->table('yimudi_use yu,yimudi y')->where(' yu.yimudi_id = y.yimudi_id'.
$condition
)->sum('change_num');
}
}
public
function
getExchageByYimudiId(
$condition
,
$field
){
if
(!
$condition
) {
return
false;
}
else
{
return
$this
->dbYimudiUse->table('yimudi_use yu,yimudi_ci yc')->where(' yu.yimudi_id = yc.yimudi_id'.
$condition
)->field(
$field
)->group('yu.yimudi_id')->select();
}
}
public
function
updateYimudiUse(
$condition
,
$data
){
if
(!
$condition
) {
return
false;
}
else
{
return
$this
->dbYimudiUse->where(
$condition
)->save(
$data
);
}
}
public
function
getYimudiList(
$condition
,
$start
,
$size
){
if
(!
$condition
) {
return
false;
}
else
{
return
$this
->dbYimudiUse->table('yimudi_use
as
yu')->join('yimudi
as
y on yu.yimudi_id = y.yimudi_id', 'left')->join('yimudi_cinema
as
yc on yu.yimudi_id = yc.cinema_id', 'left')->where(
$condition
)->field(
$field
)->limit(
$start
,
$size
)->select();
}
}
public
function
getYimudiCount(
$condition
){
if
(!
$condition
) {
return
false;
}
else
{
return
$this
->dbYimudiUse->table('yimudi_use
as
yu')->join('yimudi
as
y on yu.yimudi_id = y.yimudi_id', 'left')->join('yimudi_ci
as
yc on yu.yimudi_id = yc.yimudi_id', 'left')->where(
$condition
)->
count
();
}
}
public
function
getYimudiListAjax(
$condition
,
$start
,
$size
){
if
(!
$condition
) {
return
false;
}
else
{
return
$this
->dbYimudiUse->table('yimudi_use
as
yu')->join('yimudi
as
y on yu.yimudi_id = y.yimudi_id', 'left')->join('yimudi_ci
as
yc on yu.yimudi_id = yc.yimudi_id', 'left')->where(
$condition
)->field(
$field
)->limit(
$start
,
$size
)->select();
}
}
public
function
getYimudiCiDecription(
$condition
,
$file
){
if
(!
$condition
) {
return
false;
}
else
{
return
$this
->dbYimudiCi->where(
$condition
)->field(
$field
)->find();
}
}
public
function
getCiYimudiList(
$condition
,
$start
,
$size
){
if
(!
$condition
) {
return
false;
}
else
{
return
$this
->dbYimudiCiInfo->where(
$condition
)->limit(
$start
,
$size
)->select();
}
}
public
function
getCiYimudiById(
$condition
){
if
(!
$condition
) {
return
false;
}
else
{
return
$this
->dbYimudiUse->table('yimudi_use
as
yu')->join('yimudi
as
y on yu.yimudi_id = y.yimudi_id', 'left')->join('yimudi_ci
as
yc on yu.yimudi_id = yc.yimudi_id', 'left')->where(
$condition
)->field(
$field
)->find();
}
}
}