function __construct()
{
global $c;
$this->c =& $c;
$out = '<option value="">Choose</option>';
if (isset($_GET['sector'])) {
try {
$conn = $this->conn($this->c);
$sql = 'SELECT `idx`,`title` FROM `studio404_pages` WHERE `cid`=:cid AND `lang`=:lang AND `status`!=:status AND `visibility`=:visibility ORDER BY `position` ASC';
$prepare = $conn->prepare($sql);
$prepare->execute(array(":cid" => 27, ":visibility" => 2, ":lang" => LANG_ID, ":status" => 1));
$fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
foreach ($fetch as $f) {
$out .= '<option value="' . (int) $f['idx'] . '">' . htmlentities($f['title']) . '</option>';
}
} catch (Exception $e) {
$out = "Error loading sector !";
}
} else {
if (isset($_GET['sub_sector'], $_GET['sub_idx']) && is_numeric($_GET['sub_idx'])) {
try {
$conn = $this->conn($this->c);
$sql = 'SELECT `idx`,`title` FROM `studio404_pages` WHERE `cid`=:cid AND `lang`=:lang AND `status`!=:status AND `visibility`=:visibility ORDER BY `position` ASC';
$prepare = $conn->prepare($sql);
$prepare->execute(array(":cid" => $_GET['sub_idx'], ":visibility" => 2, ":lang" => LANG_ID, ":status" => 1));
$fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
foreach ($fetch as $f) {
$out .= '<option value="' . (int) $f['idx'] . '">' . htmlentities($f['title']) . '</option>';
}
} catch (Exception $e) {
$out = "Error loading sub sector !";
}
} else {
if (isset($_GET['sme'])) {
try {
$conn = $this->conn($this->c);
$sql = 'SELECT `idx`,`title` FROM `studio404_pages` WHERE `cid`=:cid AND `lang`=:lang AND `status`!=:status AND `visibility`=:visibility ORDER BY `position` ASC';
$prepare = $conn->prepare($sql);
$prepare->execute(array(":cid" => 33, ":visibility" => 2, ":lang" => LANG_ID, ":status" => 1));
$fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
foreach ($fetch as $f) {
$out .= '<option value="' . (int) $f['idx'] . '">' . htmlentities($f['title']) . '</option>';
}
} catch (Exception $e) {
$out = "Error loading sub sector !";
}
} else {
if (isset($_GET['export_markets'])) {
try {
$conn = $this->conn($this->c);
$sql = 'SELECT `idx`,`title` FROM `studio404_pages` WHERE `cid`=:cid AND `lang`=:lang AND `status`!=:status AND `visibility`=:visibility ORDER BY `position` ASC';
$prepare = $conn->prepare($sql);
$prepare->execute(array(":cid" => 37, ":visibility" => 2, ":lang" => LANG_ID, ":status" => 1));
$fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
foreach ($fetch as $f) {
$out .= '<option value="' . (int) $f['idx'] . '">' . htmlentities($f['title']) . '</option>';
}
} catch (Exception $e) {
$out = "Error loading export markets !";
}
} else {
if (isset($_GET['newsletterGroups'])) {
try {
$conn = $this->conn($this->c);
$sql = 'SELECT `id`,`name` FROM `studio404_newsletter_emails` WHERE `type`=:type AND `group_id`=:group_id AND `status`!=:status ORDER BY `name` ASC';
$prepare = $conn->prepare($sql);
$prepare->execute(array(":type" => 'group', ":group_id" => 0, ":status" => 1));
$fetch = $prepare->fetchAll(PDO::FETCH_ASSOC);
$model_admin_menageemails = new model_admin_menageemails();
foreach ($fetch as $f) {
$num = $model_admin_menageemails->countinsideemails($this->c, $f['id']);
$out .= '<option value="' . (int) $f['id'] . '">' . htmlentities($f['name']) . ' ( ' . $num . ' )</option>';
}
} catch (Exception $e) {
$out = "Error loading newsletter groups !";
}
}
}
}
}
}
echo $out;
}
