1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77
| // php - Model
static function getSpecificProfessionalActivePieces() {
global $bdd;
var_dump($_POST);
$specificProfessionalPieces ="";
$clausePlace = "";
$clauseGauge = "";
$clauseDuration = "";
$clauseAudience = "";
//$placeParam = "";
//$gaugeParam = "";
//$durationParam = "";
//$audienceParam = "";
$sqlSelect = "SELECT p.id, p.flyer, p.piece_name FROM piece p INNER JOIN universe u INNER JOIN piece_universe pu ON pu.piece_id = p.id AND u.id = pu.universe_id INNER JOIN troop t INNER JOIN piece_troop pt ON t.id = pt.troop_id AND p.id = pt.piece_id WHERE pt.troop_id LIKE 1 AND p.situation LIKE `Actif`";
if (!empty($_POST))
{
switch ($_POST['placeChoice']) {
case "":
$clausePlace = "";
$specificProfessionalPieces = "";
break;
default :
$clausePlace = "pu.universe_id = :placeChoice";
$specificProfessionalPieces -> bindValue(':placeChoice', $_POST['placeChoice'], PDO::PARAM_STR);
break;
}
switch ($_POST['gaugeChoice']) {
case "":
$clauseGauge = "";
$specificProfessionalPieces = "";
break;
default :
$clauseGauge = "max_gauge = :gaugeChoice";
$specificProfessionalPieces -> bindValue(':gaugeChoice', $_POST['gaugeChoice'], PDO::PARAM_STR);
break;
}
switch ($_POST['durationChoice']) {
case "":
$clauseDuration ="";
$specificProfessionalPieces = "";
break;
default :
$clauseDuration = "duration = :durationChoice";
$specificProfessionalPieces -> bindValue(':durationChoice', $_POST['durationChoice'], PDO::PARAM_STR);
}
switch ($_POST['audienceChoice']) {
case "":
$clauseAudience ="";
$specificProfessionalPieces = "";
break;
default :
$clauseAudience = "audienceChoice = :audienceChoice";
$specificProfessionalPieces -> bindValue(':audienceChoice', $_POST['audienceChoice'], PDO::PARAM_STR);
}
}
$clauseWhere = "AND " . $clausePlace . " AND " . $clauseGauge . " AND " . $clauseDuration . " AND " . $clauseAudience;
$req = $sqlSelect . $clauseWhere . ";";
$specificProfessionalPieces = $bdd->prepare($req);
//$specificProfessionalPieces->bindValue($placeParam, PDO::PARAM_INT);
//$specificProfessionalPieces->bindValue($gaugeParam, PDO::PARAM_STR);
//$specificProfessionalPieces->bindValue($durationParam, PDO::PARAM_STR);
//$specificProfessionalPieces->bindValue($audienceParam, PDO::PARAM_STR);
$specificProfessionalPieces->execute();
return $specificProfessionalPieces->fetchAll();
} |
Partager