/**
* Execute /../stock/listItem
*
* @param type $request
*/
public function execute($request)
{
$head = sfYaml::load(sfConfig::get('sf_app_dir') . '/lib/list/item_list.yml');
$itemlist_headers = array($head['listItem']['header1'], $head['listItem']['header2'], $head['listItem']['header3'], $head['listItem']['header6']);
$columns = 'id,name,sales_unit_price,stock_available';
$recordsLimit = 5;
//have to take from lists
if (!$request->hasParameter('pageNo')) {
$pageNo = 1;
} else {
$pageNo = $request->getParameter('pageNo', 1);
}
$pager = new SimplePager('Item', $recordsLimit);
$pager->setPage($pageNo);
$pager->setNumResults($this->getItemService()->countItems());
$pager->init();
$offset = $pager->getOffset();
$offset = empty($offset) ? 0 : $offset;
$paramHolder = new sfParameterHolder();
$paramHolder->set('columns', $columns);
$paramHolder->set('offset', $offset);
$paramHolder->set('limit', $recordsLimit);
$itemlist_data = $this->getItemService()->getItems($paramHolder);
$listContainer = new ListContainer();
$listContainer->setListName('ItemList');
$listContainer->setListHeaders($itemlist_headers);
$listContainer->setListContent($itemlist_data);
$listContainer->setRowLink("stock/showItem?id=");
$listContainer->setPager($pager);
$this->listcontainer = $listContainer;
}
/**
* Execute /../default/newdSales
*
* @param type $request
*/
public function execute($request)
{
if (!$request->hasParameter('id')) {
$this->salesorder = $this->getRoute()->getObject();
} else {
$this->salesorder = $this->getSalesService()->getSalesById($request->getParameter('id'));
$this->forward404Unless($this->salesorder);
}
}
/**
* Execute /../default/newdClient
*
* @param type $request
*/
public function execute($request)
{
if (!$request->hasParameter('id')) {
$this->client = $this->getRoute()->getObject();
} else {
$this->client = $this->getClientService()->getClientById($request->getParameter('id'));
$this->forward404Unless($this->client);
}
}
/**
* Execute /../default/newdItem
*
* @param type $request
*/
public function execute($request)
{
if (!$request->hasParameter('id')) {
$this->item = $this->getRoute()->getObject();
} else {
$this->item = $this->getItemService()->getItemById($request->getParameter('id'));
$this->forward404Unless($this->item);
}
}
/**
* Tries to restore previously highlighted menu
*
* @param type $request
*/
protected function highlightPreviousMenu($request)
{
$initialActionName = $request->getParameter('initialActionName', '');
$initialModuleName = $request->getParameter('initialModuleName', '');
if (empty($initialActionName) || empty($initialModuleName)) {
$actionStack = $this->getController()->getActionStack();
$size = $actionStack->getSize();
$actionEntry = $this->getController()->getActionStack()->getEntry($size - 2);
if ($actionEntry instanceof sfActionStackEntry) {
if (empty($initialActionName)) {
$initialActionName = $actionEntry->getActionName();
}
if (empty($initialModuleName)) {
$initialModuleName = $actionEntry->getModuleName();
}
$request->setParameter('initialActionName', $initialActionName);
$request->setParameter('initialModuleName', $initialModuleName);
}
}
}
/**
*
* @param type $request
*/
public function execute($request)
{
sfConfig::set('sf_web_debug', false);
sfConfig::set('sf_debug', false);
$year = $request->getParameter("year");
$holidayList = $this->getHolidayList();
$dates = "";
foreach ($holidayList as $holiday) {
$htype = $holiday->getLength() == 0 ? 'f' : 'h';
$dates .= "[" . str_replace("-", ",", $holiday->getdate()) . ", '" . $htype . "', " . $holiday->getRecurring() . "],";
}
$dates = rtrim($dates, ",");
$response = $this->getResponse();
$response->setHttpHeader('Expires', '0');
$response->setHttpHeader("Cache-Control", "must-revalidate, post-check=0, pre-check=0");
$response->setHttpHeader("Cache-Control", "private", false);
echo "[";
echo $dates;
echo "]";
return sfView::NONE;
}
/**
* Returns a parameter from the injected container
*
* @param string $name
*
* @return mixed
*/
public function getParameter($name)
{
return $this->_container->getParameter($name);
}
/**
* getApiSecret
* @return String api secret
*/
public function getApiSecret()
{
return $this->container->getParameter('api_secret');
}
/**
* Handle the different actions, should probably be handles at base class level ...
*
* @param type $match
* @param type $btx
*/
public function executeCancellation($match, $btx)
{
$config = $this->_plugin_config;
$contribution_id = $match->getParameter('contribution_id');
$mandate_id = $match->getParameter('mandate_id');
$status_cancelled = banking_helper_optionvalue_by_groupname_and_name('contribution_status', 'Cancelled');
// set the status to 'Cancelled'
$query = array('version' => 3, 'id' => $contribution_id);
$query['contribution_status_id'] = $status_cancelled;
$query['cancel_date'] = date('Ymdhis', strtotime($btx->value_date));
$query = array_merge($query, $this->getPropagationSet($btx, $match, 'contribution', $config->cancellation_value_propagation));
// add propagated values
if (empty($query['cancel_reason'])) {
// add default values
$query['cancel_reason'] = $config->cancellation_default_reason;
}
if ($config->cancellation_cancel_reason) {
$query['cancel_reason'] = $match->getParameter('cancel_reason');
}
$result = civicrm_api('Contribution', 'create', $query);
if (isset($result['is_error']) && $result['is_error']) {
error_log("org.project60.sepa: matcher_sepa: Couldn't modify contribution, error was: " . $result['error_message']);
CRM_Core_Session::setStatus(ts("Couldn't modify contribution."), ts('Error'), 'error');
} else {
// now for the mandate...
$contribution = civicrm_api('Contribution', 'getsingle', array('version' => 3, 'id' => $contribution_id));
if (!empty($contribution['is_error'])) {
error_log("org.project60.sepa: matcher_sepa: Couldn't load contribution, error was: " . $result['error_message']);
CRM_Core_Session::setStatus(ts("Couldn't modify contribution."), ts('Error'), 'error');
} else {
if ('OOFF' == $contribution['contribution_payment_instrument'] && !empty($config->cancellation_update_mandate_status_OOFF)) {
// everything seems fine, adjust the mandate's status
$query = array('version' => 3, 'id' => $mandate_id);
$query['status'] = $config->cancellation_update_mandate_status_OOFF;
$query = array_merge($query, $this->getPropagationSet($btx, $match, 'mandate'));
// add propagated values
$result = civicrm_api('SepaMandate', 'create', $query);
if (!empty($result['is_error'])) {
error_log("org.project60.sepa: matcher_sepa: Couldn't modify mandate, error was: " . $result['error_message']);
CRM_Core_Session::setStatus(ts("Couldn't modify mandate."), ts('Error'), 'error');
}
} elseif ('RCUR' == $contribution['contribution_payment_instrument'] && !empty($config->cancellation_update_mandate_status_RCUR)) {
// everything seems fine, adjust the mandate's status
$query = array('version' => 3, 'id' => $mandate_id);
$query['status'] = $config->cancellation_update_mandate_status_RCUR;
$query = array_merge($query, $this->getPropagationSet($btx, $match, 'mandate'));
// add propagated values
$result = civicrm_api('SepaMandate', 'create', $query);
if (!empty($result['is_error'])) {
error_log("org.project60.sepa: matcher_sepa: Couldn't modify mandate, error was: " . $result['error_message']);
CRM_Core_Session::setStatus(ts("Couldn't modify mandate."), ts('Error'), 'error');
}
}
}
}
// create activity if wanted
if ($config->cancellation_create_activity) {
// gather some information to put in the text
$smarty_vars = array();
$smarty_vars['contribution'] = $contribution;
$smarty_vars['cancel_fee'] = $match->getParameter('cancel_fee');
$smarty_vars['cancel_reason'] = $match->getParameter('cancel_reason');
// load the mandate
$mandate = civicrm_api('SepaMandate', 'getsingle', array('id' => $mandate_id, 'version' => 3));
$smarty_vars['mandate'] = $mandate;
// load the contact
$contact = civicrm_api('Contact', 'getsingle', array('id' => $contribution['contact_id'], 'version' => 3));
$smarty_vars['contact'] = $contact;
// count the cancelled contributions connected to this mandate
$cancelled_contribution_count = 0;
$current_contribution_date = date('Ymdhis', strtotime($contribution['receive_date']));
if ($mandate['type'] == 'RCUR') {
$query = "SELECT contribution_status_id\n FROM civicrm_contribution\n WHERE contribution_recur_id = {$mandate['entity_id']}\n AND receive_date <= '{$current_contribution_date}'\n ORDER BY receive_date DESC;";
$status_list = CRM_Core_DAO::executeQuery($query);
while ($status_list->fetch()) {
if ($status_list->contribution_status_id == $status_cancelled) {
$cancelled_contribution_count += 1;
} else {
break;
}
}
}
$smarty_vars['cancelled_contribution_count'] = $cancelled_contribution_count;
// look up contact if not set
$user_id = CRM_Core_Session::singleton()->get('userID');
if (empty($config->cancellation_create_activity_assignee_id)) {
$assignedTo = $user_id;
} else {
$assignedTo = (int) $config->cancellation_create_activity_assignee_id;
}
// compile the text
$smarty = CRM_Banking_Helpers_Smarty::singleton();
$smarty->pushScope($smarty_vars);
if (empty($config->cancellation_create_activity_text)) {
$details = $smarty->fetch('CRM/Banking/PluginImpl/Matcher/SepaMandate.activity.tpl');
} else {
$details = $smarty->fetch("string:" . $config->cancellation_create_activity_text);
}
$smarty->popScope();
$activity_parameters = array('version' => 3, 'activity_type_id' => $config->cancellation_create_activity_type_id, 'subject' => $config->cancellation_create_activity_subject, 'status_id' => 1, 'activity_date_time' => date('YmdHis'), 'source_contact_id' => $user_id, 'target_contact_id' => $contact['id'], 'details' => $details);
$activity = CRM_Activity_BAO_Activity::create($activity_parameters);
$assignment_parameters = array('activity_id' => $activity->id, 'contact_id' => $assignedTo, 'record_type_id' => 1);
$assignment = CRM_Activity_BAO_ActivityContact::create($assignment_parameters);
}
$newStatus = banking_helper_optionvalueid_by_groupname_and_name('civicrm_banking.bank_tx_status', 'Processed');
$btx->setStatus($newStatus);
parent::execute($match, $btx);
return true;
}
