home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ftp.texkom.ru
/
ftp.texkom.ru.tar
/
ftp.texkom.ru
/
kkm1
/
PRICE2ATOL.PRG
< prev
Wrap
Text File
|
2007-07-30
|
2KB
|
88 lines
LOCAL lnFile,lcTable,lcPathToPrice,lcErrorString,lcLogFile,lcIniFile,lcRarFile,lcBasePath,lcTempDir
IF FILE('k_kodtov.dbf')
lcBasePath='_'+GETWORDNUM(LOCFILE('k_kodtov.dbf'),2,'\')
ELSE
lcBasePath=''
ENDIF
lnFile=FCREATE(ADDBS(SYS(2023))+'price2kkm'+lcBasePath+'.work')
IF lnFile<0
WAIT WINDOW '╧≡επ≡α∞∞α ≤µσ τα∩≤∙σφα!' TIMEOUT 3
RETURN .F.
ENDI
_SCREEN.CAPTION='▌Ω±∩ε≡≥ ∩≡αΘ±α φα Ωα±±√'
lcLogFile='price2kkm.log'
lcIniFile='D:\Mag\Z\KKM\Price2atol.ini'
lcPathToPrice=ADDBS(GetIni(lcIniFile,'Setting','╩≤Σα Γ√ΩδαΣ√Γα≥ⁿ ∩≡αΘ±','c:\',.T.))
lnMinNacen=VAL(GetIni(lcIniFile,'Setting','╠ΦφΦ∞αδⁿφα φα÷σφΩα %','15',.T.))
lnPriceMode=VAL(GetIni(lcIniFile,'Setting','╨σµΦ∞ ⌠ε≡∞Φ≡εΓαφΦ ∩≡αΘ±α','0',.T.))
*!* lcFlagImport=GetIni(lcIniFile,'Setting','╘δαπ ταπ≡≤τΩΦ','pos_f.spr',.T.)
lcFileImport=GetIni(lcIniFile,'Setting','╘αΘδ ταπ≡≤τΩΦ','pos.spr',.T.)
*!* lcPath=GetIni(lcIniFile,'Setting','─Φ≡σΩ≥ε≡Φ εß∞σφα Ωα±±√ '+TRANSFORM(nKas),"\\cash"+TRANSFORM(nKas)+"\exchg\",.T.)
IF !safeuse('k_kodtov')
lcErrorString='╬°ΦßΩα ε≥Ω≡√≥Φ ΩεΣΦ⌠ΦΩα≥ε≡α'
ENDIF
IF !safeuse('m_rezerv')
lcErrorString='╬°ΦßΩα ε≥Ω≡√≥Φ ≡στσ≡Γα'
ENDIF
IF !EMPTY(lcErrorString)
STRTOFILE(TTOC(DATETIME())+' '+lcErrorString+CHR(13),lcLogFile,1)
RETURN .F.
ENDIF
SELECT kodtov,SUM(kolvo) kolvores FROM m_rezerv GROUP BY 1 INTO CURSOR rezerv
SELE k.kodtov,k.NAME,k.artikul,k.cenar,k.kolvoost+k.kolvoostz-NVL(r.kolvores,0)+00000 kolvoost,;
IIF(sale OR (1-cenaz/cenar)*100<lnMinNacen,.T.,.F.) AS sale,IIF(sale,cenar,ROUND(cenaz*(1+lnMinNacen/100),2)) AS mincena;
FROM k_kodtov k LEFT JOIN rezerv r ON k.kodtov=r.kodtov;
order by 1;
WHERE k.inprice and k.cenar>0 and k.kolvoost+k.kolvoostz-NVL(r.kolvores,0)>0 INTO CURSOR price
USE IN k_kodtov
USE IN rezerv
SET TALK OFF
SET TEXTMERGE ON NOSHOW
SET TEXTMERGE DELIMITERS TO
SET TEXTMERGE TO (ADDBS(lcPathToPrice)+lcFileImport)
\\##@@&&
\#
\$$$DELETEALLWARES
\$$$REPLACEQUANTITY
SELECT price
SCAN
reccounter('╘ε≡∞Φ≡εΓαφΦσ ±∩≡αΓε≈φΦΩα')
\<<price.kodtov>>;
\\<<price.kodtov>>;
\\<<ALLTRIM(STRTRAN(LEFT(price.name,100),';',','))>>;
\\<<ALLTRIM(STRTRAN(padr(name,50) + ' ' + alltrim(padr(artikul,13)),';',','))>>;
\\<<TRANSFORM(price.cenar)>>;
\\<<TRANSFORM(price.kolvoost)>>;
\\0;
\\0;
\\<<TRANSFORM(price.mincena)>>;
\\0;
\\0;
\\0;
\\0;
\\1;
\\0;
\\0;
\\1;
\\1;
\\0;
\\;
\\;
\\;
\\;
\\;
\\;
\\<<ALLTRIM(LEFT(STRTRAN(price.artikul,';',','),20))>>;
ENDS
SET TEXTMERGE TO
wait clear
FCLOSE(lnFile)