public function executePhase()
{
if ($this->currentPhase === DealConversionPhase::INVOICE_CREATION || $this->currentPhase === DealConversionPhase::QUOTE_CREATION) {
if ($this->currentPhase === DealConversionPhase::INVOICE_CREATION) {
$entityTypeID = \CCrmOwnerType::Invoice;
} else {
$entityTypeID = \CCrmOwnerType::Quote;
}
$entityTypeName = \CCrmOwnerType::ResolveName($entityTypeID);
$config = $this->config->getItem($entityTypeID);
if (!$config->isActive()) {
return false;
}
/** @var \CCrmPerms $permissions */
$permissions = $this->getUserPermissions();
$entityID = isset($this->contextData[$entityTypeName]) ? $this->contextData[$entityTypeName] : 0;
if ($entityID > 0) {
if ($entityTypeID === \CCrmOwnerType::Invoice) {
if (!\CCrmInvoice::Exists($entityID)) {
throw new EntityConversionException(\CCrmOwnerType::Deal, \CCrmOwnerType::Invoice, EntityConversionException::TARG_DST, EntityConversionException::NOT_FOUND);
}
if (!\CCrmInvoice::CheckUpdatePermission($entityID, $permissions)) {
throw new EntityConversionException(\CCrmOwnerType::Deal, \CCrmOwnerType::Invoice, EntityConversionException::TARG_DST, EntityConversionException::UPDATE_DENIED);
}
$entity = new \CCrmInvoice(false);
$fields = array('UF_DEAL_ID' => $this->entityID);
try {
$entity->Update($entityID, $fields);
} catch (Main\DB\SqlQueryException $e) {
}
$this->resultData[$entityTypeName] = $entityID;
} else {
if (!\CCrmQuote::Exists($entityID)) {
throw new EntityConversionException(\CCrmOwnerType::Deal, \CCrmOwnerType::Quote, EntityConversionException::TARG_DST, EntityConversionException::NOT_FOUND);
}
if (!\CCrmQuote::CheckUpdatePermission($entityID, $permissions)) {
throw new EntityConversionException(\CCrmOwnerType::Deal, \CCrmOwnerType::Quote, EntityConversionException::TARG_DST, EntityConversionException::UPDATE_DENIED);
}
$entity = new \CCrmQuote(false);
$fields = array('DEAL_ID' => $this->entityID);
$entity->Update($entityID, $fields);
$this->resultData[$entityTypeName] = $entityID;
}
return true;
}
if (!\CCrmAuthorizationHelper::CheckCreatePermission($entityTypeName, $permissions)) {
throw new EntityConversionException(\CCrmOwnerType::Deal, $entityTypeID, EntityConversionException::TARG_DST, EntityConversionException::CREATE_DENIED);
}
if (UserFieldSynchronizer::needForSynchronization(\CCrmOwnerType::Deal, $entityTypeID)) {
throw new EntityConversionException(\CCrmOwnerType::Deal, $entityTypeID, EntityConversionException::TARG_DST, EntityConversionException::NOT_SYNCHRONIZED);
}
if (!ConversionSettings::getCurrent()->isAutocreationEnabled()) {
throw new EntityConversionException(\CCrmOwnerType::Deal, $entityTypeID, EntityConversionException::TARG_DST, EntityConversionException::AUTOCREATION_DISABLED);
}
/** @var DealConversionMapper $mapper */
$mapper = $this->getMapper();
$map = self::prepareMap($entityTypeID);
$fields = $mapper->map($map);
if (empty($fields)) {
throw new EntityConversionException(\CCrmOwnerType::Deal, $entityTypeID, EntityConversionException::TARG_DST, EntityConversionException::EMPTY_FIELDS);
}
if ($entityTypeID === \CCrmOwnerType::Invoice) {
$entity = new \CCrmInvoice(false);
if (!$entity->CheckFields($fields)) {
throw new EntityConversionException(\CCrmOwnerType::Deal, \CCrmOwnerType::Invoice, EntityConversionException::TARG_DST, EntityConversionException::INVALID_FIELDS, $entity->LAST_ERROR);
}
$entityID = $entity->Add($fields);
if ($entityID <= 0) {
throw new EntityConversionException(\CCrmOwnerType::Deal, \CCrmOwnerType::Invoice, EntityConversionException::TARG_DST, EntityConversionException::CREATE_FAILED, $entity->LAST_ERROR);
}
$this->resultData[\CCrmOwnerType::InvoiceName] = $entityID;
} else {
$entity = new \CCrmQuote(false);
if (!$entity->CheckFields($fields)) {
throw new EntityConversionException(\CCrmOwnerType::Deal, \CCrmOwnerType::Quote, EntityConversionException::TARG_DST, EntityConversionException::INVALID_FIELDS, $entity->LAST_ERROR);
}
$productRows = isset($fields['PRODUCT_ROWS']) && is_array($fields['PRODUCT_ROWS']) ? $fields['PRODUCT_ROWS'] : array();
if (!empty($productRows)) {
$currencyID = isset($fields['CURRENCY_ID']) ? $fields['CURRENCY_ID'] : '';
$personTypes = \CCrmPaySystem::getPersonTypeIDs();
$personTypeID = 0;
if (isset($personTypes['COMPANY']) && isset($personTypes['CONTACT'])) {
if (isset($fields['COMPANY_ID']) && $fields['COMPANY_ID'] > 0) {
$personTypeID = $personTypes['COMPANY'];
} elseif (isset($fields['CONTACT_ID']) && $fields['CONTACT_ID'] > 0) {
$personTypeID = $personTypes['CONTACT'];
}
}
if ($currencyID !== '' && $personTypeID > 0) {
$calculationOptions = array();
if (\CCrmTax::isTaxMode() && isset($fields['LOCATION_ID'])) {
$calculationOptions['LOCATION_ID'] = $fields['LOCATION_ID'];
}
$result = \CCrmSaleHelper::Calculate($productRows, $currencyID, $personTypeID, false, SITE_ID, $calculationOptions);
$arFields['OPPORTUNITY'] = isset($result['PRICE']) ? round(doubleval($result['PRICE']), 2) : 1.0;
$arFields['TAX_VALUE'] = isset($result['TAX_VALUE']) ? round(doubleval($result['TAX_VALUE']), 2) : 0.0;
}
}
$entityID = $entity->Add($fields);
if ($entityID <= 0) {
throw new EntityConversionException(\CCrmOwnerType::Deal, \CCrmOwnerType::Quote, EntityConversionException::TARG_DST, EntityConversionException::CREATE_FAILED, $entity->LAST_ERROR);
}
$this->resultData[\CCrmOwnerType::QuoteName] = $entityID;
}
return true;
} elseif ($this->currentPhase === DealConversionPhase::FINALIZATION) {
return true;
}
return false;
}
}
CCrmDeal::SaveProductRows($dealID, array(array('PRODUCT_ID' => intval($arProduct['ID']), 'PRICE' => doubleval($arProduct['PRICE']), 'QUANTITY' => 1)));
}
}
}
// Add event
require_once "event.demo.php";
$CCrmEvent = new CCrmEvent();
foreach ($arEvents as $ID => $arParams) {
$arEvents[$ID]['ID'] = $CCrmEvent->Add($arParams);
}
// Add relation
$arParams = array('COMPANY_ID' => $arCompany['39']['ID'], 'CONTACT_ID' => $arContacts['51']['ID']);
$CCrmLead->Update($arLeads['57']['ID'], $arParams);
// Add activity
require_once "activity.demo.php";
$CCrmActivity = new CCrmActivity();
foreach ($arActivities as $ID => $arParams) {
$activityId = $CCrmActivity->Add($arParams["FIELDS"], false, false);
CCrmActivity::SaveCommunications($activityId, array($arParams["COMMUNICATIONS"]), $arParams["FIELDS"], false, false);
}
//Add invoice
CCrmInvoice::installDisableSaleEvents();
require_once "invoice.demo.php";
$CCrmInvoice = new CCrmInvoice();
$b_false = false;
foreach ($arInvoices as $arInvoice) {
$CCrmInvoice->Add($arInvoice, $b_false, WIZARD_SITE_ID);
}
}
COption::SetOptionString("crm", "form_features", "N");
public function createInvoices(array $params)
{
$count = isset($params['COUNT']) ? (int) $params['COUNT'] : 0;
if ($count <= 0) {
return;
}
$sum = isset($params['SUM']) ? (int) $params['SUM'] : 0;
if ($sum <= 0) {
return;
}
$dealID = isset($params['DEAL_ID']) ? (int) $params['DEAL_ID'] : 0;
$companyID = isset($params['COMPANY_ID']) ? (int) $params['COMPANY_ID'] : 0;
$contactID = isset($params['CONTACT_ID']) ? (int) $params['CONTACT_ID'] : 0;
$userIDs = isset($params['USER_IDS']) && is_array($params['USER_IDS']) ? $params['USER_IDS'] : array();
if (empty($userIDs)) {
$userIDs[] = \CCrmSecurityHelper::GetCurrentUserID();
}
$prefix = isset($params['PREFIX']) ? $params['PREFIX'] : '';
if ($prefix === '') {
$prefix = $this->id;
}
$date = isset($params['DATE']) ? $params['DATE'] : null;
if (!$date) {
$date = $date = new Date();
}
$maxDateOffset = isset($params['MAX_DATE_OFFSET']) ? (int) $params['MAX_DATE_OFFSET'] : 0;
$dateFormat = Date::convertFormatToPhp(FORMAT_DATE);
$dateTimeFormat = Date::convertFormatToPhp(FORMAT_DATETIME);
$isWon = isset($params['IS_WON']) ? $params['IS_WON'] : false;
if ($isWon) {
$totalSum = $sum;
} else {
$totalSum = $sum - mt_rand((int) ($sum / 3), $sum);
}
$entity = new \CCrmInvoice(false);
$invoiceSum = (int) $totalSum / $count;
$totalInvoiceSum = 0;
for ($i = 1; $i <= $count; $i++) {
if ($i == $count) {
$invoiceSum = $totalSum - $totalInvoiceSum;
}
$totalInvoiceSum += $invoiceSum;
$time = DateTime::createFromTimestamp($date->getTimestamp());
if ($maxDateOffset > 0) {
$time->add(mt_rand(0, $maxDateOffset) . ' days');
}
$time->setTime(mt_rand(8, 20), mt_rand(0, 59), 0);
$siteTime = $time->format($dateTimeFormat);
$siteDate = $time->format($dateFormat);
\CCrmOwnerType::GetCaption(\CCrmOwnerType::Company, $companyID, false);
$companyInfo = self::getCompanyInfo($companyID);
$contactInfo = self::getContactInfo($contactID);
$fields = array('ORDER_TOPIC' => "{$prefix} invoice # {$i}", 'STATUS_ID' => $isWon ? 'P' : 'N', 'DATE_INSERT' => $siteTime, 'DATE_BILL' => $siteDate, 'RESPONSIBLE_ID' => self::getRandomItem($userIDs), 'UF_DEAL_ID' => $dealID, 'UF_COMPANY_ID' => $companyID, 'UF_CONTACT_ID' => $contactID, 'PERSON_TYPE_ID' => 1, 'PAY_SYSTEM_ID' => 1, 'INVOICE_PROPERTIES' => array(10 => $companyInfo['TITLE'], 11 => $companyInfo['FULL_ADDRESS'], 12 => $contactInfo['FULL_NAME'], 13 => $contactInfo['EMAIL'], 14 => $contactInfo['PHONE']), 'PRODUCT_ROWS' => array(array('ID' => 0, 'PRODUCT_NAME' => "{$prefix} product", 'QUANTITY' => 1, 'PRICE' => $invoiceSum, 'PRODUCT_ID' => 0, 'CUSTOMIZED' => 'Y')));
$ID = $entity->Add($fields);
}
}
public function executePhase()
{
if ($this->currentPhase === QuoteConversionPhase::DEAL_CREATION || $this->currentPhase === QuoteConversionPhase::INVOICE_CREATION) {
if ($this->currentPhase === QuoteConversionPhase::DEAL_CREATION) {
$entityTypeID = \CCrmOwnerType::Deal;
} else {
$entityTypeID = \CCrmOwnerType::Invoice;
}
$entityTypeName = \CCrmOwnerType::ResolveName($entityTypeID);
$config = $this->config->getItem($entityTypeID);
if (!$config->isActive()) {
return false;
}
/** @var \CCrmPerms $permissions */
$permissions = $this->getUserPermissions();
$entityID = isset($this->contextData[$entityTypeName]) ? $this->contextData[$entityTypeName] : 0;
if ($entityID > 0) {
if ($entityTypeID === \CCrmOwnerType::Deal) {
if (!\CCrmDeal::Exists($entityID)) {
throw new EntityConversionException(\CCrmOwnerType::Quote, \CCrmOwnerType::Deal, EntityConversionException::TARG_DST, EntityConversionException::NOT_FOUND);
}
$this->resultData[$entityTypeName] = $entityID;
} else {
if (!\CCrmInvoice::Exists($entityID)) {
throw new EntityConversionException(\CCrmOwnerType::Quote, \CCrmOwnerType::Invoice, EntityConversionException::TARG_DST, EntityConversionException::NOT_FOUND);
}
if (!\CCrmInvoice::CheckUpdatePermission($entityID, $permissions)) {
throw new EntityConversionException(\CCrmOwnerType::Quote, \CCrmOwnerType::Invoice, EntityConversionException::TARG_DST, EntityConversionException::UPDATE_DENIED);
}
$entity = new \CCrmInvoice(false);
$fields = array('UF_QUOTE_ID' => $this->entityID);
try {
$entity->Update($entityID, $fields);
} catch (Main\DB\SqlQueryException $e) {
}
$this->resultData[$entityTypeName] = $entityID;
}
return true;
}
if (!\CCrmAuthorizationHelper::CheckCreatePermission($entityTypeName, $permissions)) {
throw new EntityConversionException(\CCrmOwnerType::Quote, $entityTypeID, EntityConversionException::TARG_DST, EntityConversionException::CREATE_DENIED);
}
if (UserFieldSynchronizer::needForSynchronization(\CCrmOwnerType::Quote, $entityTypeID)) {
throw new EntityConversionException(\CCrmOwnerType::Quote, $entityTypeID, EntityConversionException::TARG_DST, EntityConversionException::NOT_SYNCHRONIZED);
}
if (!ConversionSettings::getCurrent()->isAutocreationEnabled()) {
throw new EntityConversionException(\CCrmOwnerType::Quote, $entityTypeID, EntityConversionException::TARG_DST, EntityConversionException::AUTOCREATION_DISABLED);
}
if ($entityTypeID === \CCrmOwnerType::Deal && \CCrmBizProcHelper::HasAutoWorkflows($entityTypeID, \CCrmBizProcEventType::Create)) {
throw new EntityConversionException(\CCrmOwnerType::Lead, $entityTypeID, EntityConversionException::TARG_DST, EntityConversionException::HAS_WORKFLOWS);
}
/** @var QuoteConversionMapper $mapper */
$mapper = $this->getMapper();
$map = self::prepareMap($entityTypeID);
$fields = $mapper->map($map);
if (empty($fields)) {
throw new EntityConversionException(\CCrmOwnerType::Quote, $entityTypeID, EntityConversionException::TARG_DST, EntityConversionException::EMPTY_FIELDS);
}
if ($entityTypeID === \CCrmOwnerType::Deal) {
$entity = new \CCrmDeal(false);
if (!$entity->CheckFields($fields)) {
throw new EntityConversionException(\CCrmOwnerType::Quote, \CCrmOwnerType::Deal, EntityConversionException::TARG_DST, EntityConversionException::INVALID_FIELDS, $entity->LAST_ERROR);
}
$productRows = isset($fields['PRODUCT_ROWS']) && is_array($fields['PRODUCT_ROWS']) ? $fields['PRODUCT_ROWS'] : array();
if (!empty($productRows)) {
$result = \CCrmProductRow::CalculateTotalInfo('D', 0, false, $fields, $productRows);
$fields['OPPORTUNITY'] = isset($result['OPPORTUNITY']) ? $result['OPPORTUNITY'] : 1.0;
$fields['TAX_VALUE'] = isset($result['TAX_VALUE']) ? $result['TAX_VALUE'] : 0.0;
}
$entityID = $entity->Add($fields);
if ($entityID <= 0) {
throw new EntityConversionException(\CCrmOwnerType::Quote, \CCrmOwnerType::Deal, EntityConversionException::TARG_DST, EntityConversionException::CREATE_FAILED, $entity->LAST_ERROR);
}
if (!empty($productRows)) {
\CCrmDeal::SaveProductRows($entityID, $productRows, false, false, false);
}
$this->resultData[\CCrmOwnerType::DealName] = $entityID;
} else {
$entity = new \CCrmInvoice(false);
if (!$entity->CheckFields($fields)) {
throw new EntityConversionException(\CCrmOwnerType::Quote, \CCrmOwnerType::Invoice, EntityConversionException::TARG_DST, EntityConversionException::INVALID_FIELDS, $entity->LAST_ERROR);
}
$entityID = $entity->Add($fields);
if ($entityID <= 0) {
throw new EntityConversionException(\CCrmOwnerType::Quote, \CCrmOwnerType::Invoice, EntityConversionException::TARG_DST, EntityConversionException::CREATE_FAILED, $entity->LAST_ERROR);
}
$this->resultData[\CCrmOwnerType::InvoiceName] = $entityID;
}
return true;
} elseif ($this->currentPhase === DealConversionPhase::FINALIZATION) {
$fields = array();
if (isset($this->resultData[\CCrmOwnerType::DealName])) {
$fields['DEAL_ID'] = $this->resultData[\CCrmOwnerType::DealName];
}
if (!empty($fields)) {
$entity = new \CCrmQuote(false);
$entity->Update($this->entityID, $fields);
}
return true;
}
return false;
}
$entity = new CCrmInvoice(false);
if (!$entity->CheckFields($arFields, !$isNew ? $ID : false, $isSuccessfull, $isFailed)) {
if ($entity->LAST_ERROR !== '') {
$errorText = preg_replace('/<br\\s*\\/>/', "\n", $entity->LAST_ERROR);
__CrmMobileInvoiceEditEndResonse(array('ERROR' => $errorText));
} else {
__CrmMobileInvoiceEditEndResonse(array('ERROR' => GetMessage('CRM_INVOICE_FIELD_CHECK_GENERAL_ERROR')));
}
}
//$DB->StartTransaction();
$successed = false;
if (!$isNew) {
$successed = $entity->Update($ID, $arFields, array('UPDATE_SEARCH' => true));
} else {
$recalculate = false;
$ID = $entity->Add($arFields, $recalculate, SITE_ID, array('UPDATE_SEARCH' => true));
$successed = is_int($ID) && $ID > 0;
}
if ($successed) {
//$DB->Commit();
$dbRes = CCrmInvoice::GetList(array(), array('ID' => $ID, 'CHECK_PERMISSIONS' => 'N'));
$currentItem = $dbRes->GetNext();
$formatParams = isset($_REQUEST['FORMAT_PARAMS']) ? $_REQUEST['FORMAT_PARAMS'] : array();
CCrmMobileHelper::PrepareInvoiceItem($currentItem, $formatParams, array('PAY_SYSTEMS' => $paySystems), array('ENABLE_MULTI_FIELDS' => true, 'ENABLE_PAYER_INFO' => true, 'ENABLE_LOCATION' => true));
__CrmMobileInvoiceEditEndResonse(array('SAVED_ENTITY_ID' => $ID, 'SAVED_ENTITY_DATA' => CCrmMobileHelper::PrepareInvoiceData($currentItem)));
} else {
//$DB->Rollback();
$errorText = '';
$exception = $APPLICATION->GetException();
if ($exception) {
$code = $exception->GetID();
top.<?php
echo CUtil::JSEscape($arResult['FORM_ID'] . '_ajax_response');
?>
= response;
</script>
<?php
exit;
}
if (empty($arResult['ERROR_MESSAGE'])) {
$DB->StartTransaction();
$bSuccess = false;
if ($bEdit) {
$bSuccess = $CCrmInvoice->Update($arResult['ELEMENT']['ID'], $arFields, array('REGISTER_SONET_EVENT' => true, 'UPDATE_SEARCH' => true));
} else {
$recalculate = false;
$ID = $CCrmInvoice->Add($arFields, $recalculate, SITE_ID, array('REGISTER_SONET_EVENT' => true, 'UPDATE_SEARCH' => true));
$bSuccess = intval($ID) > 0 ? true : false;
if ($bSuccess) {
$arResult['ELEMENT']['ID'] = $ID;
}
}
if ($bSuccess) {
// Save settings
if (is_array($productRowSettings) && count($productRowSettings) > 0) {
$arSettings = CCrmProductRow::LoadSettings('I', $arResult['ELEMENT']['ID']);
foreach ($productRowSettings as $k => $v) {
$arSettings[$k] = $v;
}
CCrmProductRow::SaveSettings('I', $arResult['ELEMENT']['ID'], $arSettings);
}
unset($arSettings);
public static function add($params)
{
global $DB;
$invoice = new CCrmInvoice();
if (!CCrmInvoice::CheckCreatePermission()) {
throw new RestException('Access denied.');
}
$fields = CCrmInvoiceRestUtil::getParamArray($params, 'fields');
$fields = self::filterFields($fields, 'add');
if (!is_array($fields) || count($fields) === 0) {
throw new RestException('Invalid parameters.');
}
// sanitize
$comments = isset($fields['COMMENTS']) ? trim($fields['COMMENTS']) : '';
$userDescription = isset($fields['USER_DESCRIPTION']) ? trim($fields['USER_DESCRIPTION']) : '';
$bSanitizeComments = $comments !== '' && strpos($comments, '<');
$bSanitizeUserDescription = $userDescription !== '' && strpos($userDescription, '<');
if ($bSanitizeComments || $bSanitizeUserDescription) {
$sanitizer = new CBXSanitizer();
$sanitizer->ApplyDoubleEncode(false);
$sanitizer->SetLevel(CBXSanitizer::SECURE_LEVEL_MIDDLE);
//Crutch for for Chrome line break behaviour in HTML editor.
$sanitizer->AddTags(array('div' => array()));
if ($bSanitizeComments) {
$fields['COMMENTS'] = $sanitizer->SanitizeHtml($fields['COMMENTS']);
}
if ($bSanitizeUserDescription) {
$fields['USER_DESCRIPTION'] = $sanitizer->SanitizeHtml($fields['USER_DESCRIPTION']);
}
unset($sanitizer);
}
unset($bSanitizeComments, $bSanitizeUserDescription);
$fields['COMMENTS'] = $comments;
$fields['USER_DESCRIPTION'] = $userDescription;
unset($comments, $userDescription);
$bStatusSuccess = CCrmStatusInvoice::isStatusSuccess($fields['STATUS_ID']);
if ($bStatusSuccess) {
$bStatusFailed = false;
} else {
$bStatusFailed = CCrmStatusInvoice::isStatusFailed($fields['STATUS_ID']);
}
if (!$invoice->CheckFields($fields, false, $bStatusSuccess, $bStatusFailed)) {
if (!empty($invoice->LAST_ERROR)) {
throw new RestException($invoice->LAST_ERROR);
} else {
throw new RestException('Error on check fields.');
}
}
$propsInfo = CCrmInvoice::GetPropertiesInfo($fields['PERSON_TYPE_ID']);
$propsInfo = is_array($propsInfo[$fields['PERSON_TYPE_ID']]) ? $propsInfo[$fields['PERSON_TYPE_ID']] : array();
$invoiceProperties = array();
foreach ($fields['INVOICE_PROPERTIES'] as $code => $value) {
if (array_key_exists($code, $propsInfo)) {
$invoiceProperties[$propsInfo[$code]['ID']] = $value;
} else {
if ($code === 'COMPANY' && array_key_exists('COMPANY_NAME', $propsInfo)) {
$invoiceProperties[$propsInfo['COMPANY_NAME']['ID']] = $value;
}
}
}
$fields['INVOICE_PROPERTIES'] = $invoiceProperties;
unset($propsInfo, $invoiceProperties, $code, $value);
$DB->StartTransaction();
$recalculate = false;
$ID = $invoice->Add($fields, $recalculate, SITE_ID, array('UPDATE_SEARCH' => true));
if (!is_int($ID) || $ID <= 0) {
$DB->Rollback();
if (!empty($invoice->LAST_ERROR)) {
throw new RestException($invoice->LAST_ERROR);
} else {
throw new RestException('Error on creating invoice.');
}
} else {
$DB->Commit();
}
return $ID;
}
