کلینیک فوق تخصصی اکسس ( کاربرد vba در اکسس )

کلینیک فوق تخصصی اکسس ( کاربرد vba در اکسس )

به اشتراک گذاری اطلاعات کسب شده در اکسس از سایت آفیس و سایت های تخصصی خارجی
کلینیک فوق تخصصی اکسس ( کاربرد vba در اکسس )

کلینیک فوق تخصصی اکسس ( کاربرد vba در اکسس )

به اشتراک گذاری اطلاعات کسب شده در اکسس از سایت آفیس و سایت های تخصصی خارجی

SMS in Alphabet mode



SMS DELIVER:
SCA-PDU TYPE-OA-PID-DCS-SCTS-UDL-UD
SMS-SUBMIT:
SCA-PDU TYPE-MR-DA-PID-DCS-VP-UDL-UD




Mode Alphabet : 160  Character in part 1 ( Ascii 140,binary septet 160 )

Text : Salam

1-Ascii text to Hexadecimal

53 61 6C 61 6D

?H53

2-Decimal to binary




83÷2=41 Reminder 1

41÷2=20 Reminder 1

20÷2=10 Reminder 0

10÷2=5 Reminder 0

5÷2=2 Reminder 1

2÷2=1 Reminder 0

1÷2=0 Reminder 1

Hex53Decimal83=1010011

Hex61Decimal97=1100001

Hex6CDecimal108=1101100

Hex61Decimal97=1100001

Hex6DDecimal109=1101101



3-Change 8 bit to 7 bit  : 10001100>0001100

Seperate 7 digits from Right 

4-Reverse Binary from last hex to the first

1101101 1100001 1101100 1100001 1010011

5-how many 0 reqired?  5×(7+1)-5×7=5

Add 5 Zero to the left 

00000 1101101 1100001 1101100 1100001 1010011

6-Change binary  to hex



0000011011011100001110110011000011010011


0110=0×2^(3)+1×2^(2)+1×2^(1)+0×2^(0)=6


0D33D3






7-Reverse Hex

D3303BDC06



SMS SUBMIT

00311E08810100353800000A05D3303BDC06


MR(Message refrence)=hex(1E):decimal(30)

DCS(Data coding scheme):00

Validity : 0A

UDL(User data length) : 05

UD (User data) : D3303BDC06




Packed




0110001 0110010 0110011 0110100 0110101 0110110 0110111 0111000

Reverse binary:

0111000 0110111 0110110 0110101 01101000110011 0110010 0110001

Add Zero to the first 8×(7+1)-8×7=8

000000000111000 0110111 0110110 0110101 01101000110011 0110010 0110001

Seperate 8 digits 8 digits :

00000000 : 00

01110000 : 70

11011101 : DD

10110011 : B3

01010110 : 56

10001100 : 8C

11011001 : D9

00110001 : 31

Reverse Hex : 

31 D9 8C 56 B3 DD 70 00


0031000881010035850000000831D98C56B3DD7000

Message : 12345678






-Hex

Hex Len:16

54 61 73 68 20 4D 65 6E 65 20 53 69 6C 65 73 68

-Septet

1010100 1100001 1110011 1101000 0100000 

1001101 1100101 1101110 1100101 0100000

1010011 1101001 1101100 1100101 1110011

1101000

-Reverse binary

1101000 1110011 1100101 1101100 1101001

1010011 0100000 1100101 1101110 1100101

1001101 0100000 1101000 1110011 1100001

1010100

-16×(7+1)-16×7=16

-Required Zero at the first =16

8 digits separation

00000000: 00

00000000:00

11010001:D1

11001111:CF

00101110:2E

11001101:CD

00110100:34

11010000:D0

01100101:65

11011101:DD

10010110:96

01101010:6A

00001101:0D

00011100:1C

11110000:F0

11010100:D4

-Revers Hex

D4 F0 1C 0D 6A 96 DD 65 D0 34 CD 2E CF D1 00 00


00310008810100358500000B10D4F01C0D6A96DD65D034CD2ECFD10000

UDL=16(decimal)=10(Hex)

UD=D4F01C0D6A96DD65D034CD2ECFD10000



SCA

Service Center Address information element

Telephone number of the Service Center

PDU Type

Protocol Data Unit

Type

 

MR

Message Reference

successive number (O. .255) of all SMS-SUBMIT Frames set by the MOBILE

OA

Originator Address

Address of the originating SME

DA

Destination Address

Address of the destination SME

PID

Protocol Identifier

Parameter showing the SMSC how to process the SM (as FAX, Voice etc)

DCS

Data Coding Scheme

Parameter identifying the coding scheme within the User Data (UD)

SCTS

Service Center Time Stamp

Parameter identifying time when the SMSC received the message

VP

Validity Period

Parameter identifying the time from where the message is no longer valid in the SMSC

UDL

User Data Length

Parameter indicating the length of the UD-field

UD

User Data

Data of the SM

RP

Reply Path

Parameter indicating that Reply Path exists

UDHI

User Data Header Indicator

Parameter indicating that the UD field contains a header

SRI

Status Report Indication

Parameter indicating if the SME has requested a status report

SRR

Status Report Request

Parameter indicating if the MS has requested a status report

VPF

Validity Period Format

Parameter indicating whether or not the VP field is present

MMS

More Messages to Send

Parameter indicating whether or not there are more messages to send

RD

Reject Duplicate

 

MTI

Message

Type

Indicator

Parameter describing the message type

00 means SMS-DELIVER

01 means SMS-SUBMIT




TPDU Types
TP-MTIdirectionmessage type
0 0MS → SCSMS-DELIVER-REPORT
0 0SC → MSSMS-DELIVER
0 1MS → SCSMS-SUBMIT
0 1SC → MSSMS-SUBMIT-REPORT
1 0MS → SCSMS-COMMAND
1 0SC → MSSMS-STATUS-REPORT
1 1anyReserved


SMS-DELIVER is used to deliver a message from SMSC to a mobile phone.


Bit fields in the first octet of SM-TL TPDU
bit(s)Meaning
1-0TP-Message-Type-Indicator (TP-MTI)
2TP-More-Messages-to-Send (TP-MMS) in SMS-DELIVER (0 = more messages)
2TP-Reject-Duplicates (TP-RD) in SMS-SUBMIT
3TP-Loop-Prevention (TP-LP) in SMS-DELIVER and SMS-STATUS-REPORT
4-3TP-Validity-Period-Format (TP-VPF) in SMS-SUBMIT (00 = not present)
5TP-Status-Report-Indication (TP-SRI) in SMS-DELIVER
5TP-Status-Report-Request (TP-SRR) in SMS-SUBMIT and SMS-COMMAND
5TP-Status-Report-Qualifier (TP-SRQ) in SMS-STATUS-REPORT
6TP-User-Data-Header-Indicator (TP-UDHI)
7TP-Reply-Path (TP-RP) in SMS-DELIVER and SMS-SUBMIT


According to above table ( PDU Type ) :  

Submit : MTI-RD-VPF-SRR-UDHI-RP

Deliver : MTI-MMS-LP-SRI-UDHI-RP



TP-SRI(only set by SMSC) :

0: a status report will not be returned to the SME

1: a status report will  be returned to the SME






00400881010035850008322131313121000B050003CC020106450648

SMS-SUBMIT
Bit:
0,1-MTI (00 : Deliver , 01 Submit )
2-RD ( Reject Duplicate )
3,4-VPF
0 0 VP field is not present
0 1 Reserved
1 0 VP field present an integer represented (relative)
1 1 VP field present an semi-octet represented (absolute)
5-SRR (Status report request)
0:A status report is not requested
1:A status report is requested
6-UDHI
When TP-UDHI has value 1, the TP-UD field starts with User Data Header
7-RP
0:Reply Path parameter is not set in this PDU
1:Reply Path parameter is set in this PDU

11=00010001

31=00110001

61=01100001


006100088101003585000809050003CC02010645
PDU  61 : 01100001
From the rightest digit : 
bit0,1:MTI:01:SMS-SUBMIT
bit 2:RD:0
bit 3,4:VP:00 Not Present
bit 5:SRR:1:report requested
bit6:UDHI:1:Present:050003CC0201
bit7:RP:0


0031000881010035850008BB020645
PDU 31 : 00110001
MTI : 01 : SMS-SUBMIT
-Different with PDU 61
From the rightest digit ( See Bold )
VP : 10 : Present : BB(21 Day validity)
UDHI : 0 : Not Present


0021000881010053850008020645
PDU  21 : 00100001
bit0,1 : 01 : MTI : SMS-SUBMIT
bit 5 : 1 : SRR : status report request
VP : not present
UDHI : not present

0025000881010035850008020645
SMSC:00 >Using Sms center number from cell phone
MR : Message refrence (Hex value) : 00
Usaully originated from SMSC and no need changing it from 00 to another
TO : 10005358 : 01003558
iff Odd Number then Add F to the last then reverse 2-digits from the left
PDU 25 : 00100101
bit0,1 : 01 : SMS-SUBMIT
bit2 : 1 : RD : Reject duplicate
bit3,4 : 00 : VP : not present
bit5 : 1 : SRR : status report requested
bit6 : 0 : UDHI : not present ( use in concatenated message : multi part )
bit 7 : 0 : RP : not present

00F5000881010035850008CC09050003BB04010645
VP:CC:84days
Data header:050003BB0401
UDL:09
UD:050003BB04010645
text: م
SMSC:00 (Use default center in cell)
PDU F5 : 11110101
bit0,1 : MTI : 01 : SMS-SUBMIT
bit2 : RD : 1
bit3,4 : VP : 10 : validity present
bit5 : SRR : 1 : status report requested
bit6 : UDHI : 1 : present ( Concatenated Message )
bit7 : RP : 1 :  present




there are 40, 44, and 60, there are additional header fields because it is a concatenated SMS. This means that the SMS is divided into parts and sent in segments, and then the modem/phone reassembles them. And there are headers for collecting the SMS parts




0021000881010035850008020645

SMS-SUBMIT:
SCA-PDU TYPE-MR-DA-PID-DCS-VP-UDL-UD

PDU TYPE

21=00100001






AT COMMAND : 

Sending in text mode

AT

>ATOK

AT+CMGF=1[ENTER]
Enter the destination phone number
AT+CMGS=”+61419879619”[ENTER]
Enter the text message and terminate it with “CTRL Z”
>hello[CTRL Z]




Baud Rate:19200 : bps
Data Bits : 8
Stop Bits : 1
Parity N : None

AT+CMGS=18 (actual pdu length)
>0011000A814091786991000001
05E8329BFD06[CTRL Z]

+CMGS: 12

OK 

To : 0419879619

Message : hello

PDU type : SMS-SUBMIT (11)

Refrence : 0 (00)

Validity : 10 minutes (01)

Data coding : SMS Default Alphabet

UDL : 05

UD : E8329BFD06



+CMGF: 0
OK
SMS message for is configured for PDU mode
Checking SMS Mode…
AT+CMGS=48

0011000881010035850000aa28D3E614D42CCFE7E17319342FBBE920B3FCDD0605A9A0E1BBDD0EBBC9206A794E2FCB5D


+CMGS: 23

OK


UDL:28

message : SMS Message sent from AT Command Tester.

Hex Value of message : 

534d53204d6573736167652073656e742066726f6d20415420436f6d6d616e64205465737465722e

Length : 40 (2digits)

UDL in alphabet mode is the length of septet before encoding to octet.

40decimal=28hex

40÷2=2 40-2×16=8 so 28



AT COMMAND : READ 


AT+CMGR=1 [ENTER]

+CMGR: 0,,24

07911614786007F0040B911604994743F400009930139100406B05E8329BFD06

OK










برای دفع سنگ کلیه  خربزه را تمیز شسته و با پوست و گوشت و تخم داخل مخلوط کن بریزید تا کامل میکس شود و روزی 2تا ۳ لیوان میل کنید .