Asju W

All generations.

fix invalid codeSat, 15 Apr 2023

function jjj($array){ if(isset($array['query'])){ switch($array['category']){ default: break; case 'a': $HelperCategory = "HelperCategory= '1' AND"; break; case 'd': $HelperCategory = "HelperCategory= '2' AND"; break; case 'k': $HelperCategory = "HelperCategory= '3' AND"; break; case 'p': $HelperCategory = "HelperCategory= '4' AND"; break; } switch($array['query']){ default: break; case 'sex': $query = "HelperSex"; break; case 'service': $query = "HelperServiceStatus"; break; case 'action': $query = "HelperActionStatus"; break; } $sql = $this->db->query(" SELECT HelperCategory, $query, count($query) FROM Helpers WHERE $HelperCategory HelperActionStatus IN('действующий','приостановленный') GROUP BY $query "); if ($sql->fetchColumn() <= 0){ return []; }else{ $sql = $this->db->query(" SELECT HelperCategory, $query, count($query) AS count$query FROM Helpers WHERE $HelperCategory HelperActionStatus IN('действующий','приостановленный') GROUP BY $query "); while($row = $sql->fetch(PDO::FETCH_LAZY)){ $e[$row[$query]] = $row["count$query"];//$v; } return $e; } } }

function jjj($array){ if(isset($array['query'])){ switch($array['category']){ default: break; case 'a': $HelperCategory = "HelperCategory= '1' AND"; break; case 'd': $HelperCategory = "HelperCategory= '2' AND"; break; case 'k': $HelperCategory = "HelperCategory= '3' AND"; break; case 'p': $HelperCategory = "HelperCategory= '4' AND"; break; } switch($array['query']){ default: break; case 'sex': $query = "HelperSex"; break;

fix invalid codeSat, 15 Apr 2023

function LastDateInf($array){ if(isset($array)){ $sql = $this->db->prepare(" SELECT InfHelperId, HelperDateForVerb, InfDate, Helpers.id AS HID, CASE WHEN InfDate IS NOT NULL THEN (SELECT max(InfDate) FROM ListHelperInf WHERE InfHelperId = Helpers.id) ELSE HelperDateForVerb END AS HelperDate FROM Helpers LEFT JOIN ListHelperInf ON ListHelperInf.InfHelperId = Helpers.id WHERE Helpers.id = ? AND HelperActionStatus IN('действующий','приостановленный') AND HelperCategory IN('1','2') /**AND (strftime('%s','now') - strftime('%s', (SELECT max(InfDate) FROM ListHelperInf WHERE InfHelperId = HID))) > 13046400**/ GROUP BY InfHelperId "); $sql->execute([self::textEdit($array)]); while($row = $sql->fetch(PDO::FETCH_LAZY)){ return $this->DateMinus($row['HelperDate']); } } }

function LastDateInf($array){ if(isset($array)){ $sql = $this->db->prepare(" SELECT InfHelperId, HelperDateForVerb, InfDate, Helpers.id AS HID, CASE WHEN InfDate IS NOT NULL THEN (SELECT max(InfDate) FROM ListHelperInf WHERE InfHelperId = Helpers.id) ELSE HelperDateForVerb END AS HelperDate FROM Helpers LEFT JOIN ListHelperInf ON ListHelperInf.InfHelperId = Helpers.id WHERE Helpers.id = ? AND HelperActionStatus IN('действующий','приостановленный') AND HelperCategory IN('1

Questions about programming?Chat with your personal AI assistant