当前位置: 首页>>代码示例>>PHP>>正文


PHP SQLQBuilder::simpleDelete方法代码示例

本文整理汇总了PHP中SQLQBuilder::simpleDelete方法的典型用法代码示例。如果您正苦于以下问题:PHP SQLQBuilder::simpleDelete方法的具体用法?PHP SQLQBuilder::simpleDelete怎么用?PHP SQLQBuilder::simpleDelete使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在SQLQBuilder的用法示例。


在下文中一共展示了SQLQBuilder::simpleDelete方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: copyQuota

 /**
  * Copy leave quota between years
  *
  * Copy leave quota from $fromYear to $toYear
  *
  * @param int $fromYear
  * @param int $toYear
  * @return boolean
  */
 public function copyQuota($fromYear, $toYear)
 {
     $sqlBuilder = new SQLQBuilder();
     $table = "`" . self::LEAVEQUOTA_DB_TABLE_EMPLOYEE_LEAVE_QUOTA . "`";
     $insertFields[0] = "`" . self::LEAVEQUOTA_DB_FIELD_YEAR . "`";
     $insertFields[1] = "`" . self::LEAVEQUOTA_DB_FIELD_LEAVE_TYPE_ID . "`";
     $insertFields[2] = "`" . self::LEAVEQUOTA_DB_FIELD_EMPLOYEE_ID . "`";
     $insertFields[3] = "`" . self::LEAVEQUOTA_DB_FIELD_NO_OF_DAYS_ALLOTED . "`";
     $selectFields[0] = "{$toYear}";
     $selectFields[1] = "`" . self::LEAVEQUOTA_DB_FIELD_LEAVE_TYPE_ID . "`";
     $selectFields[2] = "`" . self::LEAVEQUOTA_DB_FIELD_EMPLOYEE_ID . "`";
     $selectFields[3] = "`" . self::LEAVEQUOTA_DB_FIELD_NO_OF_DAYS_ALLOTED . "`";
     $selectConditions[0] = "`" . self::LEAVEQUOTA_DB_FIELD_YEAR . "` = '{$fromYear}'";
     $selectQuery = $sqlBuilder->simpleSelect($table, $selectFields, $selectConditions);
     $deleteConditions[0] = "`" . self::LEAVEQUOTA_DB_FIELD_YEAR . "` = '{$toYear}'";
     $deleteQuery = $sqlBuilder->simpleDelete($table, $deleteConditions);
     $query = $sqlBuilder->simpleInsert($table, $selectQuery, $insertFields);
     $dbConnection = new DMLFunctions();
     $dbConnection->executeQuery($deleteQuery);
     $result = $dbConnection->executeQuery($query);
     if ($result) {
         return true;
     }
     return false;
 }
开发者ID:noikiy,项目名称:owaspbwa,代码行数:34,代码来源:LeaveQuota.php


注:本文中的SQLQBuilder::simpleDelete方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。