.-.-.-.-.-

<?php
class Metadata {
    private $con;

public function __construct(DBConnection $database) {
        if (!$database->dbc) {
            throw new Exception("Invalid database connection");
        }
        $this->con = $database;
    }

public function getMetadataByCampaignid(int $id) {
        $query = "SELECT `id`, `campaigninfoid`, `slogan-de`, `slogan-fr`, `slogan-it`, `image-path-de`, `image-path-fr`, `image-path-it`, `campaignstatus`, `collected`, `pre-check-date`, `collection-start-date`, `collection-expiry-date`, `submitted-date`, `pre-check-url`, `pre-check-bbl`, `link-to-signature-form`, `link-to-detail-page`, `campaigntype`, `signature-form-path-pdf-de`, `signature-form-path-pdf-fr`, `signature-form-path-pdf-it`, `signature-form-path-jpg-de`, `signature-form-path-jpg-fr`, `signature-form-path-jpg-it`, `bkid`, `initiatoremail`, `initiatorname`, `initiatorstreet`, `initiatorzipcode`, `initiatortown` FROM `nvbjn_chronoforms_campaign_metadata` WHERE `id` = :id";
        $stmt = $this->con->dbc->prepare($query);
        $stmt->bindParam(':id', $id, PDO::PARAM_INT);
        $stmt->execute();
        return $stmt->fetch(PDO::FETCH_ASSOC);
    }

public function getMetadataByBkid(int $bkid) {
        $query = "SELECT `id`, `campaigninfoid`, `slogan-de`, `slogan-fr`, `slogan-it`, `image-path-de`, `image-path-fr`, `image-path-it`, `campaignstatus`, `collected`, `pre-check-date`, `collection-start-date`, `collection-expiry-date`, `submitted-date`, `pre-check-url`, `pre-check-bbl`, `link-to-signature-form`, `link-to-detail-page`, `campaigntype`, `signature-form-path-pdf-de`, `signature-form-path-pdf-fr`, `signature-form-path-pdf-it`, `signature-form-path-jpg-de`, `signature-form-path-jpg-fr`, `signature-form-path-jpg-it`, `bkid`, `initiatoremail`, `initiatorname`, `initiatorstreet`, `initiatorzipcode`, `initiatortown` FROM `nvbjn_chronoforms_campaign_metadata` WHERE `bkid` = :bkid";
        $stmt = $this->con->dbc->prepare($query);
        $stmt->bindParam(':bkid', $bkid, PDO::PARAM_INT);
        $stmt->execute();
        return $stmt->fetch(PDO::FETCH_ASSOC);
    }

public function getMetadataBySlogan(string $slogan) {
        $query = "SELECT `id`, `campaigninfoid`, `slogan-de`, `slogan-fr`, `slogan-it`, `image-path-de`, `image-path-fr`, `image-path-it`, `campaignstatus`, `collected`, `pre-check-date`, `collection-start-date`, `collection-expiry-date`, `submitted-date`, `pre-check-url`, `pre-check-bbl`, `link-to-signature-form`, `link-to-detail-page`, `campaigntype`, `signature-form-path-pdf-de`, `signature-form-path-pdf-fr`, `signature-form-path-pdf-it`, `signature-form-path-jpg-de`, `signature-form-path-jpg-fr`, `signature-form-path-jpg-it`, `bkid`, `initiatoremail`, `initiatorname`, `initiatorstreet`, `initiatorzipcode`, `initiatortown` FROM `nvbjn_chronoforms_campaign_metadata` WHERE `slogan-de` = :slogan";
        $stmt = $this->con->dbc->prepare($query);
        $trimmedslogan = trim($slogan);
        $stmt->bindParam(':slogan', $trimmedslogan, PDO::PARAM_STR);
        $stmt->execute();
        return $stmt->fetch(PDO::FETCH_ASSOC);
    }

public function getMaxid() {
        $query = "SELECT COALESCE(MAX(id), 0) AS max_id, COALESCE(MAX(campaigninfoid), 0) AS max_campaigninfoid FROM `nvbjn_chronoforms_campaign_metadata`";
        $stmt = $this->con->dbc->prepare($query);
        $stmt->execute();
        $result = $stmt->fetch(PDO::FETCH_ASSOC);
        return max($result['max_id'], $result['max_campaigninfoid']);
    }

public function insert($data) {
        $mdata = [
            'campaigninfoid' => $data['campaigninfoid'],
            'slogande' => $data['slogande'],
            'sloganfr' => $data['sloganfr'],
            'sloganit' => $data['sloganit'],
            'imagepathde' => $data['imagepathde'],
            'imagepathfr' => $data['imagepathfr'],
            'imagepathit' => $data['imagepathit'],
            'campaignstatus' => $data['campaignstatus'],
            'collected' => isset($data['collected']) ? (int) $data['collected'] : 0,
            'precheckdate' => $data['precheckdate'],
            'collectionstartdate' => $data['collectionstartdate'],
            'collectionexpirydate' => $data['collectionexpirydate'],
            'submitteddate' => $data['submitteddate'],
            'precheckurl' => $data['precheckurl'],
            'precheckbbl' => $data['precheckbbl'],
            'linktosignatureform' => $data['linktosignatureform'],
            'linktodetailpage' => $data['linktodetailpage'],
            'campaigntype' => $data['campaigntype'],
            'signatureformpathpdfde' => $data['signatureformpathpdfde'],
            'signatureformpathpdffr' => $data['signatureformpathpdffr'],
            'signatureformpathpdfit' => $data['signatureformpathpdfit'],
            'signatureformpathjpgde' => $data['signatureformpathjpgde'],
            'signatureformpathjpgfr' => $data['signatureformpathjpgfr'],
            'signatureformpathjpgit' => $data['signatureformpathjpgit'],
            'bkid' => $data['bkid'],
            'initiatoremail' => $data['initiatoremail'],
            'initiatorname' => $data['initiatorname'],
            'initiatorstreet' => $data['initiatorstreet'],
            'initiatorzipcode' => $data['initiatorzipcode'],
            'initiatortown' => $data['initiatortown']
        ];

$insertSQL = "INSERT INTO `nvbjn_chronoforms_campaign_metadata` (`campaigninfoid`, `slogan-de`, `slogan-fr`, `slogan-it`, `image-path-de`, `image-path-fr`, `image-path-it`, `campaignstatus`, `collected`, `pre-check-date`, `collection-start-date`, `collection-expiry-date`, `submitted-date`, `pre-check-url`, `pre-check-bbl`, `link-to-signature-form`, `link-to-detail-page`, `campaigntype`, `signature-form-path-pdf-de`, `signature-form-path-pdf-fr`, `signature-form-path-pdf-it`, `signature-form-path-jpg-de`, `signature-form-path-jpg-fr`, `signature-form-path-jpg-it`, `bkid`, `initiatoremail`, `initiatorname`, `initiatorstreet`, `initiatorzipcode`, `initiatortown`) VALUES (:campaigninfoid, :slogande, :sloganfr, :sloganit, :imagepathde, :imagepathfr, :imagepathit, :campaignstatus, :collected, :precheckdate, :collectionstartdate, :collectionexpirydate, :submitteddate, :precheckurl, :precheckbbl, :linktosignatureform, :linktodetailpage, :campaigntype, :signatureformpathpdfde, :signatureformpathpdffr, :signatureformpathpdfit, :signatureformpathjpgde, :signatureformpathjpgfr, :signatureformpathjpgit, :bkid, :initiatoremail, :initiatorname, :initiatorstreet, :initiatorzipcode, :initiatortown)";

try {
            $this->con->dbc->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $stmt = $this->con->dbc->prepare($insertSQL);
            $result = $stmt->execute($mdata);
            if ($result) {
                return $this->con->dbc->lastInsertId();
            }
            return false;
        } catch (PDOException $e) {
            $error = "Insert error: " . $e->getMessage() . ' in ' . $e->getFile() . ' on line ' . $e->getLine();
            error_log($error);
            notifyTelegramError($error);
            return false;
        }
    }

public function update($data) {
        $mdata = [
            'id' => $data['id'],
            'campaigninfoid' => $data['campaigninfoid'],
            'slogande' => $data['slogande'],
            'sloganfr' => $data['sloganfr'],
            'sloganit' => $data['sloganit'],
            'imagepathde' => $data['imagepathde'],
            'imagepathfr' => $data['imagepathfr'],
            'imagepathit' => $data['imagepathit'],
            'campaignstatus' => $data['campaignstatus'],
            'collected' => isset($data['collected']) ? (int) $data['collected'] : 0,
            'precheckdate' => $data['precheckdate'],
            'collectionstartdate' => $data['collectionstartdate'],
            'collectionexpirydate' => $data['collectionexpirydate'],
            'submitteddate' => $data['submitteddate'],
            'precheckurl' => $data['precheckurl'],
            'precheckbbl' => $data['precheckbbl'],
            'linktosignatureform' => $data['linktosignatureform'],
            'linktodetailpage' => $data['linktodetailpage'],
            'campaigntype' => $data['campaigntype'],
            'signatureformpathpdfde' => $data['signatureformpathpdfde'],
            'signatureformpathpdffr' => $data['signatureformpathpdffr'],
            'signatureformpathpdfit' => $data['signatureformpathpdfit'],
            'signatureformpathjpgde' => $data['signatureformpathjpgde'],
            'signatureformpathjpgfr' => $data['signatureformpathjpgfr'],
            'signatureformpathjpgit' => $data['signatureformpathjpgit'],
            'bkid' => $data['bkid'],
            'initiatoremail' => $data['initiatoremail'],
            'initiatorname' => $data['initiatorname'],
            'initiatorstreet' => $data['initiatorstreet'],
            'initiatorzipcode' => $data['initiatorzipcode'],
            'initiatortown' => $data['initiatortown'],
            'idw' => $data['id']
        ];

$updateSQL = "UPDATE `nvbjn_chronoforms_campaign_metadata` SET `id` = :id, `campaigninfoid` = :campaigninfoid, `slogan-de` = :slogande, `slogan-fr` = :sloganfr, `slogan-it` = :sloganit, `image-path-de` = :imagepathde, `image-path-fr` = :imagepathfr, `image-path-it` = :imagepathit, `campaignstatus` = :campaignstatus, `collected` = :collected, `pre-check-date` = :precheckdate, `collection-start-date` = :collectionstartdate, `collection-expiry-date` = :collectionexpirydate, `submitted-date` = :submitteddate, `pre-check-url` = :precheckurl, `pre-check-bbl` = :precheckbbl, `link-to-signature-form` = :linktosignatureform, `link-to-detail-page` = :linktodetailpage, `campaigntype` = :campaigntype, `signature-form-path-pdf-de` = :signatureformpathpdfde, `signature-form-path-pdf-fr` = :signatureformpathpdffr, `signature-form-path-pdf-it` = :signatureformpathpdfit, `signature-form-path-jpg-de` = :signatureformpathjpgde, `signature-form-path-jpg-fr` = :signatureformpathjpgfr, `signature-form-path-jpg-it` = :signatureformpathjpgit, `bkid` = :bkid, `initiatoremail` = :initiatoremail, `initiatorname` = :initiatorname, `initiatorstreet` = :initiatorstreet, `initiatorzipcode` = :initiatorzipcode, `initiatortown` = :initiatortown WHERE `id` = :idw";

try {
            $stmt = $this->con->dbc->prepare($updateSQL);
            return $stmt->execute($mdata);
        } catch (PDOException $e) {
            $error = "Update error: " . $e->getMessage() . ' in ' . $e->getFile() . ' on line ' . $e->getLine();
            error_log($error);
            notifyTelegramError($error);
            return false;
        }
    }

public function update2($data) {
        $mdata = [
            'id' => $data['id'],
            'campaigninfoid' => $data['campaigninfoid'],
            'slogande' => $data['slogan-de'],
            'sloganfr' => $data['slogan-fr'],
            'sloganit' => $data['slogan-it'],
            'imagepathde' => $data['image-path-de'],
            'imagepathfr' => $data['image-path-fr'],
            'imagepathit' => $data['image-path-it'],
            'campaignstatus' => $data['campaignstatus'],
            'collected' => isset($data['collected']) ? (int) $data['collected'] : 0,
            'precheckdate' => $data['pre-check-date'],
            'collectionstartdate' => $data['collection-start-date'],
            'collectionexpirydate' => $data['collection-expiry-date'],
            'submitteddate' => $data['submitted-date'],
            'precheckurl' => $data['pre-check-url'] ?? '',
            'precheckbbl' => $data['pre-check-bbl'] ?? '',
            'linktosignatureform' => $data['link-to-signature-form'],
            'linktodetailpage' => $data['link-to-detail-page'],
            'campaigntype' => $data['campaigntype'],
            'signatureformpathpdfde' => $data['signature-form-path-pdf-de'],
            'signatureformpathpdffr' => $data['signature-form-path-pdf-fr'],
            'signatureformpathpdfit' => $data['signature-form-path-pdf-it'],
            'signatureformpathjpgde' => $data['signature-form-path-jpg-de'],
            'signatureformpathjpgfr' => $data['signature-form-path-jpg-fr'],
            'signatureformpathjpgit' => $data['signature-form-path-jpg-it'],
            'bkid' => $data['bkid'],
            'initiatoremail' => $data['initiatoremail'] ?? '',
            'initiatorname' => $data['initiatorname'] ?? '',
            'initiatorstreet' => $data['initiatorstreet'] ?? '',
            'initiatorzipcode' => $data['initiatorzipcode'] ?? '',
            'initiatortown' => $data['initiatortown'] ?? '',
            'idw' => $data['id']
        ];

try {
            $stmt = $this->con->dbc->prepare($updateSQL);
            return $stmt->execute($mdata);
        } catch (PDOException $e) {
            $error = "Update2 error: " . $e->getMessage() . ' in ' . $e->getFile() . ' on line ' . $e->getLine();
            error_log($error);
            notifyTelegramError($error);
            return false;
        }
    }
}
?>

/home/wirbesti/public_html/./php/Metadata.php