PHP app\models Sell::findBySql Examples

Example #1

File: bill.php Project: vbboy2012/1861886

echo Html::a('单据回收', ['sell/back'], ['class' => 'btn btn-success']);
?>
            <hr>
            </p>
            <?php 
echo Html::a('增加一行', '#', ['id' => 'sell-tr']);
?>
            <?php 
$isNewbill = false;
//是否为新单据
if ($sellNum == "") {
    $isNewbill = true;
    $num = date("Ymd", time());
    $count = 0;
    $sql = "SELECT * FROM tbl_sell WHERE uid=" . Yii::$app->user->id . " AND left(sellnum,8)=" . $num . " order by id desc";
    $sell = Sell::findBySql($sql)->one();
    if ($sell) {
        $sellNum = $sell->getAttribute('sellnum');
        $sellNum += 1;
    } else {
        $sellNum = $num . "01";
    }
} else {
    $sell = Sell::find()->where(['uid' => Yii::$app->user->id, 'sellnum' => $sellNum, 'status' => 0])->all();
}
?>
            <?php 
echo Html::label('单据号:');
?>
            <?php 
echo Html::label($sellNum, null, ['id' => 'sellNum']);