public function indexAction($id) { $res_month = $this->database->query("\n \n select max(brightery_invoices.due_date) AS due_date ,brightery_invoices.`status` AS status,brightery_products_subscriptions.period AS period,DATE_ADD(MAX(brightery_invoices.due_date), INTERVAL brightery_products_subscriptions.period MONTH) AS date_add,(DATEDIFF( DATE_ADD(MAX(brightery_invoices.due_date), INTERVAL brightery_products_subscriptions.period MONTH), NOW())) AS date_substract,\n `brightery_licenses`.`brightery_license_id`\n from brightery_invoices join `brightery_licenses` \n ON `brightery_licenses`.`brightery_license_id`=`brightery_invoices`.`brightery_license_id`\n join brightery_products_subscriptions \n ON brightery_licenses.brightery_products_subscription_id=brightery_products_subscriptions.brightery_products_subscription_id\n WHERE`brightery_licenses`.`brightery_products_subscription_id` NOT IN ('null')\n AND `brightery_products_subscriptions`.`period_cycle` ='Month'\n AND brightery_invoices.`status` != 'canceled'\n GROUP BY brightery_invoices.brightery_license_id \n HAVING (DATEDIFF( DATE_ADD(MAX(brightery_invoices.due_date), INTERVAL brightery_products_subscriptions.period MONTH), NOW())) <=4\n \n ")->result(); $res_year = $this->database->query("\n select max(brightery_invoices.due_date) AS due_date ,brightery_invoices.`status` AS status,brightery_products_subscriptions.period AS period,DATE_ADD(MAX(brightery_invoices.due_date), INTERVAL brightery_products_subscriptions.period year) AS date_add,(DATEDIFF( NOW() ,DATE_ADD(MAX(brightery_invoices.due_date), INTERVAL brightery_products_subscriptions.period year))) AS date_substract,\n `brightery_licenses`.`brightery_license_id`\n from brightery_invoices join `brightery_licenses` \n ON `brightery_licenses`.`brightery_license_id`=`brightery_invoices`.`brightery_license_id`\n join brightery_products_subscriptions \n ON brightery_licenses.brightery_products_subscription_id=brightery_products_subscriptions.brightery_products_subscription_id\n WHERE`brightery_licenses`.`brightery_products_subscription_id` NOT IN ('null')\n AND `brightery_products_subscriptions`.`period_cycle` ='Year'\n AND brightery_invoices.`status` != 'canceled'\n GROUP BY brightery_invoices.brightery_license_id \n HAVING (DATEDIFF( DATE_ADD(MAX(brightery_invoices.due_date), INTERVAL brightery_products_subscriptions.period YEAR), NOW())) <=30\n \n ")->result(); print_r($res_year); $model = new \modules\brightery\models\brightery_invoices(FALSE); foreach ($res_month as $val) { // echo $val->due_date . '<br>'; echo $val->status . '<br>'; echo $val->period . '<br>'; echo $val->date_substract . '<br>'; echo $val->brightery_license_id . '<br>'; $model->attributes = ['brightery_license_id' => $val->brightery_license_id, 'due_date' => $val->date_add, 'status' => 'due']; if ($model->save(true)) { echo 'yes'; } } foreach ($res_year as $val) { echo 'ojiji'; // echo $val->due_date . '<br>'; echo $val->status . '<br>'; echo $val->period . '<br>'; echo $val->date_substract . '<br>'; echo $val->brightery_license_id . '<br>'; $model->attributes = ['brightery_license_id' => $val->brightery_license_id, 'due_date' => $val->date_add, 'status' => 'due']; if ($model->save(true)) { echo 'yes'; } } // $to = '*****@*****.**'; // $subject = 'Sample Subject'; // $message = 'Hi. This is a sample message.'; // $headers = 'From: webmaster@royyuuki.elementfx.com' . "\r\n" . // 'Reply-To: no-reply@royyuuki.elementfx.com' . "\r\n" . // 'X-Mailer: PHP/' . phpversion(); // // echo (mail($to, $subject, $message, $headers)) ? 'Message sent!' : 'Message not sent!'; }
public function manageAction($id = false) { $this->permission('manage'); $this->language->load("license"); if ($id) { $model = new Brightery_licenses('edit'); } else { $model = new Brightery_licenses('add'); } $product = Form_helper::queryToDropdown('brightery_products', 'brightery_product_id', 'title'); $user = Form_helper::queryToDropdown('users', 'user_id', 'fullname'); $payment_type; if ($this->input->post('payment_type') == 'fixed') { $payment_type = 'fixed'; $brightery_products_subscription_id = null; } else { $payment_type = 'subscription'; $brightery_products_subscription_id = $this->input->post('subscription_status'); } if ($_POST) { $model->attributes = ['license_code' => $this->input->post('license_code'), 'brightery_product_id' => $this->input->post('brightery_product_id'), 'domain' => $this->input->post('domain'), 'user_id' => $this->input->post('user_id'), 'payment_type' => $payment_type]; if ($brightery_products_subscription_id) { $model->attributes['brightery_products_subscription_id'] = $brightery_products_subscription_id; } } if ($id) { $model->brightery_license_id = $id; } if ($r = $model->save()) { if ($id) { echo $id; Uri_helper::redirect("management/brightery_licenses"); } else { $model11 = new \modules\brightery\models\brightery_invoices(FALSE); $model11->attributes = ['brightery_license_id' => $r, 'due_date' => date('Y-m-d'), 'status' => 'due']; if ($model11->save()) { Uri_helper::redirect("management/brightery_licenses"); } } } return $this->render('license/manage', ['item' => $model->get(), 'product' => $product, 'user' => $user]); }