PartnershipUtils::doCancelStatusOfMemberPartnership()

Complexity

Conditions	35
Paths	67

Size

Total Lines	200
Code Lines	127

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function doCancelStatusOfMemberPartnership()
    {
        global $conf, $langs, $user;

        $managedfor = getDolGlobalString('PARTNERSHIP_IS_MANAGED_FOR', 'thirdparty');

        if ($managedfor != 'member') {
            return 0; // If option 'PARTNERSHIP_IS_MANAGED_FOR' = 'thirdparty', this cron job does nothing.
        }

        $partnership = new Partnership($this->db);
        $MAXPERCALL = (!getDolGlobalString('PARTNERSHIP_MAX_EXPIRATION_CANCEL_PER_CALL') ? 25 : $conf->global->PARTNERSHIP_MAX_EXPIRATION_CANCEL_PER_CALL); // Limit to 25 per call

        $langs->loadLangs(array("partnership", "member"));

        $error = 0;
        $erroremail = '';
        $this->output = '';
        $this->error = '';
        $partnershipsprocessed = array();

        $gracedelay = getDolGlobalString('PARTNERSHIP_NBDAYS_AFTER_MEMBER_EXPIRATION_BEFORE_CANCEL');
        if ($gracedelay < 1) {
            $this->error = 'BadValueForDelayBeforeCancelCheckSetup';
            return -1;
        }

        dol_syslog(get_class($this) . "::doCancelStatusOfMemberPartnership cancel expired partnerships with grace delay of " . $gracedelay);

        $now = dol_now();
        $datetotest = dol_time_plus_duree($now, -1 * abs((float) $gracedelay), 'd');

        $this->db->begin();

        $sql = "SELECT p.rowid, p.fk_member, p.status";
        $sql .= ", d.datefin, d.fk_adherent_type, dty.subscription";
        $sql .= " FROM " . MAIN_DB_PREFIX . "partnership as p";
        $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "adherent as d on (d.rowid = p.fk_member)";
        $sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "adherent_type as dty on (dty.rowid = d.fk_adherent_type)";
        $sql .= " WHERE fk_member > 0";
        $sql .= " AND (d.datefin < '" . $this->db->idate($datetotest) . "' AND dty.subscription = 1)";
        $sql .= " AND p.status = " . ((int) $partnership::STATUS_APPROVED); // Only accepted not yet canceled
        $sql .= $this->db->order('d.rowid', 'ASC');
        // Limit is managed into loop later

        $resql = $this->db->query($sql);
        if ($resql) {
            $numofexpiredmembers = $this->db->num_rows($resql);

            $somethingdoneonpartnership = 0;
            $ifetchpartner = 0;
            while ($ifetchpartner < $numofexpiredmembers) {
                $ifetchpartner++;

                $obj = $this->db->fetch_object($resql);
                if ($obj) {
                    if (!empty($partnershipsprocessed[$obj->rowid])) {
                        continue;
                    }

                    if ($somethingdoneonpartnership >= $MAXPERCALL) {
                        dol_syslog("We reach the limit of " . $MAXPERCALL . " partnership processed, so we quit loop for this batch doCancelStatusOfMemberPartnership to avoid to reach email quota.", LOG_WARNING);
                        break;
                    }

                    $object = new Partnership($this->db);
                    $object->fetch($obj->rowid);

                    // Get expiration date
                    $expirationdate = $obj->datefin;

                    if ($expirationdate && $expirationdate < $now) {  // If contract expired (we already had a test into main select, this is a security)
                        $somethingdoneonpartnership++;

                        $result = $object->cancel($user, 0);
                        // $conf->global->noapachereload = null;
                        if ($result < 0) {
                            $error++;
                            $this->error = $object->error;
                            if (is_array($object->errors) && count($object->errors)) {
                                if (is_array($this->errors)) {
                                    $this->errors = array_merge($this->errors, $object->errors);
                                } else {
                                    $this->errors = $object->errors;
                                }
                            }
                        } else {
                            $partnershipsprocessed[$object->id] = $object->ref;

                            // Send an email to inform member
                            $labeltemplate = '(' . getDolGlobalString('PARTNERSHIP_SENDMAIL_IF_AUTO_CANCEL', 'SendingEmailOnPartnershipCanceled') . ')';

                            dol_syslog("Now we will send an email to member id=" . $object->fk_member . " with label " . $labeltemplate);

                            // Send deployment email
                            $formmail = new FormMail($this->db);

                            // Define output language
                            $outputlangs = $langs;
                            $newlang = '';
                            if (getDolGlobalInt('MAIN_MULTILANGS') && empty($newlang) && GETPOST('lang_id', 'aZ09')) {
                                $newlang = GETPOST('lang_id', 'aZ09');
                            }
                            if (!empty($newlang)) {
                                $outputlangs = new Translate("", $conf);
                                $outputlangs->setDefaultLang($newlang);
                                $outputlangs->loadLangs(array('main', 'member', 'partnership'));
                            }

                            $arraydefaultmessage = $formmail->getEMailTemplate($this->db, 'partnership_send', $user, $outputlangs, 0, 1, $labeltemplate);

                            $substitutionarray = getCommonSubstitutionArray($outputlangs, 0, null, $object);
                            complete_substitutions_array($substitutionarray, $outputlangs, $object);

                            $subject = make_substitutions($arraydefaultmessage->topic, $substitutionarray, $outputlangs);
                            $msg     = make_substitutions($arraydefaultmessage->content, $substitutionarray, $outputlangs);
                            $from = dol_string_nospecial($conf->global->MAIN_INFO_SOCIETE_NOM, ' ', array(",")) . ' <' . getDolGlobalString('MAIN_INFO_SOCIETE_MAIL') . '>';

                            // We are in the case of autocancellation subscription because of missing backlink
                            $fk_partner = $object->fk_member;

                            $adherent = new Adherent($this->db);
                            $adherent->fetch($object->fk_member);
                            $sendto = $adherent->email;

                            $trackid = 'par' . $object->id;
                            $sendcontext = 'standard';

                            $cmail = new CMailFile($subject, $sendto, $from, $msg, array(), array(), array(), '', '', 0, 1, '', '', $trackid, '', $sendcontext);

                            $result = $cmail->sendfile();

                            if (!$result || !empty($cmail->error) || !empty($cmail->errors)) {
                                $erroremail .= ($erroremail ? ', ' : '') . $cmail->error;
                                $this->errors[] = $cmail->error;
                                if (is_array($cmail->errors) && count($cmail->errors) > 0) {
                                    $this->errors += $cmail->errors;
                                }
                            } else {
                                // Initialisation of datas of object to call trigger
                                if (is_object($object)) {
                                    $actiontypecode = 'AC_OTH_AUTO'; // Event insert into agenda automatically
                                    $attachedfiles = array();

                                    $object->actiontypecode = $actiontypecode; // Type of event ('AC_OTH', 'AC_OTH_AUTO', 'AC_XXX'...)
                                    $object->actionmsg = $arraydefaultmessage->topic . "\n" . $arraydefaultmessage->content; // Long text
                                    $object->actionmsg2 = $langs->transnoentities("PartnershipSentByEMail", $object->ref);
                                    ; // Short text ($langs->transnoentities('MailSentByTo')...);
                                    if (getDolGlobalString('MAIN_MAIL_REPLACE_EVENT_TITLE_BY_EMAIL_SUBJECT')) {
                                        $object->actionmsg2     = $subject; // Short text
                                    }

                                    $object->trackid = $trackid;

The property trackid does not exist on Dolibarr\Code\Partnerships\Classes\Partnership. Since you implemented __set, consider adding a @property annotation.

                                    $object->fk_element = $object->id;
                                    $object->elementtype = $object->element;

The property elementtype does not exist on Dolibarr\Code\Partnerships\Classes\Partnership. Since you implemented __set, consider adding a @property annotation.

                                    if (is_array($attachedfiles) && count($attachedfiles) > 0) {
                                        $object->attachedfiles = $attachedfiles;

The property attachedfiles does not exist on Dolibarr\Code\Partnerships\Classes\Partnership. Since you implemented __set, consider adding a @property annotation.

                                    }

                                    $object->email_from = $from;

The property email_from does not exist on Dolibarr\Code\Partnerships\Classes\Partnership. Since you implemented __set, consider adding a @property annotation.

                                    $object->email_subject = $subject;

The property email_subject does not exist on Dolibarr\Code\Partnerships\Classes\Partnership. Since you implemented __set, consider adding a @property annotation.

                                    $object->email_to = $sendto;

The property email_to does not exist on Dolibarr\Code\Partnerships\Classes\Partnership. Since you implemented __set, consider adding a @property annotation.

                                    $object->email_subject = $subject;

                                    $triggersendname = 'PARTNERSHIP_SENTBYMAIL';
                                    // Call of triggers (you should have set $triggersendname to execute trigger)
                                    if (!empty($triggersendname)) {
                                        $result = $object->call_trigger($triggersendname, $user);
                                        if ($result < 0) {
                                            $error++;
                                        }
                                    }
                                    // End call of triggers
                                }
                            }
                        }
                    }
                }
            }
        } else {
            $error++;
            $this->error = $this->db->lasterror();
        }

        if (!$error) {
            $this->db->commit();
            $this->output = $numofexpiredmembers . ' expired partnership members found' . "\n";
            if ($erroremail) {
                $this->output .= '. Got errors when sending some email : ' . $erroremail;
            }
        } else {
            $this->db->rollback();
            $this->output = "Rollback after error\n";
            $this->output .= $numofexpiredmembers . ' expired partnership members found' . "\n";
            if ($erroremail) {
                $this->output .= '. Got errors when sending some email : ' . $erroremail;
            }
        }

        return ($error ? 1 : 0);
    }