char* display_page(int *line_number, char *current_position) {
int count = 0;
while(count<ROW && *current_position!=EOF) {
current_position = display_row(line_number, current_position);
count++;
}
return current_position;
}
void main()
{
lcd_init();
while(1)
{
display_row(0,"qwerty");
lcd_cmd(0x18);
}
}
void text_view(char *filename){
FILE *fp;
long size;
char *buffer;
char *current_position;
char c;
int line_number = 1;
fp = fopen(filename, "rb");
if (fp==NULL) {
printf("debug_msg: file pointer is NULL...");
exit(-1);
}
size = get_file_size(fp);
printf("debug_msg: file size is ...%d\n", size);
buffer = (char *)malloc(size+1);
fread(buffer, 1, size, fp); // total number of bytes is size + 1
buffer[size] = EOF;
current_position = buffer;
current_position = display_page(&line_number, current_position);
do {
//printf("Enter - next page / Space - next row / ESC - terminate\r");
c = getch();
printf("\r");
switch(c) {
case ENTER:
/* print next page */
current_position = display_page(&line_number, current_position);
break;
case SPACE:
current_position = display_row(&line_number, current_position);
break;
case ESC:
/* terminate */
return;
default:
break;
}
}while(*current_position!=EOF);
}
unsigned int print_ticket(unsigned int source,unsigned int destination)
{
unsigned int final_amount =0,final_amount_cpy =0,fx =0,final_length_cpy =0,j,final_amount_length =0;
unsigned char final_disp[20],afx[5];
if(source > destination)
{
final_amount = (source - destination)*5;
}
if(destination>source)
{
final_amount = (destination - source)*5;
}
final_amount_cpy = final_amount;
final_disp[0] = 'R';
final_disp[1] = 's';
final_disp[2] = ':';
final_disp[3] = '1';
final_disp[4] = '*';
final_amount_length=10;
for(j=0;j<=final_amount_length;j++)
{
fx=final_amount_cpy%10;
afx[j]=inttochar(fx);
final_amount_cpy = final_amount_cpy/10;
}
final_length_cpy=final_amount_length;
for(j=0;j<=final_amount_length;j++)
{
final_disp[j+5]=afx[final_length_cpy-1];
final_length_cpy=final_length_cpy-1;
}
final_disp[final_amount_length+5] = '=';
final_length_cpy=final_amount_length;
for(j=0;j<=final_amount_length;j++)
{
final_disp[final_amount_length+6+j]=afx[final_length_cpy-1];
final_length_cpy=final_length_cpy-1;
}
DelayMs(2);
strcpypgm2ram((char*)LCDText, final_disp);
display_row(1);
//display_row(1,final_disp);
return final_amount;
}
int main(int argc, char *argv[]) {
int res;
int first_row = 1;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "rick",
"secret", "foo", 0, NULL, 0)) {
printf("Connection success\n");
res = mysql_query(&my_connection, "SELECT childno, fname, age FROM children WHERE age > 5");
if (res) {
fprintf(stderr, "SELECT error: %s\n", mysql_error(&my_connection));
} else {
res_ptr = mysql_use_result(&my_connection);
if (res_ptr) {
display_header();
while ((sqlrow = mysql_fetch_row(res_ptr))) {
if (first_row) {
display_header();
first_row = 0;
}
display_row();
}
if (mysql_errno(&my_connection)) {
fprintf(stderr, "Retrive error: %s\n",
mysql_error(&my_connection));
}
}
mysql_free_result(res_ptr);
}
mysql_close(&my_connection);
} else {
fprintf(stderr, "Connection failed\n");
if (mysql_errno(&my_connection)) {
fprintf(stderr, "Connection error %d: %s\n",
mysql_errno(&my_connection),
mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
int main(int argc,char *argv[])
{
int res;
/* Used to ensure we display the row header exactly once when
* data is successfully retrieved
*/
int first_row = 1;
mysql_init(&my_connection);
if(mysql_real_connect(&my_connection,"localhost","rick","secret","foo",0,NULL,0)){
printf("Connection success\n");
res = mysql_query(&my_connection,"SELECT childno,fname,age FROM children WHERE age > 5");
if(res)
printf("SELECT error: %s\n",mysql_error(&my_connection));
else{
res_ptr = mysql_use_result(&my_connection);
if(res_ptr){
printf("Retrieved %lu rows\n",(unsigned long)mysql_num_rows(res_ptr));
while((sqlrow = mysql_fetch_row(res_ptr))){
if(first_row){
display_header();
first_row = 0;
}
display_row();
}
if(mysql_errno(&my_connection)){
fprintf(stderr,"Retrive error:%s\n",mysql_error(&my_connection));
}
mysql_free_result(res_ptr);
}
}
mysql_close(&my_connection);
}else{
fprintf(stderr,"Connection failed\n");
if(mysql_errno(&my_connection)){
fprintf(stderr,"Connection error %d:%s\n",mysql_errno(&my_connection),mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
int main(int argc, const char *argv[])
{
int res;
int first_row = 1;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "linq", "linq", "rick", 0, NULL, 0)) {
printf("Connection success\n");
res = mysql_query(&my_connection,
"select childno, fname , age from children where age > 5");
if (res) {
printf("select error: %s\n", mysql_error(&my_connection));
} else {
res_ptr = mysql_use_result(&my_connection);
if (res_ptr) {
while ((sqlrow = mysql_fetch_row(res_ptr))) {
if (first_row) {
display_header();
first_row = 0;
}
display_row();
}
if (mysql_errno(&my_connection)) {
fprintf(stderr, "Retrived error: %s\n", mysql_error(&my_connection));
}
mysql_free_result(res_ptr);
}
}
mysql_close(&my_connection);
} else {
fprintf(stderr, "Connection failed\n");
if (mysql_errno(&my_connection)) {
fprintf(stderr, "Connection error %d: %s\n",
mysql_errno(&my_connection), mysql_error(&my_connection));
}
}
return 0;
}
/**
* Show command
*/
void command_show(char* line) {
char cmd[MAX_BUFFER];
char key[MAX_BUFFER];
char func[MAX_BUFFER];
char arg1[MAX_BUFFER];
char arg2[MAX_BUFFER];
int argc = sscanf(line, "%s %s %s %s %s", cmd, key, func, arg1, arg2);
if (argc < 2) {
goto invalid;
}
MATRIX_GUARD(key);
if (argc == 2) {
display(m);
return;
}
const uint32_t v1 = atoll(arg1) - 1;
if (v1 >= g_order) {
goto invalid;
}
if (argc == 4 && strcasecmp(func, "row") == 0) {
display_row(m, v1);
} else if (argc == 4 && strcasecmp(func, "column") == 0) {
display_column(m, v1);
} else if (argc == 5 && strcasecmp(func, "element") == 0) {
const uint32_t v2 = atoll(arg2) - 1;
if (v2 >= g_order) {
goto invalid;
}
display_element(m, v1, v2);
}
return;
invalid:
puts("invalid arguments");
}
int main(void)
{
MYSQL my_connection;
MYSQL_RES *res_ptr;
MYSQL_ROW sqlrow;
int res;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection,"localhost","rick","secret","practicedb", 0, NULL, 0))
{
printf("Connection success\n");
res = mysql_query(&my_connection,"SELECT childno, fname, age FROM children WHERE fname = 'Ann' ");
/* by typing mistakenly something from the above line , eg childrenn , we can get various SELECT error: */
if (res) { printf("SELECT error %d: %s\n",mysql_errno(&my_connection), mysql_error(&my_connection)); }
else
{
res_ptr = mysql_use_result(&my_connection);
if (res_ptr)
{
while ((sqlrow = mysql_fetch_row(res_ptr)))
{
printf("Fetched data , one row at a time ...\n");
//display_row(&my_connection , sqlrow ); //use this line for the alternate definition case
display_row(my_connection , sqlrow );
}
if (mysql_errno(&my_connection))
{ fprintf(stderr, "Retrive error %d: %s\n",mysql_errno(&my_connection), mysql_error(&my_connection)); }
mysql_free_result(res_ptr);
}
}
mysql_close(&my_connection);
}
else
{
fprintf(stderr, "Connection failed\n");
if (mysql_errno(&my_connection))
{ fprintf(stderr,"Connection error %d: %s\n",mysql_errno(&my_connection), mysql_error(&my_connection)); }
}
return EXIT_SUCCESS;
}
int main(int argc, char *argv[], char *envp[])
{
int i;
int res;
int status;
const char *userp = getenv("USER"); /* vem ?r inloggad? */
char databas[25]="olfix";
char usr[21]; /* userid 20070214 utökat från 15 till 21 tecken */
char temp1[]="SELECT INKRADREG.INKORDNR, INKORDRADNR,INKREG.LEVNR,INKRADREG.ARTIKELNR,ARBENEMNING1,BEKREFTKOD,BESTANTAL,LEVERERAT,RESTNOTERAT,INKPRIS,LEVVECKA,RESTNOTERAT * INKPRIS RADSUM from INKRADREG,INKREG,ARTIKELREG WHERE INKREG.INKORDNR = INKRADREG.INKORDNR AND INKRADREG.ARTIKELNR = ARTIKELREG.ARTIKELNR AND RESTNOTERAT > \"0\" ORDER BY INKORDNR,INKORDRADNR ";
char temp5[500]="";
/* for (i=0;i< argc;i++){
fprintf(stderr,"INKLST argv%d = %s\n",i,argv[i]);
}
*/
/* fprintf(stderr,"argc=%d\n",argc); */
/* if (argc<2){
fprintf(stderr,"Error: Ink?psordernr saknas!\n");
exit(0);
}
strncpy(inkordnr,argv[1],strlen(argv[1]));
*/
/* ================================================================================ */
/* Val av databas, START */
/* ================================================================================ */
status = which_database(envp);
if (status != 0)
exit(status);
strncpy(usr,userp,sizeof(usr)); /* Den inloggades userid 20070214 */
/* fprintf(stderr,"status=%d ANTARG=%d len(database)=%d\n",status,ANTARG,strlen(database)); */
if (argc < ANTARG+1){
if (strlen(database)!= 0){
strncpy(databas,database,sizeof(databas)); /* 2005-02-23 */
}else{
strncpy(databas,"olfixtst",15); /* olfixtst = testf?retag */
}
}else{
if (strlen(argv[ANTARG]) != 0){
if (strncmp(argv[ANTARG],"99",2)==0){
strncpy(databas,"olfixtst",15);
}else{
strncpy(databas,argv[ANTARG],15);
}
}
}
/* fprintf(stderr,"ANTARG=%d,argv[ANTARG]=%s\n",ANTARG,argv[ANTARG]); */
/* Om usr (userid) b?rjar p? 'test' eller 'prov' anv?nd databas 'olfixtst' */
if (strncmp(usr,"test",4)==0 || strncmp(usr,"prov",4)==0 ) {
strncpy(databas,"olfixtst",15);
}
/* fprintf(stderr,"Databas=%s\n",databas); */
/* ================================================================================ */
/* Val av databas, END! */
/* ================================================================================ */
strncpy(temp5,temp1,strlen(temp1));
/* SELECT INKORDNR, INKORDRADNR,INKRADREG.ARTIKELNR,ENHET,BESTANTAL,LEVERERAT,RESTNOTERAT,INKPRIS,LEVVECKA,TORDNR,OPNR,ARBENEMNING1 from INKRADREG,ARTIKELREG WHERE INKRADREG.ARTIKELNR = ARTIKELREG.ARTIKELNR AND INKRADREG.INKORDNR = 99999 ORDER BY INKORDRADNR */
/* fprintf(stderr,"temp5=%s\n",temp5); */
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "olfix", "olfix", databas, 0, NULL, 0)){
/* fprintf(stdout,"INKLST_Connection success\n"); */
res = mysql_query(&my_connection,temp5);
/* fprintf(stderr,"INKLST hit res=%d\n",res); */
if (res){
/* fprintf(stderr,"INKLST ERROR\n"); */
fprintf(stderr,"Error: INKLST SELECT errno: %d\n",mysql_errno(&my_connection));
}else{
res_ptr=mysql_store_result(&my_connection);
if (res_ptr){
i=1;
/* fprintf(stdout,"INKLST:Retrieved %lu rows\n",(unsigned long)mysql_num_rows(res_ptr)); */
fprintf(stdout,"OK: NR_%lu_:",(unsigned long)mysql_num_rows(res_ptr));
while ((sqlrow=mysql_fetch_row(res_ptr))) {
//printf("INKLST:Fetched data....}");
display_row();
i++;
}
fprintf(stdout,"\n");
if (mysql_errno(&my_connection)) {
fprintf(stderr,"Error: INKLST Retriev error: %s\n", mysql_error(&my_connection));
}
}
mysql_free_result(res_ptr);
}
mysql_close(&my_connection);
}
else {
fprintf(stderr,"Error: INKLST Connection failed\n");
if (mysql_errno(&my_connection)) {
fprintf(stderr,"Error: INKLST Connection error %d: %s\n",
mysql_errno(&my_connection), mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
int main(int argc, char *argv[], char *envp[])
{
int res,i,status;
const char *userp = getenv("USER"); // vem är inloggad?
char databas[25]="olfix";
char usr[15]; // userid
char temp1[]="SELECT OFFERTNR,KUNDNR,LEVDATUM,ORDERSTATUS,ORDERTOTAL FROM OFFERTREG ORDER BY OFFERTNR";
char temp5[200]="";
/* fprintf(stderr,"OFFLST argc = %d\n",argc); */
/* for (i=0;i< argc;i++){
fprintf(stderr,"OFFLST argv%d = %s\n",i,argv[i]);
}
*/
/* ================================================================================ */
/* Val av databas, START */
/* ================================================================================ */
status = which_database(envp);
if (status != 0)
exit(status);
strncpy(usr,userp,15); /* Den inloggades userid */
/* fprintf(stderr,"status=%d ANTARG=%d len(database)=%d\n",status,ANTARG,strlen(database)); */
if (argc < ANTARG+1){
if (strlen(database)!= 0){
strncpy(databas,database,sizeof(databas)); /* 2005-02-24 */
}else{
strncpy(databas,"olfixtst",15); /* olfixtst = testföretag */
}
}else{
if (strlen(argv[ANTARG]) != 0){
if (strncmp(argv[ANTARG],"99",2)==0){
strncpy(databas,"olfixtst",15);
}else{
strncpy(databas,argv[ANTARG],15);
}
}
}
/* fprintf(stderr,"ANTARG=%d,argv[ANTARG]=%s\n",ANTARG,argv[ANTARG]); */
/* Om usr (userid) börjar på 'test' eller 'prov' använd databas 'olfixtst' */
if (strncmp(usr,"test",4)==0 || strncmp(usr,"prov",4)==0 ) {
strncpy(databas,"olfixtst",15);
}
/* fprintf(stderr,"Databas=%s\n",databas); */
/* ================================================================================ */
/* Val av databas, END! */
/* ================================================================================ */
strncpy(temp5,temp1,strlen(temp1));
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "olfix", "olfix", databas, 0, NULL, 0)){
/* fprintf(stdout,"ORDLST_Connection success\n"); */
res = mysql_query(&my_connection,temp5);
/* fprintf(stderr,"OFFLST hit res=%d\n",res); */
if (res){
/* fprintf(stderr,"OFFLST ERROR\n"); */
fprintf(stderr,"Error: OFFLST SELECT errno: %d\n",mysql_errno(&my_connection));
}else{
res_ptr=mysql_store_result(&my_connection);
if (res_ptr){
i=1;
/* fprintf(stdout,"OFFLST:Retrieved %lu rows\n",(unsigned long)mysql_num_rows(res_ptr)); */
fprintf(stdout,"OK: NR_%lu_:",(unsigned long)mysql_num_rows(res_ptr));
while ((sqlrow=mysql_fetch_row(res_ptr))) {
/* fprintf(stderr,"OFFLST:Fetched data....}"); */
display_row();
i++;
}
fprintf(stdout,"\n");
if (mysql_errno(&my_connection)) {
fprintf(stderr,"Error: OFFLST Retriev error: %s\n", mysql_error(&my_connection));
}
}
mysql_free_result(res_ptr);
}
mysql_close(&my_connection);
}
else {
fprintf(stderr,"Error: OFFLST Connection failed\n");
if (mysql_errno(&my_connection)) {
fprintf(stderr,"Error: OFFLST Connection error %d: %s\n",
mysql_errno(&my_connection), mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
int main(int argc, char *argv[], char *envp[])
{
int i;
int res;
int status;
const char *userp = getenv("USER"); /* vem är inloggad? */
char databas[25]="olfix";
char usr[21]; /* userid 20070214 utökat från 15 till 21 tecken */
/* for(i=0;i<=argc;i++){
fprintf(stderr,"argv[%d]=%s\n",i,argv[i]);
}
*/
char temp1a[]="SELECT KTONR, BENAMNING FROM KTOPLAN WHERE ARID=\"";
char temp1b[]=" ORDER BY KTONR";
char temp2[]="\"";
char temp5[200]="";
char arid[3]="";
/* ================================================================================ */
/* Val av databas, START */
/* ================================================================================ */
status = which_database(envp);
if (status != 0)
exit(status);
strncpy(usr,userp,sizeof(usr)); /* Den inloggades userid 20070214 */
/* fprintf(stderr,"status=%d ANTARG=%d len(database)=%d\n",status,ANTARG,strlen(database)); */
if (argc < ANTARG+1){
if (strlen(database)!= 0){
strncpy(databas,database,15);
}else{
strncpy(databas,"olfixtst",15); /* olfixtst = testföretag */
}
}else{
if (strlen(argv[ANTARG]) != 0){
if (strncmp(argv[ANTARG],"99",2)==0){
strncpy(databas,"olfixtst",15);
}else{
strncpy(databas,argv[ANTARG],15);
}
}
}
/* fprintf(stderr,"ANTARG=%d,argv[ANTARG]=%s\n",ANTARG,argv[ANTARG]); */
/* Om usr (userid) börjar på 'test' eller 'prov' använd databas 'olfixtst' */
if (strncmp(usr,"test",4)==0 || strncmp(usr,"prov",4)==0 ) {
strncpy(databas,"olfixtst",15);
}
/* fprintf(stderr,"Databas=%s\n",databas); */
/* ================================================================================ */
/* Val av databas, END! */
/* ================================================================================ */
if (argv[1] != NULL){
strncpy(arid,argv[1],sizeof(arid)); /* 2005-02-24 */
}
else{
fprintf(stderr,"Error: KTOVIEW ARID Ange årtal!\n");
exit(-1);
}
strncpy(temp5,temp1a,strlen(temp1a));
/* SELECT KTONR, BENAMNING FROM KTOPLAN WHERA ARID=" */
strncat(temp5,arid,strlen(arid)); /* 2002 */
/* SELECT KTONR, BENAMNING FROM KTOPLAN WHERA ARID="2002 */
strncat(temp5,temp2,strlen(temp2)); /* " */
/* SELECT KTONR, BENAMNING FROM KTOPLAN WHERA ARID="2002" */
strncat(temp5,temp1b,strlen(temp1b));
/* SELECT KTONR, BENAMNING FROM KTOPLAN WHERA ARID="2002" ORDER BY KTONR */
// fprintf(stderr,"KTOVIEWmain: temp5 = %s\n",temp5);
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "olfix", "olfix", databas, 0, NULL, 0)){
/* fprintf(stderr,"KTOVIEW:Connection success\n"); */
res = mysql_query(&my_connection,temp5);
if (res){
fprintf(stderr,"Error: KTOVIEW SELECT error: %s\n",mysql_error(&my_connection));
}else{
res_ptr=mysql_store_result(&my_connection);
if (res_ptr){
i=1;
/* fprintf(stderr,"KTOVIEW:Retrieved %lu rows\n",(unsigned long)mysql_num_rows(res_ptr)); */
if ( (unsigned long)mysql_num_rows(res_ptr) > 0){
fprintf(stdout,"NR_%lu_:",(unsigned long)mysql_num_rows(res_ptr));
while ((sqlrow=mysql_fetch_row(res_ptr))) {
/* fprintf(stderr,"KTOVIEW:Fetched data....}"); */
display_row();
i++;
}
}else{
if ((unsigned long)mysql_num_rows(res_ptr) == 0){
fprintf(stdout,"VARNING: KTOVIEW. Det finns inga poster!\n");
}else{
fprintf(stderr,"Error: KTOVIEW Felaktigt årtal!\n");
}
}
if (mysql_errno(&my_connection)) {
fprintf(stderr,"Error: KTOVIEW Retriev error: %s\n", mysql_error(&my_connection));
}
}
mysql_free_result(res_ptr);
}
mysql_close(&my_connection);
}
else {
fprintf(stderr,"Error: KTOVIEW Connection failed\n");
if (mysql_errno(&my_connection)) {
fprintf(stderr,"Error: KTOVIEW Connection error %d: %s\n",
mysql_errno(&my_connection), mysql_error(&my_connection));
}
}
fprintf(stdout,"\n");
return EXIT_SUCCESS;
}
int main(int argc, char *argv[], char *envp[])
{
int res;
int i;
int status;
const char *userp = getenv("USER"); /* vem är inloggad? */
char databas[25]="olfix";
char usr[21]; /* userid 20070214 utökat från 15 till 21 tecken */
/* ================================================================================ */
/* Val av databas, START */
/* ================================================================================ */
status = which_database(envp);
if (status != 0)
exit(status);
strncpy(usr,userp,sizeof(usr)); /* Den inloggades userid 20070214 */
/* fprintf(stderr,"status=%d ANTARG=%d len(database)=%d\n",status,ANTARG,strlen(database)); */
if (argc < ANTARG+1){
if (strlen(database)!= 0){
strncpy(databas,database,15);
}else{
strncpy(databas,"olfixtst",15); /* olfixtst = testföretag */
}
}else{
if (strlen(argv[ANTARG]) != 0){
if (strncmp(argv[ANTARG],"99",2)==0){
strncpy(databas,"olfixtst",sizeof(databas)); /*2005-02-24 */
}else{
strncpy(databas,argv[ANTARG],sizeof(databas)); /*2005-02-24 */
}
}
}
/* fprintf(stderr,"ANTARG=%d,argv[ANTARG]=%s\n",ANTARG,argv[ANTARG]); */
/* Om usr (userid) börjar på 'test' eller 'prov' använd databas 'olfixtst' */
if (strncmp(usr,"test",4)==0 || strncmp(usr,"prov",4)==0 ) {
strncpy(databas,"olfixtst",15);
}
/* fprintf(stderr,"Databas=%s\n",databas); */
/* ================================================================================ */
/* Val av databas, END! */
/* ================================================================================ */
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "olfix", "olfix", databas, 0, NULL, 0)){
/* fprintf(stderr,"KTOLST:Connection success\n"); */
res = mysql_query(&my_connection,"SELECT * FROM KTOPLAN ORDER BY ARID, KTONR");
if (res){
fprintf(stderr,"Error: KTOLST SELECT error: %s\n",mysql_error(&my_connection));
}else{
res_ptr=mysql_store_result(&my_connection);
if (res_ptr){
i=1;
/* fprintf(stdout,"KTOLST:Retrieved %lu rows\n",(unsigned long)mysql_num_rows(res_ptr)); */
fprintf(stdout,"OK: NR_%lu_:",(unsigned long)mysql_num_rows(res_ptr));
while ((sqlrow=mysql_fetch_row(res_ptr))) {
/* printf("KTOLST:Fetched data....}"); */
display_row();
i++;
}
if (mysql_errno(&my_connection)) {
fprintf(stderr,"Error: KTOLST Retriev error: %s\n", mysql_error(&my_connection));
}
}
mysql_free_result(res_ptr);
}
mysql_close(&my_connection);
} else {
fprintf(stderr,"Error: KTOLST Connection failed\n");
if (mysql_errno(&my_connection)) {
fprintf(stderr,"Error: KTOLST Connection error %d: %s\n",
mysql_errno(&my_connection), mysql_error(&my_connection));
}
}
fprintf(stdout,"\n");
return EXIT_SUCCESS;
}
int main(int argc, char *argv[], char *envp[])
{
int res,status;
int i;
char temp1[]="SELECT db FROM db";
char temp5[200]="";
const char *userp = getenv("USER"); /* vem är inloggad? */
char databas[25]="olfix";
char usr[21]; /* userid 20070213 utökat från 15 till 21 tecken */
strncpy(usr,userp,sizeof(usr)); /* Den inloggades userid 20070213 */
if (argc<3){
if (strlen(database)!= 0){
strncpy(databas,database,15);
}else{
strncpy(databas,"olfixtst",15); /* olfixtst = testföretag, används som grundvärde */
}
}else{
if (strlen(argv[2]) != 0){
if (strncmp(argv[2],"99",2)==0){
strncpy(databas,"olfixtst",15);
}else{
strncpy(databas,argv[2],15);
}
}
}
/* Om usr (userid) börjar på 'test' eller 'prov' använd databas 'olfixtst' */
if (strncmp(usr,"test",4)==0 || strncmp(usr,"prov",4)==0 ) {
strncpy(databas,"olfixtst",15);
}
// fprintf(stderr,"ARCHK database = %s databas=%s\n",database,databas);
// ================================================================================
// Val av databas, END!
// ================================================================================
strcpy(temp5,temp1);
/* SELECT db FROM db */
mysql_init(&my_connection);
/* anropa databasen mysql som innehåller en förteckning av befintliga databaset i systemet. */
if (mysql_real_connect(&my_connection, "localhost", "olfix", "olfix", "mysql", 0, NULL, 0)){
/* fprintf(stdout,"DBCHKmain:Connection success\n"); */
res = mysql_query(&my_connection,temp5);
if (res){
fprintf(stderr,"Error: DBCHK SELECT error: %s\n",mysql_error(&my_connection));
}else{
res_ptr=mysql_store_result(&my_connection);
if (res_ptr){
// fprintf(stderr,"DBCHK_Retrieved %lu rows\n",(unsigned long)mysql_num_rows(res_ptr));
if((unsigned long)mysql_num_rows(res_ptr) > 0){ /* En rad har hittats */
status=0;
}else{ /* Ingen rad hittades */
status=-1;
}
i=1;
fprintf(stdout,"NR_%lu_:",(unsigned long)mysql_num_rows(res_ptr));
while ((sqlrow=mysql_fetch_row(res_ptr))) {
display_row();
i++;
}
fprintf(stdout,"\n");
if (mysql_errno(&my_connection)){
fprintf(stderr,"Error: DBCHK Retriev error: %s\n", mysql_error(&my_connection));
}
}
mysql_free_result(res_ptr);
}
mysql_close(&my_connection);
}else{
fprintf(stderr,"Error: DBCHK Connection failed\n");
if (mysql_errno(&my_connection)){
fprintf(stderr,"Error: DBCHK Connection error %d: %s\n",
mysql_errno(&my_connection), mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
int main(int argc, char *argv[], char *envp[])
{
int i;
int res;
int status;
const char *userp = getenv("USER"); /* vem är inloggad? */
char databas[25]="olfix";
char usr[15]; /* userid */
char arid[3]=""; /* bokföringsår */
char temp1[]="SELECT KTONR, SUM(BELOPP),DK FROM VERRAD";
char temp1c[]=" WHERE ARID = \"";
char temp2[]="\" ";
char temp3[]=" GROUP BY KTONR,DK";
char temp5[500]="";
/* for (i=0;i< argc;i++){
fprintf(stderr,"SIEEXPR argv%d = %s\n",i,argv[i]);
}
*/
/* fprintf(stderr,"argc=%d\n",argc); */
if (argc<2){
fprintf(stderr,"Error: SIEEXPK. ARID saknas!\n");
exit(0);
}
strncpy(arid,argv[1],sizeof(arid));
/* ================================================================================ */
/* Val av databas, START */
/* ================================================================================ */
status = which_database(envp);
if (status != 0)
exit(status);
strncpy(usr,userp,15); /* Den inloggades userid */
/* fprintf(stderr,"status=%d ANTARG=%d len(database)=%d\n",status,ANTARG,strlen(database)); */
if (argc < ANTARG+1){
if (strlen(database)!= 0){
strncpy(databas,database,sizeof(databas));
}else{
strncpy(databas,"olfixtst",15); /* olfixtst = testföretag */
}
}else{
if (strlen(argv[ANTARG]) != 0){
if (strncmp(argv[ANTARG],"99",2)==0){
strncpy(databas,"olfixtst",15);
}else{
strncpy(databas,argv[ANTARG],15);
}
}
}
/* fprintf(stderr,"ANTARG=%d,argv[ANTARG]=%s\n",ANTARG,argv[ANTARG]); */
/* Om usr (userid) börjar på 'test' eller 'prov' använd databas 'olfixtst' */
if (strncmp(usr,"test",4)==0 || strncmp(usr,"prov",4)==0 ) {
strncpy(databas,"olfixtst",15);
}
/* fprintf(stderr,"Databas=%s\n",databas); */
/* ================================================================================ */
/* Val av databas, END! */
/* ================================================================================ */
strncpy(temp5,temp1,strlen(temp1));
/* SELECT KTONR, SUM(BELOPP),DK FROM VERRAD */
strncat(temp5,temp1c,strlen(temp1c));
/* SELECT KTONR, SUM(BELOPP),DK FROM VERRAD WHERE ARID = " */
strncat(temp5,arid,strlen(arid));
/* SELECT KTONR, SUM(BELOPP),DK FROM VERRAD WHERE ARID = " AD */
strncat(temp5,temp2,strlen(temp2));
/* SELECT KTONR, SUM(BELOPP),DK FROM VERRAD WHERE ARID = " AD " */
strncat(temp5,temp3,strlen(temp3));
/* SELECT KTONR, SUM(BELOPP),DK FROM VERRAD WHERE ARID = " AD "
ORDER BY KTONR */
/* fprintf(stderr,"temp5=%s\n",temp5); */
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost", "olfix", "olfix", databas, 0, NULL, 0)){
res = mysql_query(&my_connection,temp5);
if (res){
fprintf(stderr,"Error: SIEEXPR SELECT errno: %d\n",mysql_errno(&my_connection));
}
else{
res_ptr=mysql_store_result(&my_connection);
if (res_ptr){
i=1;
fprintf(stdout,"OK: ANTAL_%lu_\n",(unsigned long)mysql_num_rows(res_ptr));
while ((sqlrow=mysql_fetch_row(res_ptr))) {
display_row();
i++;
}
fprintf(stdout,"END:");
fprintf(stdout,"\n");
}
else{
fprintf(stderr,"Error: Data saknas: %s\n", mysql_error(&my_connection));
}
if (mysql_errno(&my_connection)) {
fprintf(stderr,"Error: SIEEXPR Retriev error: %s\n", mysql_error(&my_connection));
}
}
mysql_free_result(res_ptr);
mysql_close(&my_connection);
}
else{
fprintf(stderr,"Error: SIEEXPR Connection failed\n");
if (mysql_errno(&my_connection)) {
fprintf(stderr,"Error: SIEEXPR Connection error %d: %s\n",
mysql_errno(&my_connection), mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
