{"err":"","T":0.01,"recs":313,"fld":[{"Name":"GSExID","Size":8,"Type":"C","fType":202},{"Name":"GSExType","Size":50,"Type":"C","fType":202},{"Name":"GSExSort","Size":8,"Type":"N","fType":5},{"Name":"Key","Size":255,"Type":"C","fType":202},{"Name":"GEIDC","Size":4,"Type":"N","fType":3},{"Name":"GSExNum","Size":8,"Type":"N","fType":5},{"Name":"GSExAttr1","Size":800,"Type":"C","fType":202},{"Name":"GSExAttr2","Size":800,"Type":"C","fType":202},{"Name":"GSExFlag","Size":8,"Type":"C","fType":202}],"res":[["SY","formula","","месяцы",1404,"","январь,февраль,март,апрель,май,июнь,июль,август,сентябрь,октябрь,ноябрь,декабрь","",""],["SY","help","","ExtsFlags",235,"","[|C+2 Флаги расширения|| h | скрытие|| * | не показывать|| d | сдвоенный атрибут|| f | не сворачивать текст|| s | наследование путем слияния|| n | не склеивать при наследовании|| r | запрет на изменения (rF - кроме финансиста)|| L | Домен. Список|| S | Домен. SQL|| В | Водитель|]","","dhf"],["SYВк","formula","","detailMoves",123,"","{ iif( \"P[1]\" == \"PayDate\", \"iif(nz(FirmPay)<=3,ns(ClContractor), cStr(FirmPay)) AS _r_Контрагент__firm, PayDate AS _r_Дата, (ns(CodeOp) + '; ' + ns(CodeDC)) AS [_r_КОП/КД__kop], Left( ns(Notice) + ' ' + ns(ClAssigning), 60) AS _r_Номенклатура , NUL","L AS Фаза__fl, '[pay]'+PayID+'[/pay]' + iif(DocDC>'', '[doc]'+DocDC+'[/doc]' , '') AS _r_Документ, NULL AS [_s_К-во], NULL AS Цена, { \"P[2]\" || \"IIF( SumPayIn IS NULL, -SumPayOut, SumPayIn)\" } AS _s_Сумма, Agent AS [Сотрудник__ag]\",\" iif(nz(FirmCont","dh"],["SYВк","formula","","detailMoves",136,"","ract)<=3,IIF(Person Is Null,'?',Person),cStr(FirmContract)) AS _r_Контрагент__firm, Date0( {\"P[1]\" || \"IIF(GSDate2 IS NULL,Date0(GSDate),Date0(GSDate2))\"} ) AS _r_Дата, (ns(CodeOp) + '; ' + ns(CodeDC)) AS [_r_КОП/КД__kop], ('[gs]' + GS + '[/gs] ' + I","IF(GSSpec>'' AND Len(GSSpec)>30,' ','') + IIF( InStr(GSSpec,'|')>0, '[| ' + GSSpec + ' |]', iif(CodeDC IS NULL AND GSSpec>'', Left(GSSpec,60), ''))) AS _r_Номенклатура , MMFlag AS Фаза__fl, ('[doc]'+Doc1 + '&' + cStr(MMID) + IIF(MPDoc>'' AND MPDoc<","dh"],["SYВк","formula","","detailMoves",267,"",">Doc1, '; ' + MPDoc + IIF(MMPID>0, '&' + cStr(MMPID),''),'')+'[/doc]') AS _r_Документ, Amount AS [_s_К-во], Price AS Цена, { \"P[2]\" || \"[Sum]\"} AS _s_Сумма, (IIF( Manager2 IS NULL OR Doc>'' AND Agent>'',Agent,Manager2) + IIF( Performer IS NULL, '', ';'"," + Performer )) AS [Сотрудник__ag]\")}","dh"],["SYВк","formula","","docBuy",58,"","Mid( {\"P[1]\" || \"DocID\"}, 4, 2) IN ('зу','зг','зи', 'нп', 'пх', 'хо')","","hd"],["SYВк","formula","","docSale",18,"","Mid( {\"P[1]\" || \"DocID\"}, 4, 2) IN ('ру','рг','по','на','ни','до','чо','иу','си','нр')","","hd"],["SYВк","formula","","docsClientFIO",299,"","{ $1 = fa.getFilter(\"Agent\",\"Agent\"), $2=\"IIF(Agent Is Null, '?', Agent)\", $2=\"Agent\", $3 = (t)=>(t=t||\"RegDate\", \"Year(\" + t + \"), Date0(\" + t + \")\" ), \"\"}SELECT Year(RegDate) AS _g_Дата, Date0(RegDate) AS _r_Дата, DocID AS _r_Документ__doc, Sum1 AS"," _s_Сумма_r_, Debt AS _s_Долг_r_, PPDate AS _r_ДатаПл, PPPayID AS _r_Платеж__pay, PPSum AS _s_Оплата, TmpCode AS _r_КОП__kop, {$2} AS _r_Агент__agFROM Docs INNER JOIN PartPayAll ON Docs.DocID=PartPayAll.PPDocIDWHERE (FirmContract=P[1] OR Trim(Person)='[","dh"],["SYВк","formula","","docsClientFIO",300,"","fio]P[1][/fio]') {$1}UNION ALL SELECT {$3(\"PayDate\")}, Null, 0, 0, PayDate, PayID, IIF(SumRest=0,SumPayOut,SumRest), CodeOp, {$2}FROM MoneyAll WHERE (SumRest>0 OR AVR1=False ) AND (FirmPay=P[1] OR Trim(ClContractor)='[fio]P[1][/fio]') {$1}UNION ALL S","ELECT {$3()}, DocID, Debt, Debt, Null, Null, 0, Null,{ $2} FROM DOCS WHERE (Debt>0 OR Sum1=0) AND (FirmContract=P[1] OR Trim(Person)='[fio]P[1][/fio]') {$1}UNION ALL SELECT {$3()}, DocID, Sum1, Debt, Null, Null, 0, Null, {$2} FROM DocsArxWHERE FirmCon","dh"],["SYВк","formula","","docsClientFIO",301,"","tract=P[1] {$1}{iif( db.dbName == \"well\", \"UNION ALL SELECT {$3()}, DocID, SS, 0, PPDate, PPPayID, PPSum, TmpCode, {$2}FROM (Select DocID, RegDate, Agent, Sum([Sum]) AS SS From MovesAll Where CodeOp>='12' AND InStr(GSSpec, ']P[1][')>0 Group BY DocID,"," RegDate,Agent) AS DINNER JOIN (Select PartPayAll.* From PartPayAll INNER JOIN MoneyAll ON PPPayID=PayID Where InStr(ClContractor,']P[1][')>0 OR FirmPay=P[1]) AS P ON D.DocID=P.PPDocID \")}ORDER BY 1 DESC","dh"],["SYВк","formula","","FIS Setup0",278,"","{ $9 = oParam( \" ProfitKD:0 \"), $9.moveKD = oParam( \" 1*Материалы: Left(CodeOp,2) = '87'; 3*Работа: CodeOp >= '01' AND CodeOp < '06'/*; 4*Сдельщина: CodeOp IN ('63')*/; 7*Налоги: Left(CodeOp,2) IN ('64','65') /*AND CodeOp<>'641'*/; 8*Услуги",": (Left(CodeOp,1) = '7' OR Left(CodeOp,2)='63' ); a*МБП: Left(CodeOp,2) IN ('86','88','89'); b*ОС: CodeOp < '86' AND Left(CodeOp,1) ='8'; c*Прочее: Left(CodeOp,1) = '9'; 0*Подряд: CodeOp>'1' AND CodeOp<'6'\"), $9.moneyKD = oParam","dh"],["SYВк","formula","","FIS Setup0",279,"","( \" 4*Сдельщина: CodeOp IN ('62','661','63'); 5*Проценты: Left(CodeOp,2) IN ('61'); 9*Услуги (д): Left(CodeOp,1) = '7'; 6*Зарплата: Left(CodeOp,2) IN ('66') AND CodeOp<>'661'\"),$9.Date0 = \"01.01.18\",$9.Resale = \"-1=InOut AND FirmContract>0 AND ","Doc>'' AND Left(CodeOp,1)='8' \",$9.FreeMove = \"AND (Stock=True AND (FirmContract IS NULL OR InOut=0) OR Stock<>True AND FirmContract>0 AND InOut=1 OR \" + $9.Resale + \")\",$9.FreeMoney = \" AND NOT (Left(ns(CodeOp),2) IN ('0','90','93','94','96','97','99'","dh"],["SYВк","formula","","FIS Setup0",302,"","))\",$9.Move = \"IsDraft<>True AND CodeOp >= '01' AND ( MMFlag Is Null AND Left(CodeOp,1)<>'8' OR Stock=True OR MMFlag>='8' AND MMFlag<='9' )\",$9.Perc = \"Left(CodeOp,2) IN ('61') AND PayType='zp' AND 0<>Cash.SumPayIn\",$9.ZP = \"Left(CodeOp,2) IN ('66'",") AND PayType='зп' AND 0<>Salary.SumPayIn\",$9.FOT = \"Left(CodeOp,2) IN ('61','62','66') \",$9 }","dh"],["SYВк","formula","","noDraft",87,""," 0=iif(IsDraft Is Null, 0, IsDraft) ","","d"],["SYВк","formula","","reestrClientFIO",296,"","{ opt(3,\"все;ч/л;zaprintom;фирмы;РА\")+opt(4,\"Задвоения:все;id;телефон;e-mail\")+opt(5,\"Нет движений\")/*+opt( \"filter\", \"Dates,Agent,CodeOp,Company\")*/, \"\" }function(fun,pp)=>( jf.ff.personReestr(fun,pp) )","","dh"],["SYВк","query","","[ico]/jFabula/img/combo-chart.png[/ico] Обороты: Валовая прибыль",393,"","{ opt( 1, \"Группировка:КОП;!Месяц;Сотрудник;Филиал;Фирма\" ) + opt( \"filter\", \"Dates,Agent,CodeOp,Firm,Company,SM\", \"//\"),$1 = formula(\"FIS Setup0\"), $1.kd = [],$1.kd[0] = sIIF( $1.moveKD, \"CodeOp\", (t,i,k) => (t + \", \" + sSql(k)) ),$1.kd[1] = sIIF("," $1.moneyKD, \"CodeOp\", (t1,i,k) => (t1 + \", \" + sSql(k)) ),$1.main = \"(CodeOp>'1' AND CodeOp<'6')\",$2 = fa.getFilter(\"CodeOp\",\"CodeOp;CodeDC\") + fa.getFilter(\"Agent\",\"Agent\") + fa.getFilter(\"Company\",\"Company\") + sReplace( fa.getFilter(\"Firm\"), \"FirmC","hd"],["SYВк","query","","[ico]/jFabula/img/combo-chart.png[/ico] Обороты: Валовая прибыль",394,"","ustomer\",\"0\") + fa.getFilter(\"SM\",1),$2 = [ $2, sReplace($2, [\"FirmContract\",\"Person\"], [\"FirmPay\",\"ClContractor\"] ) ],$4 = \" \" + (fa.getFilter(\"Dates\",\"GSDt\") || \"AND Year(GSDt) =\" + \"20\"+sRight(dtToday(),2) ),$4 = [ $4, sReplace($4, [\"GSDt\"], [\"PayDa","te\"] ) ],$3 = \"Left(IIF(CodeDC Is NULL,CodeOp,CodeDC),1) AS [_g_Направление__kop fld0]\",$3 = icase( opt(1), 1, \"Format(GSDt,'yyyy.MM') AS [_g_Месяц_desc]\", 2, \"Agent AS [_g_Агент__ag]\", 3, \"Company AS [_g_Филиал__filial]\", 4, \"FirmContract AS [_g_Фирма_","hd"],["SYВк","query","","[ico]/jFabula/img/combo-chart.png[/ico] Обороты: Валовая прибыль",395,"","_firm]\", $3 ) + \", \" + sReplace($3,[\"1\",\"_g_Направление\"],[\"2\",\"_g_КОП\"]) + \", \" + sReplace($3,[\"1\",\"_g_Направление\"],[\"3\",\"_1_КОП\"]) ,$3 = [ $3, sReplace($3, [\"GSDt\", \"FirmContract\"], [\"PayDate\", \"FirmPay\"] ) ],$5 = \" UNION ALL \",$6 = (kop,kd,sum,fr)"," => ( \"SELECT \" + kop + \" AS [_t_КОП], \" + (kd || $3[0]) + \",Round(Sum(\" + sum + \"),2) AS [_s_Прибыль] FROM \" + fr + \" GROUP BY \" + sCut( kd || $3[0] ,\" AS \", \"]\") + \",\" + kop ),\"\"}{ $8 = [],$7 = \"{$1.Move} AND {$1.main} AND Sum<>0 {$2[0]} \",$8","hd"],["SYВк","query","","[ico]/jFabula/img/combo-chart.png[/ico] Обороты: Валовая прибыль",396,"","[0] = $6( \"IIF(IsDraft=True,'',' Доход')\", 0, \"SM1\", \"Moves WHERE \" + $7 + \" {$4[0]} AND InOut=-1 AND 1=1\"),$8[1] = sReplace( $8[0], [\"Доход\", \"SM1\", \"WHERE \"], [\"НДС\", \"-SM1*RateNDS/(100+RateNDS)\", \"WHERE RateNDS>0 AND \"] ),$8[0] += \"{$5}\" + sReplace","( $8[0], [\" Доход\", \"SM1\", \"=-1\" ], [\"0*Подряд\", \"-SM1\", \">=0 AND MPDoc Is NULL\" ] ),$8[1] += \"{$5}\" + sReplace( $8[1], [\"НДС\", \"-SM1\", \"=-1\" ], [\"НДС вх\", \"SM1\", \">=0 AND MPDoc Is NULL\" ] ),$8[2] = $6( \"{$1.kd[0]}\", 0, \"-[Sum]\", \"(Select MMID, GSDt,","hd"],["SYВк","query","","[ico]/jFabula/img/combo-chart.png[/ico] Обороты: Валовая прибыль",397,""," Agent, FirmContract,Company From Moves Where \" + $7 + \" AND InOut=-1 ) AS M INNER JOIN (Select MMPID,CodeOp,CodeDC,[Sum],ParentDoc From Movement Where MMPID>0 AND ParentDoc >'') AS D ON M.MMID=D.MMPID WHERE MMPID>0 AND ParentDoc >'' AND CodeOp>='01' AND"," MMPID IN (Select MMID From Moves Where \" + $7 + \" {$4[0]} AND InOut=-1 AND 1=1)\"),$8[3] = $6( \"{$1.kd[1]}\", \"{$3[1]}\", \"-SumPayOut\", \"Money WHERE DocDC>'' AND AVR1=False AND SumPayOut<>0 {$4[1]} AND DocDC IN (Select Doc From Moves Where \" + $7 + \" AN","hd"],["SYВк","query","","[ico]/jFabula/img/combo-chart.png[/ico] Обороты: Валовая прибыль",398,"","D InOut=-1 AND 1=1)\" ),$8[3] += \"{$5}\" + sReplace( $8[3], [\"Money\", \"SumPayOut\", \"<>'zp'\" ], [\"Cash\", \"SumPayIn\", \"='zp'\" ] ),$8 = aList( $8, 0, \"{$5}\" ),\"\" }{ opt( \"detail\", \"_t_\", \"[Fun]\", (r,f,s) => ( aList( sSplit( \"{$8}\", \"{$5}\"), (t) => ( s"," = [ ssInner( t, \"],\", \" AS \"), ssInner( t, \"AS [\", \"]\") ],(\" AND Trim(\" + sInner(t,\"SELECT \", \"AS\") + \")=\" + sSql( sTag2(f)) , \"1=1\", s[0][0] + \"=\" + sSql( sTag2( r[s[1][1]] ))),s = \"SELECT \" + jf.ff.productSql( iif( sIn(t,[\"Money\",\"Cash\"]),\"PayDat","hd"],["SYВк","query","","[ico]/jFabula/img/combo-chart.png[/ico] Обороты: Валовая прибыль",399,"","e\"), sInner(t, \"Sum(\", \"),2)\"), iif(sIn(f,[\"Проценты\"]), \"Agent AS [_g_Сотрудник__ag]\"), sIn(t,\"Money\") ) + \" FROM \" + aFind( \"Salary,Cash,Money,Moves\", (x) => (sIn(t,x)) ) + \" WHERE \" + sInner( t, \"WHERE \", \"GROUP BY\") + \" AND Trim(\" + sInner(t,\"S","ELECT \", \"AS\") + \")=\" + sSql( sTag2(f)) + \" AND \" + s[0][0] + \"=\" + sSql( sTag2( r[s[1][1]] )) + iif( r[s[1][2]], \" AND \" + s[0][1] + \"=\" + sSql( sTag2( r[s[1][2]] ))) + iif( r[s[1][3]], \" AND \" + s[0][2] + \"=\" + sSql( sTag2( r[s[1][3]] )))), \"{$5}\"","hd"],["SYВк","query","","[ico]/jFabula/img/combo-chart.png[/ico] Обороты: Валовая прибыль",1442,""," ))), \"\" }{$8}","","hd"],["SYВк","query",1,"[ico]/jFabula/img/activity.gif[/ico] Пользователи: Активность",36,"","{ opt(\"filter\", \"Dates,Agent\"),$1 = (fd) => (\"1=1 \" + iif( fa.getFilter(\"Date1\"), fa.getFilter(\"Dates\", fd), \" AND \" + fd +\">Date() AND \" + fd + \" 7\" ), \"\"}SELECT {iif( fa.getFilter(\"Date1\"),","\"Format(D,'yy.MM.dd') AS [_g_Дата],\")} Agent AS _1_User__ag, Count(Agent) AS _s_Изменений, Min(Tm) AS [Start], Max(Tm) AS [Last], DateDiff('h', Min(Tm), Max(Tm) ) AS [_s_Часы]FROM( SELECT TOP 50000 Date0(Dt) AS D, Agent, Format( Dt, 'HH:mm') AS Tm ","hd"],["SYВк","query",1,"[ico]/jFabula/img/activity.gif[/ico] Пользователи: Активность",74,""," FROM Talk WHERE {$1(\"Dt\")} {fa.getFilter(\"Agent\", \"Agent\")}UNION All SELECT TOP 50000 Date0(LogDate), LogUser, Format( LogDate, 'hh:mm') FROM [~Log] WHERE {$1(\"LogDate \")} {fa.getFilter(\"Agent\", \"LogUser\")}) AS TmpGROUP BY D, Agent /*ORDER BY D D","ESC, 2*/","hd"],["SYВк","query",2,"[ico]/jFabula/img/activity.gif[/ico] Пользователи: Онлайн",118,"","function (fun) => (ajaxGet( \"/es/users/\" + iif( 1 || !isLocal,db.dbName), (ans) => (log(sEval(ans).map( (t)=>( { ip:t.ip, agent:t.userAgent } ))),ans = aArr( sEval(ans), 0, (r) => ( { _g_User__: iif(sLen(r.user) > 3, \"КЛИЕНТЫ\", r.user ==2, \"МАГАЗИ","Н\", /* jf.Tag(sLeft(fa.getAgent(r.user,\"GSID\"),6),\"ag\") */ \"Сотрудники\" ),_r_User__: sTag( r.user, iif(sLen(r.user) > 3, \"[firm]\", \"[ag]\" )), _r_host: sTag( sReplace( r.city, \"Респ Крым,\"), \"[adr]\") + \" \"+ sTag( r.host, \"\"), _r_ip: sColor(r.ip, iif(sEq0(r.ip, \"192.168.\") + sIn(r.host,\"b>\"), \"gray\", \"violet\" )), _2_db:r.db, _r_url: sTag( jf.Tag(r.ico,\"ico\")+ sReplace( sLeft(r.site, 40), [ \"http://\", \"https://\", \"/.\"],[\"\", sSize(\" 🔒 \",9), \"/ \"]), \"<","label>\") , _h_ua:r.userAgent, _r_browser: db.infoAgent(r.userAgent).browser || \"?\", _r_device: db.infoAgent(r.userAgent).device || \"?\", time: r.time , _r_version: sSplit(sReplace(r.version,dtToday()+\" \"),\" \",0)})),fun( ans ))))","d"],["SYВкЗа","query",4,"[ico]/jFabula/img/Schedules.png[/ico] Пользователи: Загрузка исполнителей",64,"","{ opt(\"filter\",\"Dates,Agent,CodeOp\"),$1 = (31 < dtCmp( fa.getFilter('Date2'), fa.getFilter('Date1'), 1)) ? \"Format(Dt,'yyyy-MM')\" : \" '[date Format]' + Format(Dt,'dd.MM.yy') + '[/date]' \" /*\"Format(Dt,'dd')\"*/,$2 = \"Round(Sum(PartTime/60),2) AS [_s_Вре","мя (ч)]FROM Talk INNER JOIN MOVEMENT ON Talk.MM = MOVEMENT.MMID\",$3= \" WHERE 1=1 {iif( fa.getFilter('Dates'), fa.getFilter('Dates','Dt'), \" AND Year(Dt)=Year(Date()) AND Month(Dt)=Month(Date())\")} {fa.getFilter('Agent','Agent')} {fa.getFilter('CodeOp'","hd"],["SYВкЗа","query",4,"[ico]/jFabula/img/Schedules.png[/ico] Пользователи: Загрузка исполнителей",65,"",",'CodeOp')} AND PartTime > 0 AND Txt LIKE 'Фаза%' \" ,$8 = \"SELECT MMID AS [_1_Задача__pm], ns(ParentDoc) + '&' + STR(MMID) AS [Заявка__doc], GS AS [Работа__gs], GSSpec AS [Спецификация], \"+ $2 + $3 + \" AND [Fun] GROUP BY MMID, ParentDoc, GS, GSSpec ","\",\"\"}{ opt( \"detail\", \"_t_Period\", $8, (r,f)=>( \"{$1} = \" + sSql(f) + \" AND Agent=\" + sSql( sTag2(r[\"_g_Исполнитель__ag\"] )) + iif( r[\"_1_Исполнитель__gs\"], \" AND GS=\" + sSql( sTag2(r[\"_1_Исполнитель__gs\"] ))))), \"\"}SELECT Agent AS [_g_Исполните","hd"],["SYВкЗа","query",4,"[ico]/jFabula/img/Schedules.png[/ico] Пользователи: Загрузка исполнителей",133,"","ль__ag], GS AS [_1_Работа__gs], {$1} AS [_t_Period], {$2} {$3} GROUP BY Agent, GS, {$1}","","hd"],["SYВкЗаИм","import",1,"[ico]add[/ico] Создать задачу [*]",1599,"","pm.NewItem(-1,0)","",""],["SYВкЗаИм","import",2,"[ico]copy[/ico] Копировать задачу",1600,"","pm.NewItem(-1,1)","",""],["SYВкЗаИм","import",10,"[ico]/lib/icons8/rows.png[/ico] Список: Режим",1603,"","pm.Resize(true)","",""],["SYВкЗаИм","import",11,"[ico]/lib/icons8/vertical-timeline.png[/ico] Список: Диаграмма Гантта",1604,"","pm.chartMode(-1)","",""],["SYВкЗаИм","import",91,"[ico]print[/ico] Список: Печать [BF]",1602,"","pm.tbl.Print()","",""],["SYВкЗаИм","import",92,"[ico]xls[/ico] Список: Вывод в Excel",1601,"","pm.tbl.ToExcel(-1)","",""],["SYВкЗаИм","import",98,"[ico]del[/ico] Удалить задачу",1605,"","pm.DelItem(-1)","",""],["SYВкЗаХФ","[red]Ошибки[/red]","","Повторение свойств [2]",225,"","/*MMFlag>'1' AND CodeOp<>'110' AND*/ MMID IN (SELECT DISTINCT pid FROM DblPROPERTY WHERE pid>0 AND [Property] NOT IN ('Комментарий', /*'Макет в работу',*/'_Note') )","autoSql( sqSplit( formula(\"delProperty1\")+\";\" + formula(\"delProperty2\"), \";\"), \"Повторение свойств\", -1, funDo)",""],["SYВкКоИм","import",10,"[ico]add[/ico] Создать новую фирму [*]",1594,"","firmsNew(-1)","",""],["SYВкКоИм","import",12,"[ico]merge[/ico] Перенести движение",1453,"","firms.Merge()","",""],["SYВкКоИм","import",81,"[ico]xls[/ico] Список: Вывод в Excel",1597,"","firms.tbl.ToExcel(-1)","","FV"],["SYВкКоИм","import",82,"[ico]print[/ico] Список: Печать",1598,"","firms.tbl.Print()","","FV"],["SYВкКоИм","import",89,"[ico]slide[/ico] Список: Пройти по списку",1595,"","{$1=\"{input}\" || _Astral.importFirm( r.Key, 0, f ) || \"f()\",iif(db.isAdmin(\"F\"),\"fun:firms.ListIter((r,f)=>(\"+$1+\")\")}","",""],["SYВкКоИм","import",98,"[ico]del[/ico] Удалить",1596,"","firmsDel(-1)","","BF"],["SYВкКоХФ","[red]Ошибки[/red]","","Задвоение ИНН []",44,"","INN>'' AND INN IN (SELECT Min(INN) FROM FIRMS GROUP BY INN,KPP HAVING Count(FirmID)>1)","",""],["SYВкКоХФ","[red]Ошибки[/red]","","Задвоение Названия []",45,"","[Name] IN (SELECT [Name] FROM Clients GROUP BY [Name] HAVING Count([Key])>1)","",""],["SYВкКоХФ","не задан","","Не было движения",227,"","{$1=\"NOT EXISTS ( SELECT DISTINCT\", $2=\" '[fio]' + Trim(STR([Key])) + '[/fio]' \", \"\"} {$1} DocID FROM DOCS WHERE [Key]=FirmContract OR [Key]=FirmCustomer OR Person={$2} )AND {$1} PayID FROM MoneyAll WHERE [Key]=FirmPay OR ClContractor={$2} )","","d"],["SYВкНо","query","","[ico]/local/img/grid.png[/ico] Контроль переноса остатков в архив",317,"","{opt(\"filter\",\"Date2,Company\"), \"\"}{$4 = \"{elInner(\"gands.code\")}\",$1 = \"Where GS Like '\" + $4 + \"%' AND IsDraft<>True AND GSDt < cDate('{DateArx}') {fa.getFilter(\"Date2\",\"GSDt\")} {fa.getFilter(\"Company\",\"Company\")}\",$2 = iif( sLen($4) <= 2, \"Left(GS",",4) AS [_g_Группа__gs],\") + iif( sLen($4) <= 4, \"Left(GS,6) AS [_g_Номенклатура__gs],\") + \"GS AS [_1_Номенклатура__gs] \", $3 = \"IIF( Doc>'' AND InOut=-1 AND FirmContract>0, PrimeCost*Amount, [Sum])\", $3 = \"Sum( IIF( nz([Sum])=0, 0, InOut * IIF( InOut=","hd F"],["SYВкНо","query","","[ico]/local/img/grid.png[/ico] Контроль переноса остатков в архив",318,"","1 AND RateNDS<>0, Round([Sum2]/(1+RateNDS/100)+[Sum]-Sum2,2), \"+$3+\" )))\", \"\" }SELECT {$2} , Sum(N1) AS [_s_Колво1], Sum(N2) AS [_s_Колво2], Sum(N1-N2) AS [_s_Колво] , Sum(S1) AS [_s_Сумма1], Sum(S2) AS [_s_Сумма2], Sum(S1-S2) AS [_s_Сумма]FROM ( S","ELECT GS, Sum( InOut*Amount) AS N1, {$3} AS S1, 0 AS N2, 0 AS S2 FROM MovesAll {$1} Group By GS UNION ALL SELECT GS, 0, 0, Sum( InOut*Amount), {$3} FROM MOVES {$1} AND ( GS LIKE 'ОС%' OR GSDt >= DateAdd(d,-1,cDate('{DateArx}'))) Group By GS) AS ","hd F"],["SYВкНо","query","","[ico]/local/img/grid.png[/ico] Контроль переноса остатков в архив",1403,"","Tmp GROUP BY GS HAVING Abs(Round( Sum(N1-N2) ,2)) > 0.01 OR Abs(Round( Sum(S1-S2) ,2)) > 0.01","","hd F"],["SYВкНо","query","","[ico]/local/img/grid.png[/ico] Остатки ТМЦ",319,"","{opt(1,\"Филиалы\")+opt(\"filter\",\"Dates,Company\"),$1 = iif( \"well\"==db.dbName,\"IIf(Stock=True,InOut*Amount,0)\", \"InOut*Amount\"),$2 = sReplace($1,\"Amount\", \"IIF(InOut=1 AND RateNDS>0,Amount*Price,[Sum])\"),$3 = \",Company AS [_t_Filial]\",$4 = elInner(\"gand","s.code\"),$5 = \"IIF( InStr(GANDS.GSFlag,'К')>0, GSSpec, '') \",\"\"}SELECT GS AS [_h_Арт] {iif( sLen($4) < 4, \", Left(GS,4) AS [_g_Тип__gs]\") } {iif( sLen($4) < 6, \", Left(GS,6) AS [_g_Наименование__gs]\") } , GS AS [_1_Наименование__gs], {$5} AS [_2_","hd BFL"],["SYВкНо","query","","[ico]/local/img/grid.png[/ico] Остатки ТМЦ",320,"","Спец], GSUnit AS [Ед_изм], Round(Sum({$1}),2) AS [_s_Кол-во], Round(Sum({$2}),2) AS [_s_Сумма] {iif(opt(1), $3 )}FROM GANDS INNER JOIN MovesAll ON GANDS.GSID = MovesAll.GSWHERE GANDS.CheckStock=True AND IsDraft<>TrueAND GANDS.GSID LIKE '{$4}%' {fa.ge","tFilter(\"Date2\",\"GSDt\")} {fa.getFilter(\"Company\",\"Company\")}GROUP BY GS, GSUnit, {$5} {iif(opt(1), \",Company\" )}HAVING Round(Sum({$2}),2) <> 0","hd BFL"],["SYВкНо","query","","[ico]/local/img/user_add.png[/ico] Пользователи: Следующий штатный номер",43,"","SELECT Max(1+cInt([GSCodeNumber])) AS [Штатный номер]FROM GANDS WHERE GSID Like 'SYСо%' AND GSCodeNumber>'600' AND GSCodeNumber<'650'","","hd"],["SYВкНоИм","import",12,"[ico]merge[/ico] Перенести движение",1626,"","gands.Merge(-1)","",""],["SYВкНоИм","import",81,"[ico]xls[/ico] Список: Вывод в Excel",1627,"","gands.tbl.ToExcel(-1)","",""],["SYВкНоИм","import",82,"[ico]print[/ico] Список: Печать",1628,"","gands.tbl.Print()","",""],["SYВкНоХФ","[red]Ошибки[/red]","","Был [red] отрицательный [/red] остаток []",198,""," CheckStock=True AND GSID IN (SELECT DISTINCT GS FROM Movement WHERE nz(Rest)<0 OR nz(RestSum)<0)","",""],["SYВкОп","query","","[ico]/local/img/design.gif[/ico] Макеты: Макетирование (оборот+прибыль)",60,"","{ \"\" /*opt(1, \"!Продажа\"), opt(2, \"Прибыль ОП\"), opt(3, \"!Подряд\")+opt(4, \"Прибыль ОД\"), opt(5, \"!Затраты\")*/+opt(6, \"Задачи: все; создание макета; проверка макета\")+opt(7, \"Группировка по: месяцу; сотруднику\")+opt(\"filter\", \"Dates\" + iif( !db.isAdmi","n(\"V\") , \"Agent\") ),$1 = \"Format(GSDt,'yyyy/MM')\",$2 = \"(SELECT \" + $1 + \" AS M, Performer AS D ,Round( Sum(PrimeCost*Amount), 0) AS Z ,Round( Sum(SM2), 0) AS S2, Round( Sum(SM1), 0) AS S1 ,Round( Sum(SM2) - Sum(SM1), 0) AS P1,Round( Sum(SM1) - Su","hd FV"],["SYВкОп","query","","[ico]/local/img/design.gif[/ico] Макеты: Макетирование (оборот+прибыль)",61,"","m(PrimeCost*Amount), 0) AS P2/*,S2 - S1 AS P1, S1 - Z AS P2*/FROM Moves WHERE { iif( \"well\" == db.dbName, \"CodeOp LIKE '010{ icase( opt(6), 1, '1', 2, '0', \"%\")}' \", \" CodeOp IN ('01', '02') \" )}AND MMFlag>'3' AND GSDt>=cDate('01.01.18') {fa.getFilt","er('Dates','GSDt')} {iif( !db.isAdmin(\"V\"), fa.getFilter('Agent','Performer'))}GROUP BY \" + $1 + \", Performer) AS Tmp\",$7 = iif( opt(7), \"D AS [_g_Сотрудник__ag], M AS [_1_Месяц]\" , \" M AS [_g_Месяц], D AS _1_Сотрудник__ag\" ),\"\"}SELECT {$7}{","hd FV"],["SYВкОп","query","","[ico]/local/img/design.gif[/ico] Макеты: Макетирование (оборот+прибыль)",62,""," iif( 1 || opt(1), \", S2 AS [_s_Продажа]\" )}{ iif( 1 || opt(2), \", P1 AS [_s_Прибыль ОП]\" )}{ iif( 1 || opt(3), \", S1 AS [_s_Подряд]\" )}{ iif( 1 || opt(4), \", P2 AS [_s_Прибыль ОД]\" )}{ iif( 1 || opt(5), \", Z AS [_s_Затраты]\" )}{ iif( 1 || opt(2",") && opt(4), \", P1+P2 AS [_s_Прибыль]\" )}FROM {$2}","hd FV"],["SYВкОпИм","import",10,"[ico]add[/ico] Создать документ [*]",1606,"","DocsNew(-1,0)","",""],["SYВкОпИм","import",11,"[ico]copy[/ico] Скопировать/разделить документ [АМ]",1607,"","DocsNew(-1,1)","",""],["SYВкОпИм","import",17,"[ico]outgoing-data[/ico] Создать стандартные задачи [*]",1609,"","docs.QuickTasks(-1)","",""],["SYВкОпИм","import",18,"[ico]share--v1[/ico] Создать подчиненные документы",1608,"","docs.slave.Init()","",""],["SYВкОпИм","import",19,"[ico]check[/ico] Чек [FBWE]",1610,"","DocsCurrent(-1,0,0,1,()=>(atol.KKT('docs.KKT','Отгрузка','docs')))","","FBWEC"],["SYВкОпИм","import",82,"[ico]sigma[/ico] Пересчитать суммы",1613,"","DocSummary(docs.CurRec.DocID,true)","",""],["SYВкОпИм","import",83,"[ico]print[/ico] Печать: Формы",1611,"","{iif(db.isAdmin(\"F\") || formula(\"imAg\") && aIn( [\"От\"], sLeft(fa.Doc(\"DocType\"),2)) && !formula(\"badCompany\") && !(fa.getCompany(fa.Doc().Company, \"ndsTax\")() != fa.Doc().RateNDS) && !(aFind(fa.Doc().moves,(r)=>(sIn(fa.getGands(r.GS,\"GSFlag\"),\"М\"))) && !formula(\"hasEDO\")),\"docs.Reports()\")}","",""],["SYВкОпИм","import",84,"[ico]/lib/img/fs/sql.gif[/ico] Печать: Счет [А]",1612,"","{iif(db.isAdmin(\"F\")|| !(aFind(fa.Doc().moves,(r)=>(sIn(fa.getGands(r.GS,\"GSFlag\"),\"М\"))) && !formula(\"hasEDO\"))&& aIn( [\"От\"], sLeft(fa.Doc(\"DocType\"),2)) && !formula(\"badCompany\") && !(fa.getCompany(fa.Doc().Company, \"ndsTax\")() != fa.Doc().RateNDS),\"docs.Bill()\")}","",""],["SYВкОпИм","import",85,"[ico]xls[/ico] Список: Вывод в Excel",1614,"","docs.tbl.ToExcel(-1)","",""],["SYВкОпИм","import",86,"[ico]print[/ico] Список: Печать",1615,"","docs.tbl.Print()","",""],["SYВкОпИм","import",89,"[ico]slide[/ico] Список: Пройти по списку [AF]",1591,"","{ iif( db.isAdmin(\"F\"), \"docs.ListIter() \") }","","d"],["SYВкОпИм","import",98,"[ico]/lib/icons8/user-credentials.png[/ico] Скрыть затраты [А]",1618,"","docs.HideCosts(-1)","",""],["SYВкОпИм","import",98,"[ico]merge[/ico] Слить документы [C]",1617,"","{iif(aCount(docs.tbl.rec,0,(t)=>(t.isCheck)),\"DocsMerge(-1)\")}","",""],["SYВкОпИм","import",99,"[ico]del[/ico] Удалить документ",1616,"","{iif( fa.Doc().SumExt3, 'wiAlert(0,\"Есть затраты по кассе\",0,\"Удалить нельзя\")',aFind(fa.Doc().pays,(r)=>(r.PPSumPlan==0)), 'wiAlert(0,\"Есть оплаты\",0,\"Удалить нельзя\")',aFind(fa.Doc().moves,(r)=>(r.DocID!=r.Doc1)), 'wiAlert(0,\"Есть связанные документы\",0,\"Удалить нельзя\")',\"docs.Delete(-1)\")}","",""],["SYВкОпОт","formula","","Оферта.Конец",1406,"","
6. В случае, если Покупатель не является участником ГИС МТ \"Честный знак\" при продаже маркированного товара по данному счету-оферте он будет передан Покупателю без возможности его последующей реализации третьим лицам (выведен из оборота).
7. Стороны согласовали, что при наличии обстоятельств непреодолимой силы, в т.ч. неблагоприятных погодных, условий срок поставки товара/ оказания услуг смещается на срок действия на период их действия.
8. Все споры и разногласия подлежат разрешению в Арбитражном суде Республики Крым с обязательным соблюдением претензионного порядка. Срок ответа на претензию - календарных дней с момента ее получения.
9. Стороны признают юридическую силу за электронными письмами (документами, в том числе, ","но не ограничиваясь этим, настоящий счет, макеты, образцы, эскизы, заявки, характеристики товара/услуги, место оказания услуги и т.п.) и их направление по средствам электронной почты:
Настоящий Счет-оферта (далее - «Счет») является письменным предложением (офертой) заключить Договор, которое направляется Плательщику в соответствии со ст.432-444 ГК РФ. Договор заключается путем принятия оферты (акцепта) в порядке, предусмотр","енном настоящей офертой, что считается соблюдением письменной формы договора.
Условия оферты
1. В соответствии с условиями настоящего счета-оферты Поставщик/Исполнитель обязуется передать Покупа","d"],["SYВкОпОт","formula","","Оферта.Начало",1411,"","телю Товар и/или оказать Заказчику услуги в количестве и ассортименте, указанными в настоящем счете, а Покупатель/Заказчик обязуется принять и оплатить поставленный товар/оказанные услуги.
2. Единственно возможным надлежащим акцептом данной офер","ты и существенным условием поставки товара/оказания услуги по настоящему счету является полная единовременная оплата настоящего счета на условиях % предоплаты .
В случае частичной предоплаты товара/услуг, оставшиеся % стоимости товара/услуги по","длежат оплате в следующем порядке:
а) в течение календарных дней с момента поставки товара/оказания услуги, что подтверждается подписанием Сторонами Универсального передато","d"],["SYВкОпОт","formula","","Оферта.Начало",1413,"","чного документа (УПД);
б) в течение календарных дней с момента уведомления Покупателя/Заказчика о готовности товара к отгрузке/ к оказанию услуги. Поставка товара/оказа","ние услуги осуществляются после получения подтверждения об оплате полной стоимости товара/услуги.
3. Моментом исполнения обязательства по оплате является поступление денежных средств на расчетный счет.
4. Счет действителен в течение 10","d"],["SYВкОпОт","formula","","Оферта.Начало",1414,""," (десяти) рабочих дней с указанной в нем даты выставления (срок для акцепта оферты).
а) срок поставки: дней с момента предоплаты товара, в порядке предусмотренном п.п.2,3 настоящего счета.
б) приемка товара по количеству и качеству осуществляется Покуп","ателем в день передачи Товара на складе Поставщика. Надлежащая поставка товара подтверждается Сторонами путем подписания Универсального передаточного документа (УПД). Моментом исполнения обязательства Поставщика по поставке товара является дата","d"],["SYВкОпОт","formula","","Оферта.Товары",1415,""," подписания Сторонами УПД (дата, указанная в документе).
в) право собственности на Товар, равно как и связанные с ним риски случайной гибели или повреждения товара, переходят к Покупателю с момента приемки товара Покупателем и подписания УПД упол","номоченными представителями Поставщика и Покупателя.
г) условия поставки: самовывоз со склада Поставщика по адресу: . Все виды погрузо-разгрузочных работ, включая работы с применением грузоподъемных средств, осуществляются Покупателем собствен","ными техническими средствами или техническими средствами третьих лиц за свой счет.
а) срок оказания услуг: рабочих дней с момента предоплаты ","услуги в порядке, предусмотренном п.п.2,3 настоящего счета.срок оказания услуг: до включительно при условии поступления оплаты на расчетный счет Исполнителя. Для оказания услуги, требующей от Зака","d"],["SYВкОпОт","formula","","Оферта.Услуги",1417,"","зчика предоставления исходных данных или макета срок оказания услуги исчисляется с момента предоставления всех необходимых данных/макета,
б) место оказания услуги зависит от вида оказываемых услуг:
- в месте указанном Заказч","иком, если это необходимо для непосредственного оказания услуги (согласовывается сторонами по электронной почте);
- по месту нахождения Исполнителя - в иных случаях.
в) прием-передача оказанных услуг осуществляется сторонами в","d"],["SYВкОпОт","formula","","Оферта.Услуги",1418,""," день их оказания. Надлежащее оказание услуг подтверждается подписанием УПД (дата, указанная в документе). В случае, если предоставленный УПД не подписан Покупателем/Заказчиком и/или второй его экземпляр не возвращен Исполнителю а письменные мотивированны","е возражения со стороны Заказчика не получены Исполнителем в течение 10 (десяти) рабочих дней - УПД считается подписанным Заказчиком, а услуги оказаны надлежащего качества и в срок и подлежат оплате.
г) если в результате оказания услуги создан объект интеллектуальной собственности - исключительные права на его использование переходят и принадлежат Заказчику (с момента полной оплаты), ","а Исполнитель имеет право его использовать в некоммерческих целях: для представления в портфолио, на сайте, в целях саморекламы, выставках, фестивалях и для составления персональной базы данных.
","d"],["SYВкОпХФ","[red]Ошибки[/red] в оплате","","Можно слить оплаты []",231,"","DocID In (SELECT PPDocID FROM PartPay As Tmp GROUP BY PPDocID, PPPayID, PPDate, TmpCode HAVING Count(*) > 1) ","","d"],["SYВкОпХФ","[red]Ошибки[/red] в оплате","","Неправильный долг []",71,"","FirmContract>0 AND Left(DocType,2)<>'Пр' AND DocID IN ( SELECT DocID FROM DocsAll LEFT JOIN PartPayAll ON DocsAll.DocID = PartPayAll.PPDocID GROUP BY DocID, Sum1, Sum2, Debt, Debt2HAVING Round( iif( Sum(PPSum) Is Null, 0, Sum(PPSum)) + Debt - Sum1,2)"," <> 0)","d"],["SYВкОпХФ","[red]Ошибки[/red] в оплате","","Несовпадение ФИО ЧЛ [2]",72,""," DocID IN ( SELECT PPDocID FROM PartPay INNER JOIN MoneyAll ON PartPay.PPPayID=MoneyAll.PayID WHERE FirmContract<=3 AND FirmPay<=3 AND Person>'' AND ns(Person) <> ns(ClContractor) AND (ClContractor>'' OR InStr(PPDocID,'ЧО')=0))","{ aList( \"DOCS,Cash,CashArx,Bank,BankArx\", (t,i) => (i = iif( i, \"ClContractor\", \"Person\"),\"UPDATE \" + t + \",ClientFIO SET \" + t + \".\" + i + \" = '[fio]' + cStr(ClID) + '[/fio]' WHERE \" + i + \">'' AND Replace(\" + i + \",'-','')=FIO\"), \";\")}",""],["SYВкОпХФ","[red]Ошибки[/red] в оплате","","Нет связи с платежом [2]",124,"","DocID IN (SELECT PPDocID FROM PartPay LEFT JOIN MoneyAll ON PartPay.PPPayID=MoneyAll.PayID WHERE PPPayID>'' /*AND PPDate >=cDate('{DateArx}')*/ AND PayID is Null)","DELETE * FROM PartPay WHERE NOT EXISTS ( SELECT PayID FROM MoneyAll WHERE PPPayID=PayID)",""],["SYВкОпХФ","[red]Ошибки[/red] в строках","","Не задан: Товар, КОП, Дата1, +/- [2]",1443,"","{$1=\" Is NULL OR \",\"\"}EXISTS (SELECT Doc1 FROM Movement WHERE DocID=Doc1 AND(GSDate{$1}GS{$1}CodeOp{$1}InOut {$1}{docSale(Doc)} AND InOut<>-1 OR {docBuy(Doc)} AND InOut = -1OR InOut=1 AND Doc Is NULL AND CodeOp>'0111' AND ns(CodeDC) NOT LIKE '95%' ))","DELETE FROM MOVEMENT WHERE GS Is Null AND GSDate < Date() AND 0=nz([Sum]);UPDATE MOVEMENT INNER JOIN GANDS ON GANDS.GSID = MOVEMENT.GS SET CodeOp = GSCOP WHERE ns(CodeOp) <> ns(GSCOP);UPDATE MOVEMENT SET GSDate = Date() WHERE GSDate Is Null",""],["SYВкОпХФ","[red]Ошибки[/red] в строках","","Плохое подчинение []",228,"","DocID IN ( SELECT Doc FROM Movement WHERE Doc=ParentDoc)","",""],["SYВкОпХФ","[red]Ошибки[/red] в шапке","","Затраты (подр.+мат.+работы) [2]",210,"","DocID IN (SELECT DocID FROM Docs INNER JOIN MovementAll AS MON DocID=M.ParentDoc OR DocID=Doc AND InOut=-1 AND CodeOp LIKE '8%'WHERE 'ВПСб'<>DocType GROUP BY DocID,SumExtHAVING Abs(SumExt-Sum(IIF(InOut=-1 AND CodeOp LIKE '8%',Amount*PrimeCost,Sum)))>1)","{ correctSumDoc(Затраты прямые, SumExt, \"IIF(InOut=-1 AND CodeOp LIKE '8%',Round(Amount*PrimeCost,2),[Sum])\", LEFT JOIN MovementAll AS MM ON DocID=MM.ParentDoc OR DocID=Doc AND InOut=-1 AND CodeOp LIKE '8%', DocType <> 'ПрАв' AND NOT DocID LIKE '%сб%') }",""],["SYВкОпХФ","[red]Ошибки[/red] в шапке","","Затраты (проценты) [2]",211,"","DocID IN (SELECT DocID FROM Docs LEFT JOIN (Select DocDC, Sum(SumPayIn) AS SP From CashAll Where PayType='zp' GROUP BY DocDC) AS M ON Docs.DocID=M.DocDCWHERE round(SumExt3,2)<>round( nz(SP) ,2))","{ correctSumDoc(Затраты проценты, SumExt3, SumPayIn, LEFT JOIN CashAll ON Docs.DocID = CashAll.DocDC, CashAll.PayType='zp') }",""],["SYВкОпХФ","[red]Ошибки[/red] в шапке","","Затраты (прямые по деньгам) [2]",91,"","DocID IN (SELECT DocID FROM Docs LEFT JOIN (Select DocDC, Sum(SumPayOut) AS SP From [MoneyAll] Where PayType<>'zp' AND nz(SumPayIn)=0 GROUP BY DocDC) AS M ON Docs.DocID=M.DocDCWHERE round(SumExt2,2) <> round( nz(SP), 2) )","{ correctSumDoc(Затраты деньги, SumExt2, \"nz(SP)\", \"LEFT JOIN (Select DocDC, Sum(SumPayOut) AS SP From [MoneyAll] Where PayType<>'zp' AND nz(SumPayIn)=0 GROUP BY DocDC) AS M ON Docs.DocID=M.DocDC\", 1=1 ) }",""],["SYВкОпХФ","[red]Ошибки[/red] в шапке","","Ненормальный N заявки []",90,"","(Len(DocID)<10 OR Left(DocID,2)<>ns(Company) OR InStr(DocID,'?')>0 OR Company is Null OR DocType is Null OR Right( STR(Year(RegDate)),1) <> Mid(DocID,3,1) OR Mid(DocID,6,1) > '9' OR InStr(DocID,'ин')=0 AND Right(DocID,5) NOT LIKE '[0-9][0-9][0-9][0-9][","0-9]' ) ","d"],["SYВкОпХФ","[red]Ошибки[/red] в шапке","","Повторение свойств []",214,"","EXISTS (SELECT ExtID FROM DblPROPERTY WHERE Left([Property],4) NOT IN ('_KKT','_ЭДО') AND ExtID=DocID AND pid=0)","","d"],["SYВкОпХФ","[red]Ошибки[/red] в шапке","","Пустые строки []",1436,"","NOT EXISTS (SELECT Doc FROM MovementAll WHERE DocID = MovementAll.Doc)","",""],["SYВкОпХФ","[red]Ошибки[/red] в шапке","","Сумма шапки не равна сумме строк [2]",212,"","DocID IN (SELECT Doc FROM MovesAll WHERE Doc>'' AND DocType <> 'ВПСб' AND ns(MMFlag)<>'A'GROUP BY Doc, SD1, SD2HAVING Abs(SD1 - Sum(SM1)) > 0.011 OR Abs(SD2 - Sum(SM2)) > 0.011)","{$9=\"LEFT JOIN MovesAll ON Docs.DocID=MovesAll.Doc,DOCS.FirmContract IS NULL AND DOCS.DocType <> 'ПрАв' AND DOCS.DocType <> 'ВПСб' AND 'A'<>MMFlag\",\"\"}{correctSumDoc(Сумма шапки1,Sum1,SM1,{$9})},{correctSumDoc(Сумма шапки2,Sum2,SM2,{$9})}",""],["SYВкОпХФ","formula","","correctSumDoc",213,"","{ $1=\"P[1]\" /* Заголовок */, $2=\"P[2]\" /* Поле шапки */, $3=\"P[3]\" /* Сумма строк */, $4=sReplace(\"P[4]\",\"&\",\",\") /* FROM */, $5=sReplace(\"P[5]\", [\"&\", \"MMFlag\"], [\",\", \"ns(MMFlag)\"]) /* WHERE */ ,\"\"}autoSql( \"SELECT TOP 500 Docs.DocID, Docs.{$2}, Rou","nd( Sum( {$3} ), 2) AS SS FROM Docs {$4} WHERE {$5} GROUP BY Docs.DocID, Docs.{$2} HAVING Abs( nz(Docs.{$2}) - Sum( {$3} )) > 0.1\", \"{$1}\", -1, (rr) => ( autoSql( aList( rr, (r) => ( \"UPDATE Docs SET {$2}=\" + r.SS + \" WHERE DocID=\" + sSql(r.DocID)","d"],["SYВкОпХФ","formula","","correctSumDoc",1438,""," ), \";\" ), \"{$1}-2\", -1, /*() => (1)),*/ window.funDo)))","","d"],["SYВкПл","formula","","moneyFilter",2,"","{ iif(\"P[1]\", \"Dates,CodeOp,CodeDC,PayType,Company\", \"{fa.getFilter('Dates','PayDate')} {fa.getFilter( 'CodeOp', 'CodeOp' )} {fa.getFilter( 'CodeDC', 'CodeDC' )} {fa.getFilter( 'Company', 'Company' )}{fa.getFilter( 'PayType', 'PayType' )}\")}","","d"],["SYВкПл","query","","[ico]/local/img/profit.png[/ico] Обороты: Прибыль по оплатам",19,"","{ opt( 1, \"Агент; Менеджер\") + opt( \"filter\", \"{moneyFilter(1)}\"),$1 = iif( opt(1), \"Manager\", \"Docs.Agent\"),$2 = fa.getFilter(\"Agent\",$1) + \" AND {docSale}\",$3 = fa.getFilter( \"CodeOp\", \"iif(CodeDC Is Null,CodeOp,CodeDC)\") + fa.getFilter( \"Company\", ","\"DOCS.Company\") ,$4 = \"DOCS INNER JOIN CASH ON DOCS.DocID = CASH.DocDC\",\"\"}SELECT Ag AS [_1_{ iif( opt(1), \"Менеджер__ag\", \"Агент__ag\")}], Round( Sum(PSum), 0) AS [_s_Оплаты], Round( Sum(MSum), 0) AS [_s_Затраты], Round( Sum(CSum), 0) AS [_s_Затра","hd F"],["SYВкПл","query","","[ico]/local/img/profit.png[/ico] Обороты: Прибыль по оплатам",20,"","ты (Д)], ' (r) => ( r[\"_s_Оплаты\"]-r[\"_s_Затраты\"]-r[\"_s_Затраты (Д)\"]) ' AS [_v_Прибыль], Round( Sum(KSum), 0) AS [_s_Проценты]FROM ( SELECT {$1} AS [Ag], Sum(PPSum) AS PSum, (0) AS MSum, (0) AS CSum, (0) AS KSumFROM DOCS INNER JOIN PARTPAY ON DOCS",".DocID = PARTPAY.PPDocIDWHERE 1=1 {fa.getFilter(\"Dates\", \"PPDate\")} {fa.getFilter( \"CodeOp\",\"TmpCode\")} {$2}GROUP BY {$1}UNION ALL SELECT {$1} AS [Ag], 0, Sum([Sum]) AS MSum, 0, 0FROM DOCS INNER JOIN MOVEMENT ON DOCS.DocID=MOVEMENT.ParentDocWHERE 0=","hd F"],["SYВкПл","query","","[ico]/local/img/profit.png[/ico] Обороты: Прибыль по оплатам",21,"","IsDraft AND [Sum]>0 {fa.getFilter(\"Dates\", \"iif(GSDate2 Is Null,GSDate,GSDate2)\")} {$3} {$2} GROUP BY {$1}UNION ALL SELECT {$1} AS [Ag], 0, Sum(Amount*PrimeCost) AS MSum, 0, 0FROM DOCS INNER JOIN MOVEMENT ON DOCS.DocID=MOVEMENT.DocWHERE 0=IsDraft AND"," [PrimeCost]>0 {fa.getFilter(\"Dates\", \"iif(GSDate2 Is Null,GSDate,GSDate2)\")} {$3} {$2} GROUP BY {$1}UNION ALL SELECT {$1} AS [Ag], 0, 0, Sum(SumPayOut), 0 FROM {$4}WHERE Cash.PayType<>'zp' {fa.getFilter(\"Dates\",\"PayDate\")} {$3} {$2}GROUP BY {$1}U","hd F"],["SYВкПл","query","","[ico]/local/img/profit.png[/ico] Обороты: Прибыль по оплатам",22,"","NION ALL SELECT {$1} AS [Ag], 0, 0, 0, Sum(SumPayIn) FROM {$4}WHERE Cash.PayType='zp' {fa.getFilter(\"Dates\",\"PayDate\")} {$3} {$2}GROUP BY {$1}) AS Tmp GROUP BY Ag ORDER BY 2 DESC ","","hd F"],["SYВкПл","query","","Обороты: Движение денег по КОП",9,"","{ opt( 1, \"КОП; !КОП+КД; Шахматка\")+opt(\"filter\", \"{moneyFilter(1)}\") + opt(2,\"!По месяцам\"), $9 = \"IIF(TmpCode Is NULL, CodeOp, TmpCode)\", \"\"}{ $1 = iif( 1==opt(1), \"iif( '873'={$9}, '120', iif( '874'={$9}, '14', iif( '876'={$9}, '160', iif( '875'={$","9}, '15', iif( '877'={$9}, '17', iif( '879'={$9}, '190', {$9}))))))\", \"{$9}\" ),$8 = aList( oParam( \"эк:Эл касса; де:Деньги; чк:Чеки; рс:Банк; эд:Эл деньги\"), (x,i,a) => (\" Round(Sum(iif(PayType='\" +a+ \"' AND io>0,io*S,0)),0) AS [_s_+\"+x+\"]\"), \",\")","hd F"],["SYВкПл","query","","Обороты: Движение денег по КОП",17,"",",$2 =\"PayID,PayType,PayDate,FirmPay,ClContractor,Agent, IIF(ClAssigning IS NULL,Notice,ClAssigning) AS NN, IIF(SumPayIn Is NULL,-1,1) AS io, Format( PayDate, 'yyyy-MM' ) AS M, Left( IIF(CodeDC Is Null, \" + $1 + \", CodeDC), {iif( fa.getFilter(\"CodeOp\")",",3,2)} ) AS kd, IIF(nz(SumPayIn) <> 0, '1 Приход', IIF({$9}<'6', '2 Прямые затраты', IIF( CodeDC < '6', '3 Косвенные затраты', '4 Общие затраты' ))) AS tp\",$2 =\"SELECT {$9} AS kop, \" + $2 + \", IIF(TmpCode Is NULL,IIF(SumPayIn Is NULL,SumPayOut, Su","hd F"],["SYВкПл","query","","Обороты: Движение денег по КОП",28,"","mPayIn ),PPSum) AS S FROM [Money] LEFT JOIN PartPay ON Money.PayID=PartPay.PPPayID WHERE PayType<>'zp' {sReplace(\"{moneyFilter}\", \"ns(CodeOp)\", \"{$9}\" )} UNION ALL SELECT CodeOp, \" + sReplace($2,\"{$9}\",\"CodeOp\") + \", IIF(SumPayIn Is NULL, -SumPayOut,"," SumPayIn ) FROM [Money] WHERE PayType<>'zp' {moneyFilter} AND nz(SumRest)<>0\",$3 = \"_g_КОП__kop Val\", $4 = \"_1_КОП__kop Val\", $5=iif(opt(2),\"M AS [_g_-Месяц],\"), \"\"}{opt(\"detail\",[\"_s_\", \"_t_\"],\"SELECT PayDate AS [_r_ДатаПл], IIF(iif(FirmPay IS NUL","hd F"],["SYВкПл","query","","Обороты: Движение денег по КОП",31,"","L,0,FirmPay)<= 3,ClContractor, convert(varchar,iif(FirmPay IS NULL,0,FirmPay))) AS [_r_Фирма__firm], PayID AS [_r_Платеж__pay], IIF(io>0,S,0) AS [_s_Приход], IIF(io<0,-S,0) AS [_s_Расход], kop AS [КОП__kop], kd AS [КД__kop], Agent AS [_r_Агент__ag], ","NN AS [Примечание]FROM ({$2}) AS Tmp WHERE [Fun] ORDER BY 1 DESC, 2, 3\",(r,f) => (log(r), log(f), iif( sIn( r[\"{$3}\"], \"ДОХОД\"), \"io>0\" , !r[\"{$3}\"], \"1=1\", !sTrim(r[\"{$3}\"]), \"kop Is NULL\" , iif(1==opt(1), \"kd\", \"kop\") + \" LIKE \" + sSql( sTag2( r[","hd F"],["SYВкПл","query","","Обороты: Движение денег по КОП",1421,"","\"{$4}\"] || r[\"{$3}\"]) + \"%\"))+ iif( sIn(f,\"[kop]\"), \" AND kd LIKE\" + sSql( sTag2(f) + \"%\") + iif( !sIn( r[\"{$3}\"], \"ДОХОД\"), \" AND io<0\") )+ iif( sIn(f,\"-\"), \" AND io<0\", sIn(f,\"+\"), \" AND io>0\", \"\")+ iif( sIn(f,\"Эл деньги\"), \" AND 'эд'=PayType\", sIn(f",",\"Эл касса\"), \" AND 'эк'=PayType\", sIn(f,\"Деньги\"), \" AND 'де'=PayType\", sIn(f,\"Чеки\"), \" AND 'чк'=PayType\",sIn(f,\"Банк\"), \" AND 'рс'=PayType\", \"\")+ iif( sIn(f,[\"1 \",\"2 \",\"3 \",\"4 \"]), \" AND tp=\" + sSql(f))+ iif(opt(2),\" AND M=\" + sSql( sTag2(r[\"_g_-Ме","hd F"],["SYВкПл","query","","Обороты: Движение денег по КОП",1423,"","сяц\"])) ))), \"\"}{ icase( opt(1), 2, \"SELECT {$5} IIF(io>0, '- ДОХОД -',Left(kop,2)) AS [{$3}], IIF(io>0,'', kop) AS [{$4}], iif(kd>'5',Left(kd,1),kd) AS [_t_КД__kop], Round(Sum(io*S),0) AS [_s_Итого] FROM ({$2}) AS Tmp /*WHERE kd < '6' */GROUP BY"," kop,io,kd\" + iif(opt(2),\",M\"),1, \"SELECT {$5} Left(kd,2) AS [{$3}], kd AS [{$4}], tp AS [_t_tp], Round(Sum(io*S),0) AS [_s_Дельта] FROM ({$2}) AS Tmp GROUP BY kd,tp\" + iif(opt(2),\",M\"),0, \"SELECT {$5} Left(kop,2) AS [{$3}], kop AS [{$4}], {$8}, Rou","hd F"],["SYВкПл","query","","Обороты: Движение денег по КОП",1424,"","nd(Sum(io*S),0) AS [_s_Дельта], {sReplace($8,[\"+\",\"io>0\"],[\"-\",\"io<0\"])}FROM ({$2}) AS Tmp GROUP BY kop\" + iif(opt(2),\",M\"))}","","hd F"],["SYВкПл","query","","Остатки по счетам",46,"","{ opt( \"filter\", \"Date2,Company\"),$1 = \"IIf( PayType IN ('де','эк'), '-КАССА-', '[filial]' + Company + '[/filial]')\",$2 = \"IIf( PayType IN ('де','эк'), '[user]' + ns([User]) + '[/user]', 'рс ' + ClOurAcc)\",$3 = \"Round( Sum( nz( SumPayIn) - nz( SumPay","Out)), 0)\", \"\"}SELECT {$1} AS [_g_Филиал], PayType AS [Тип],{$2} AS [_1_Счет], '(r)=>( dbHash(db, \"ourBank\", sSplit( r[\"_1_Счет\"], \" \", -1), \"BankName\") )' AS [_v_Банк],{$3} AS [_s_Остаток]FROM [Money] WHERE PayType <> 'zp' {fa.getFilter(\"Date2\"","hd"],["SYВкПл","query","","Остатки по счетам",93,"",",\"PayDate\")} {fa.getFilter(\"Company\",\"Company\")}GROUP BY {$1}, {$2}, PayTypeHAVING {$3}<>0ORDER BY 1,2","","hd"],["SYВкПлИм","import",10,"[ico]add[/ico] Добавить [CEFZ]",1623,"","money.NewItem(-1,0)","","CEFZ"],["SYВкПлИм","import",11,"[ico]copy[/ico] Копировать",1624,"","money.NewItem(-1,1)","","CEFZ"],["SYВкПлИм","import",18,"[ico]check[/ico] Пробить чек [CEF]",1625,"","money.Current(-1,0, () => (atol.KKT('money.KKT','Аванс','money')))","","CEF"],["SYВкПлИм","import",61,"[ico]love-for-money[/ico] ЗП: Проценты",1619,"","{iif(db.isAdmin(\"ZV\") || aIn(['SYСо40','SYСо50','SYСо80'],sLeft(fa.getAgent(db.User,'GSID'),6)),\"setPlugin('/jFabula/forms/interest.html', elID('gf.Agent').value || 'Все', 'Проценты')\")}","","ZFV"],["SYВкПлИм","import",81,"[ico]xls[/ico] Список: Вывод в Excel",1620,"","money.tbl.ToExcel(-1)","","CEFZ"],["SYВкПлИм","import",82,"[ico]print[/ico] Список: Печать",1621,"","money.tbl.Print()","","CEFZ"],["SYВкПлИм","import",97,"[ico]merge[/ico] Слить платежи",1452,"","money.Merge(this)","","CEZF"],["SYВкПлИм","import",98,"[ico]del[/ico] Удалить",1622,"","money.DelItem(-1)","","CEFZ"],["SYВкПлХФ","[red]Ошибки[/red]","","Задвоение номера []",88,"","PayID IN (SELECT PayID FROM [MoneyAll] GROUP BY PayID HAVING Count(*)>1 )","",""],["SYВкПлХФ","[red]Ошибки[/red]","","Можно слить банк,чеки, эл деньги []",82,"","{ $1= \"ClDocNum, PayType, ExtCode, ClContractor, Company, Agent, ClOurAcc, ClAssigning, Notice\", \"\" }/*CodeOp, CodeDC, DocDC, *//*AVR1=True AND*/ PayType IN ('чк','эд','рс') AND ns(CodeOp) < '9' AND PayDate < DateAdd('d', -7, Date())AND PayDate IN ( ","Select PayDate From Bank As Tmp Where ns(CodeOp) < '9' /*AND AVR1=True*/ {moneyMerge(\"{$1}\")} ) ","d"],["SYВкПлХФ","[red]Ошибки[/red]","","Можно слить кассу []",40,"","{ $1 = \"CodeOp, ExtCode, CodeDC, DocDC, [User], ClContractor, Company, Agent, Notice\", \"\" }(CodeOp is NULL OR AVR1=True OR Left(CodeOp,2) IN ('61','62','66') ) AND PayType IN ('де')/*AND ns(CodeOp) < '9' AND PayDate < DateAdd('d', -7, Date())*/AND P","ayDate IN ( Select PayDate From Cash As Tmp Where ns(CodeOp) < '9' {moneyMerge(\"{$1}\")} ) ","d"],["SYВкПлХФ","[red]Ошибки[/red]","","Можно слить проценты []",117,"","{ $2 = \"CodeOp, CodeDC, DocDC, DateDelivery, ClContractor, Company, Agent, ExtCode\", \"\"}PayType='zp' AND CodeOp < '9' AND ExtCode > ''AND PayDate IN ( SELECT PayDate FROM Cash As Tmp {moneyMerge(\"{$2}\")} ) ","","d"],["SYВкПлХФ","[red]Ошибки[/red]","","Неправильный остаток []",86,"","PayType='zp' AND 0 <> round( nz(SumRest) - nz(SumPayIn) + nz(SumPayOut), 2) AND PayID NOT LIKE '--%'ORPayType<>'zp' AND 0 <> Round( nz(SumRest) - iif( SumPayIn Is Null, nz(SumPayOut) , nz(SumPayIn) ) + (SELECT Sum(PPSum) FROM PartPayALL WHERE PPPayID=PayID), 2)","",""],["SYВкПлХФ","[red]Ошибки[/red]","","Несовпадение Контрагента, ФИО, Филиала []",84,"","PayID IN (SELECT PPPayID FROM PartPay INNER JOIN DOCS ON PartPay.PPDocID=DOCS.DocID WHERE DOCS.FirmContract<>FirmPay OR FirmContract<=3 AND FirmPay<=3 AND Person<>ClContractor AND ClContractor>'' OR DOCS.Company<>[Money].Company)","",""],["SYВкПлХФ","[red]Ошибки[/red]","","Плохой номер платежа []",92,"","PayID IN (SELECT PayID FROM Money WHERE PayType IN ('де','эк') AND Tbl<>1 OR PayType IN ('рс','чк','эд') AND Tbl<>2 OR 10 <> Len(PayID)) /* OR Year(PayDate)=Year( Date() ) AND Right(PayID,5) > '6' */","","d"],["SYВкПлХФ","formula","","moneyMerge",81,"","{$0=\"P[1]\" || \"CodeOp\", \"\"}GROUP BY {$0} , PayDate, FirmPay, iif( SumPayIn Is Null, -1, 1) HAVING Count( * ) > 1 AND nz(FirmPay) = nz([Money].FirmPay){ aList( sSplit($0), (r) => ( \"\\n AND ns(\" + r + \") = ns([Money].\" + r + \") \" )) } ","","d"],["SYСо","formula","","helpRights",39,""," [b]B[/b] | Бухгалтер [Б]|| [b]C[/b] | Кассир|| [b]D[/b] | Водитель [В]|| [b]F[/b] | Полные права [Ф]|| [b]L[/b] | Контроль [Л]|| [b]N[/b] | Только задачи|| [b]O[/b] | Наружка (размещение)|| [b]P[/b] | Звонки [Д]|| [b]U[/b] | Юрист [Ю]|| [b]V[/b] | Смотреть чужие %|| [b]W[/b] | Кладовщик [С]|| [b]S[/b] | Сборная печать|| [b]T[/b] | редактировать таймер|| [b]R[/b] | РА|| [b]Z[/b] | Зарплата","","hdf"],["SYСо","formula","","Стикер Сотрудник",1444,"","{ $9 = fa.getAgent(db.User,\"GSID\"),\"\"}