深圳全飞鸿

标题: pmp的sql [打印本页]

作者: zhgc 时间: 2022-10-3 16:40
标题: pmp的sql
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 时间: 2022-10-4 14:50
直接用的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();

欢迎光临深圳全飞鸿 (http://www.nagomes.com/disc/)