pmp的sql

zhgc

pmp的sql

>>>>d:\project.syant\0005php\htdocs\pmp\lib\base\dao\dao.class.php<<<<<
class baseDAO
>>>>d:\project.syant\0005php\htdocs\pmp\lib\dao\dao.class.php<<<<<
class dao extends baseDAO



输入SQL:
    /**
     * 打印sql字符串。
     * Print the sql string.
     *
     * @access public
     * @return void
     */
    public function printSQL()
    {
        echo $this->processSQL();
    }

zhgc

直接用的processSQL()
                $sql=$this->dao->select('*,  IF(INSTR(" closed", status) < 2, 0, 1) AS isClosed')
            ->from(TABLE_PRODUCT)
            ->where('deleted')->eq(0)
                        ->andWhere('ptype')->eq(1)
            ->beginIF(strpos($mode, 'noclosed') !== false)->andWhere('status')->ne('closed')->fi()
            ->beginIF(!$this->app->user->admin)->andWhere('id')->in($this->app->user->view->products)->fi()
            ->orderBy($orderBy)->processSQL();