Skip to content

Instantly share code, notes, and snippets.

View luckydevilru's full-sized avatar
🏠
Hard and smart work

Sergey Prokhorov luckydevilru

🏠
Hard and smart work
View GitHub Profile
@luckydevilru
luckydevilru / productsOfDealLead-bx24-box.php
Last active March 23, 2022 14:09
Получить get список list товаров products сделки deal или лида lead
<?php
// Получить список товаров у сделки или лида bitrix 24 коробка
// D = Deal, L = Lead;
if (!defined("B_PROLOG_INCLUDED") || B_PROLOG_INCLUDED !== true){
require_once($_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_before.php");
}
CModule::IncludeModule("crm");
CCrmProductRow::LoadRows($ownerType = 'D', $ownerID = $deal_id, $assoc = false);
@luckydevilru
luckydevilru / ExportHtmlTableToExcel
Created August 6, 2021 09:38
экспорт html таблицы в excel xls xlsx
<script src="https://code.jquery.com/jquery-latest.min.js" type="text/javascript"></script>
<script type="text/javascript">
var tableToExcel = (function () {
// Define your style class template.
var style = "<style>.title{font-size:18px;}.smetaTable{box-sizing: border-box;width: 100%;}.green{background-color: #31869B; color: #ffffff;}.brown{background-color:#FABF8F;font-weight:bold;font-size:13px;}.leftimg{position: absolute;margin-top:-20px}"
+".rightimg{position: absolute;}"
+".relative{position: relative;height:40px;}</style>";
var uri = 'data:application/vnd.ms-excel;base64,'
, template = '<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"><head><!--[if gte mso 9]><xml><x:ExcelWorkbook><x:ExcelWorksheets><x:ExcelWorksheet><x:Name>{worksheet}</x:Name><x:WorksheetOptions><x:DisplayGridlines/></x:WorksheetOptions></x:ExcelWorksheet></x:ExcelWorksheets></x:ExcelWorkbook
@luckydevilru
luckydevilru / addProductToDealBitrix24.php
Created August 13, 2021 09:18
Добавить продукт к сделке bitrix24 битрикс коробка
<?
// добавим товар в сделку
if (!empty($productID)) {
$rows[] = [
'PRODUCT_ID' => $productID, //id товара
'QUANTITY' => 1, //количество
];
if ( CCrmProductRow::SaveRows('D', $deal_id, $rows) ) {
writeToLog('Success', 'add to deal');
}else {
@luckydevilru
luckydevilru / CRest.php
Last active August 19, 2021 07:57
CRest.php bitrix24 битрикс срм скачать
<?php
require_once (__DIR__.'/settings.php'); // define('C_REST_WEB_HOOK_URL','https://domain.bitrix24.ru/rest/_userId_/_token_/');
/**
* @version 1.36
* define:
* C_REST_WEB_HOOK_URL = 'https://rest-api.bitrix24.com/rest/1/doutwqkjxgc3mgc1/' //url on creat Webhook
* or
* C_REST_CLIENT_ID = 'local.5c8bb1b0891cf2.87252039' //Application ID
@luckydevilru
luckydevilru / shipmentBitrix24.php
Created August 19, 2021 07:58
Завершить отгрузку bitrix24 order sale shipment
<?php
if (!defined("B_PROLOG_INCLUDED") || B_PROLOG_INCLUDED !== true){
require($_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_before.php");
}
$order = \Bitrix\Sale\Order::load($order_id);
$collection = $order->getShipmentCollection();
$shipment = $collection->getItemById($shipmentID);
$statusId = $shipment->getField('ALLOW_DELIVERY');
@luckydevilru
luckydevilru / ShipmentFromOrderBitrix24.php
Created August 20, 2021 08:15
Создание отгрузки из заказа сделки bitrix24. Create shipment from order deal bitrix bitrix24 битрикс
<?
if (!defined("B_PROLOG_INCLUDED") || B_PROLOG_INCLUDED !== true){
require($_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_before.php");
}
// 1. получаем заказ
$order = \Bitrix\Sale\Order::load($order_id);
// 2. получаем корзину заказа
@luckydevilru
luckydevilru / php_bbcode_parser.php
Last active October 11, 2021 16:04 — forked from afsalrahim/php_bbcode_parser.php
A simple PHP BBCode Parser function
<?php
/**
* A simple PHP BBCode Parser function
*
* @author Afsal Rahim
* @link http://digitcodes.com/create-simple-php-bbcode-parser-function/
**/
//BBCode Parser function
@luckydevilru
luckydevilru / TRACKING_SOURCE_ID.php
Last active November 11, 2021 13:17
Изменить поменять источник сквозной аналитики bitrix24 crm change TRACKING_SOURCE_ID
<?
$trace_id = \Bitrix\Crm\Tracking\Internals\TraceTable::add(['SOURCE_ID'=>123]); // сначала необходимо создать трейс. SOURCE_ID - это id источники сквозной аналитики. не путать с обычным SOURCE_ID
$result = \Bitrix\Crm\Tracking\Internals\TraceEntityTable::add(['TRACE_ID' => $trace_id->getID(), 'ENTITY_TYPE_ID' => \CCrmOwnerType::Lead, 'ENTITY_ID' => '__LEAD_ID__']); // привязываем трейс к сущности
@luckydevilru
luckydevilru / createSegmentBitrix24.php
Created November 11, 2021 13:15
Создать сегмент ( create | add ) segment bitrix24 битрикс
<?
CModule::IncludeModule("crm");
$companyIds = [76885,76951,77060];
$res = Bitrix\Crm\Integration\Sender\Segment::uploadAction(
$segmentId = null,
'COMPANY',
$entities = $companyIds,
$gridId = null
@luckydevilru
luckydevilru / getDepartmentUsersBitrix.php
Created December 17, 2021 09:06
Получить список пользователей подразделений Department bitrix24 php
<?php
if (!defined("B_PROLOG_INCLUDED") || B_PROLOG_INCLUDED !== true) {
require($_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/include/prolog_before.php");
}
use Bitrix\Main\UserTable;
CModule::IncludeModule("timeman");
$obImport = new Bitrix\Timeman\Monitor\Utils\Department;
$tsokDepartmentList = $obImport->getSubordinateDepartments("20");