/**
* 拼接单条的高级查询SQL
* @param conditionSql 条件SQL
* @param leftParentheses 左括号 0-( 1-(( 2-((( 3-(((( 4-(((((
* @param field 字段信息
* @param condition 条件 0-= 1-!= 2-like 3-start with 4-end with 5-> 6->= 7-< 8-<= 9-is null 10-is not null
* @param value 值
* @param rightParentheses 右括号 0-) 1-)) 2-))) 3-)))) 4-)))))
* @param logic 逻辑符号 0-and 1-or
*/
static function getSingleAdvanceQueryConditionSql($leftParentheses, $field, $condition, $value, $rightParentheses, $logic, &$args)
{
$conditionSql = "";
// 获取左括号内容、右括号内容、逻辑符号内容
$logic = QueryUtils::getConditionLogicContent($logic);
// 根据条件类型拼接SQL
$conditionSql .= " " . $leftParentheses . " ";
if ($condition === "0") {
$conditionSql .= " " . $field . " = ? ";
array_push($args, $value);
} else {
if ($condition === "1") {
$conditionSql .= " " . $field . " != ? ";
array_push($args, $value);
} else {
if ($condition === "2") {
$conditionSql .= " " . $field . " like ? ";
array_push($args, "%" . $value . "%");
} else {
if ($condition === "3") {
$conditionSql .= " " . $field . " like ? ";
array_push($args, $value . "%");
} else {
if ($condition === "4") {
$conditionSql .= " " . $field . " like ? ";
array_push($args, "%" . $value);
} else {
if ($condition === "5") {
$conditionSql .= " " . $field . " > ? ";
array_push($args, $value);
} else {
if ($condition === "6") {
$conditionSql .= " " . $field . " >= ? ";
array_push($args, $value);
} else {
if ($condition === "7") {
$conditionSql .= " " . $field . " < ? ";
array_push($args, $value);
} else {
if ($condition === "8") {
$conditionSql .= " " . $field . " <= ? ";
array_push($args, $value);
} else {
if ($condition === "9") {
$conditionSql .= " " . $field . " is null ";
} else {
if ($condition === "10") {
$conditionSql .= " " . $field . " is not null ";
}
}
}
}
}
}
}
}
}
}
}
$conditionSql .= " " . $rightParentheses . " ";
$conditionSql .= " " . $logic . " ";
return $conditionSql;
}
