147 files changed, 55964 insertions, 55946 deletions
diff --git a/tvapi/libtv/tv/CTvBooking.cpp b/tvapi/libtv/tv/CTvBooking.cpp index 1ad45db..ad696f3 100644 --- a/tvapi/libtv/tv/CTvBooking.cpp +++ b/tvapi/libtv/tv/CTvBooking.cpp @@ -1,162 +1,162 @@ - -#include "CTvBooking.h" -#include "CTvDatabase.h" - -#ifdef LOG_TAG -#undef LOG_TAG -#define LOG_TAG "CTvBooking" -#endif -int CTvBooking::InitFromCursor(CTvDatabase::Cursor &c) -{ - int col; - - col = c.getColumnIndex("db_id"); - this->id = c.getInt(col); - - col = c.getColumnIndex("db_srv_id"); - this->programId = c.getInt(col); - - col = c.getColumnIndex("db_evt_id"); - this->eventId = c.getInt(col); - - col = c.getColumnIndex("flag"); - this->flag = c.getInt(col); - - col = c.getColumnIndex("status"); - this->status = c.getInt(col); - - col = c.getColumnIndex("repeat"); - this->repeat = c.getInt(col); - - col = c.getColumnIndex("start"); - this->start = (long)c.getInt(col); - - col = c.getColumnIndex("duration"); - this->duration = (long)c.getInt(col) ; - - col = c.getColumnIndex("srv_name"); - this->progName = c.getString(col); - - col = c.getColumnIndex("evt_name"); - this->evtName = c.getString(col); - - return 0; -} - -int CTvBooking::selectByID(int id, CTvBooking &CtvBook) -{ - CTvDatabase::Cursor c; - String8 sql; - - sql = String8("select * from booking_table where booking_table.db_evt_id = ") + String8::format("%d", id); - CTvDatabase::GetTvDb()->select(sql.string(), c); - if (c.moveToFirst()) { - CtvBook.InitFromCursor(c); - } else { - c.close(); - return -1; - } - - c.close(); - return 0; -} - -int CTvBooking::getBookedEventList(Vector<sp<CTvBooking> > &vBv) -{ - String8 cmd; - - cmd = String8("select * from booking_table order by start"); - - CTvDatabase::Cursor c; - int ret = CTvDatabase::GetTvDb()->select(cmd, c); - - if (c.moveToFirst()) { - do { - vBv.add(new CTvBooking(c)); - } while (c.moveToNext()); - - - } else { - c.close(); - return -1; - } - - c.close(); - return 0; - -} - -int CTvBooking::bookProgram(CTvProgram &prog, CTvEvent &evt) -{ - String8 cmd; - String8 progName = String8(prog.getName()); - String8 evtName = String8(evt.getName()); - - - /*book this program*/ - cmd = String8("insert into booking_table(db_srv_id, db_evt_id, srv_name, evt_name,") - + String8("start,duration,flag,status,file_name,vid_pid,vid_fmt,aud_pids,aud_fmts,aud_languages,") - + String8("sub_pids,sub_types,sub_composition_page_ids,sub_ancillary_page_ids,sub_languages,") - + String8("ttx_pids,ttx_types,ttx_magazine_numbers,ttx_page_numbers,ttx_languages, other_pids,from_storage,repeat)") - + String8("values(") + String8::format("%d,", prog.getID()) + String8::format("%d,", evt.getEventId()) + progName.string() + String8(",") + evtName.string() - + String8::format("%d,", evt.getStartTime()) + String8::format("%d,", evt.getEndTime() - evt.getStartTime()) + String8::format("%d,", flag) - + String8::format("%d,", status) + String8(",") + String8::format("%d,", prog.getVideo()->getPID()) + String8::format("%d,", prog.getVideo()->getFormat()) - + String8::format("%d,", prog.getAudio(0)->getPID()) + String8::format("%d,", prog.getAudio(0)->getFormat()) + prog.getAudio(0)->getLang().string() - + String8(" , , , , , , , , , , , , ,)"); - - CTvDatabase::GetTvDb()->exeSql(cmd.string()); - - return 0; -} - -int CTvBooking::deleteBook(int evtIdFlag) -{ - String8 cmd; - - cmd = String8("delete from booking_table where db_evt_id=") - + String8::format("%d", evtIdFlag); - - CTvDatabase::GetTvDb()->exeSql(cmd.string()); - - return 0; -} - -int CTvBooking::bookEvent(int evtId, bool bBookFlag) -{ - String8 cmd; - - cmd = String8("update evt_table set sub_flag=") + String8::format("%d", bBookFlag) - + String8(" where db_id=") + String8::format("%d", evtId); - - CTvDatabase::GetTvDb()->exeSql(cmd.string()); - - if (true == bBookFlag) { - CTvEvent evt; - CTvEvent::selectByID(evtId, evt); - - CTvProgram prog; - CTvProgram::selectByID(evt.getProgramId(), prog); - - bookProgram(prog, evt); - } else { - deleteBook(evtId); - } - - return 0; - -} - -CTvBooking::CTvBooking(CTvDatabase::Cursor &c) -{ - InitFromCursor(c); -} - -CTvBooking::CTvBooking() -{ -} - -CTvBooking::~CTvBooking() -{ -} - - +
+#include "CTvBooking.h"
+#include "CTvDatabase.h"
+
+#ifdef LOG_TAG
+#undef LOG_TAG
+#define LOG_TAG "CTvBooking"
+#endif
+int CTvBooking::InitFromCursor(CTvDatabase::Cursor &c)
+{
+ int col;
+
+ col = c.getColumnIndex("db_id");
+ this->id = c.getInt(col);
+
+ col = c.getColumnIndex("db_srv_id");
+ this->programId = c.getInt(col);
+
+ col = c.getColumnIndex("db_evt_id");
+ this->eventId = c.getInt(col);
+
+ col = c.getColumnIndex("flag");
+ this->flag = c.getInt(col);
+
+ col = c.getColumnIndex("status");
+ this->status = c.getInt(col);
+
+ col = c.getColumnIndex("repeat");
+ this->repeat = c.getInt(col);
+
+ col = c.getColumnIndex("start");
+ this->start = (long)c.getInt(col);
+
+ col = c.getColumnIndex("duration");
+ this->duration = (long)c.getInt(col) ;
+
+ col = c.getColumnIndex("srv_name");
+ this->progName = c.getString(col);
+
+ col = c.getColumnIndex("evt_name");
+ this->evtName = c.getString(col);
+
+ return 0;
+}
+
+int CTvBooking::selectByID(int id, CTvBooking &CtvBook)
+{
+ CTvDatabase::Cursor c;
+ String8 sql;
+
+ sql = String8("select * from booking_table where booking_table.db_evt_id = ") + String8::format("%d", id);
+ CTvDatabase::GetTvDb()->select(sql.string(), c);
+ if(c.moveToFirst()) {
+ CtvBook.InitFromCursor(c);
+ } else {
+ c.close();
+ return -1;
+ }
+
+ c.close();
+ return 0;
+}
+
+int CTvBooking::getBookedEventList(Vector<sp<CTvBooking> > &vBv)
+{
+ String8 cmd;
+
+ cmd = String8("select * from booking_table order by start");
+
+ CTvDatabase::Cursor c;
+ int ret = CTvDatabase::GetTvDb()->select(cmd, c);
+
+ if(c.moveToFirst()) {
+ do {
+ vBv.add(new CTvBooking(c));
+ } while(c.moveToNext());
+
+
+ } else {
+ c.close();
+ return -1;
+ }
+
+ c.close();
+ return 0;
+
+}
+
+int CTvBooking::bookProgram(CTvProgram &prog, CTvEvent &evt)
+{
+ String8 cmd;
+ String8 progName = String8(prog.getName());
+ String8 evtName = String8(evt.getName());
+
+
+ /*book this program*/
+ cmd = String8("insert into booking_table(db_srv_id, db_evt_id, srv_name, evt_name,")
+ + String8("start,duration,flag,status,file_name,vid_pid,vid_fmt,aud_pids,aud_fmts,aud_languages,")
+ + String8("sub_pids,sub_types,sub_composition_page_ids,sub_ancillary_page_ids,sub_languages,")
+ + String8("ttx_pids,ttx_types,ttx_magazine_numbers,ttx_page_numbers,ttx_languages, other_pids,from_storage,repeat)")
+ + String8("values(") + String8::format("%d,", prog.getID()) + String8::format("%d,", evt.getEventId()) + progName.string() + String8(",") + evtName.string()
+ + String8::format("%d,", evt.getStartTime()) + String8::format("%d,", evt.getEndTime() - evt.getStartTime()) + String8::format("%d,", flag)
+ + String8::format("%d,", status) + String8(",") + String8::format("%d,", prog.getVideo()->getPID()) + String8::format("%d,", prog.getVideo()->getFormat())
+ + String8::format("%d,", prog.getAudio(0)->getPID()) + String8::format("%d,", prog.getAudio(0)->getFormat()) + prog.getAudio(0)->getLang().string()
+ + String8(" , , , , , , , , , , , , ,)");
+
+ CTvDatabase::GetTvDb()->exeSql(cmd.string());
+
+ return 0;
+}
+
+int CTvBooking::deleteBook(int evtIdFlag)
+{
+ String8 cmd;
+
+ cmd = String8("delete from booking_table where db_evt_id=")
+ + String8::format("%d", evtIdFlag);
+
+ CTvDatabase::GetTvDb()->exeSql(cmd.string());
+
+ return 0;
+}
+
+int CTvBooking::bookEvent(int evtId, bool bBookFlag)
+{
+ String8 cmd;
+
+ cmd = String8("update evt_table set sub_flag=") + String8::format("%d", bBookFlag)
+ + String8(" where db_id=") + String8::format("%d", evtId);
+
+ CTvDatabase::GetTvDb()->exeSql(cmd.string());
+
+ if(true == bBookFlag) {
+ CTvEvent evt;
+ CTvEvent::selectByID(evtId, evt);
+
+ CTvProgram prog;
+ CTvProgram::selectByID(evt.getProgramId(), prog);
+
+ bookProgram(prog, evt);
+ } else {
+ deleteBook(evtId);
+ }
+
+ return 0;
+
+}
+
+CTvBooking::CTvBooking(CTvDatabase::Cursor &c)
+{
+ InitFromCursor(c);
+}
+
+CTvBooking::CTvBooking()
+{
+}
+
+CTvBooking::~CTvBooking()
+{
+}
+
+
|