00001
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011 #ifndef Commission_Check_HPP
00012 #define Commission_Check_HPP
00013
00014 #include "read_write_base.hpp"
00015
00016 class Commission_Check_Obj: public read_write_base
00017 {
00018 public:
00019 identifier Id;
00020 llong Affiliate;
00021 llong Promotion;
00022 string Ordered_Ids;
00023 oc_date Paid_Date;
00024 string Check_Number;
00025 string Notes;
00026 Commission_Check_Obj():read_write_base()
00027 ,Id(0LL)
00028 ,Affiliate(0LL)
00029 ,Promotion(0LL)
00030 ,Ordered_Ids("")
00031 ,Paid_Date( )
00032 ,Check_Number("")
00033 ,Notes("")
00034 {
00035
00036 data_name("Commission_Check");
00037
00038 addDXMap( new llongXfer("Id", &Id ));
00039 addDXMap( new llongXfer("Affiliate", &Affiliate ));
00040 addDXMap( new llongXfer("Promotion", &Promotion ));
00041 addDXMap( new stringXfer("Ordered_Ids", &Ordered_Ids ));
00042 addDXMap( new oc_dateXfer("Paid_Date", &Paid_Date ));
00043 addDXMap( new stringXfer("Check_Number", &Check_Number ));
00044 addDXMap( new stringXfer("Notes", &Notes ));
00045 }
00046
00047 virtual bool setCommission_Check_Orders( void )
00048 {
00049 bool bRet = false;
00050 ocString Ordered_Ids = this->Ordered_Ids;
00051 if( Ordered_Ids.length() )
00052 {
00053 ocString sql;
00054 ocString sqlStart = "insert into Commission_Check_Orders ("
00055 "Commission_Check,"
00056 "Ordered"
00057 ") values (";
00058 sqlStart.append(key());
00059 sqlStart += ",";
00060 Ordered_Ids.parseInit();
00061 while( !Ordered_Ids.endOfParse() )
00062 {
00063 sql = sqlStart;
00064 sql += Ordered_Ids.parse(",");
00065 sql += ")";
00066 bRet = cmd.execute(sql);
00067 if(!bRet) break;
00068 }
00069 sql = "update Ordered set Order_Status_Id = 3 where Id in (";
00070 sql += Ordered_Ids;
00071 sql += ")";
00072 cmd.execute(sql);
00073 }
00074
00075
00076 return bRet;
00077 }
00078 bool isupplemental( void )
00079 {
00080 setCommission_Check_Orders();
00081 return true;
00082 }
00083
00084
00085
00086
00087
00088
00089
00090
00091
00092
00093
00094
00095
00096
00097
00098 };
00099 #endif
00100
00101
00102