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