Question

Help please

Hi, i need to write a c++ program that caculate queries by directly reading the content of csv files.
the queries are :
A) the list of all the book that were published in a given publication year (by user)
B)The list of all the book of a given title that are available for borrowing
C)The name of all the members who have a copy of a given title in their possession
D)The name of all the members who have a book in their possession.

There are 4 csv files :
Book : contains : ISBN, "title", edition, year of publication
BookCopy : contains : Copy number, ISBN, available
Borrower : contains : member number, "name", "postal address and phone number"
BookLoan : contains : Copy number, "borrowing date","return date", member number

Answer 1

#include <iostream>
#include <string>
#include <sstream>

#include <fstream>

using namespace std;

struct Book {
   int ISBN;
   string title;
   int edition;
   int year;
   struct Book* next;
};

struct Book_copy {
   int ISBN;
   int copy_number;
   int available;
   struct Book_copy* next;
};

struct Borrower {
   int member_number;
   string name;
   string address;
   struct Borrower* next;
};

struct BookLoan {
   int copy_number;
   string borrowing_date;
   string return_date;
   int member_number;
   struct BookLoan* next;
};

struct Book* book_ptr=NULL;
struct Book_copy* book_copy_ptr=NULL;
struct Borrower* borrower_ptr=NULL;
struct BookLoan* bookloan_ptr=NULL;

struct Book* new_Book(int ISBN, string title, int edition, int year) {
   struct Book* ptr = new Book();
   ptr->ISBN = ISBN;
   ptr->title = title;
   ptr->edition = edition;
   ptr->year = year;
   ptr->next = NULL;
   return ptr;
}

struct Book_copy* new_Book_copy(int ISBN, int copy_number, int available) {
   struct Book_copy* ptr = new Book_copy();
   ptr->available = available;
   ptr->copy_number = copy_number;
   ptr->ISBN = ISBN;
   ptr->next = NULL;
   return ptr;
}

struct Borrower* new_Borrower(int member_number, string name, string address) {
   struct Borrower* ptr = new Borrower();
   ptr->address = address;
   ptr->member_number = member_number;
   ptr->name = name;
   ptr->next = NULL;
   return ptr;
}

struct BookLoan* new_BookLoan(int copy_number, string borrowing_date, string return_date,int member_number) {
   struct BookLoan* ptr = new BookLoan();
   ptr->borrowing_date = borrowing_date;
   ptr->copy_number = copy_number;
   ptr->member_number = member_number;
   ptr->return_date = return_date;
   ptr->next = NULL;
   return ptr;
}

void read_Book()
{
   fstream fin;

   fin.open("Book.csv", ios::in);

   string line;
       struct Book* temp = book_ptr;

       while (getline(fin, line))
       {
           stringstream ss(line);
           string token;
           int a, c, d;
           string b;
           int i = 0;

           while (std::getline(ss, token, ',')) {
               std::cout << token << '\n';
               if (i == 0) {
                   a = stoi(token);
               }
               else if (i == 1) {
                   b = token;
               }
               else if (i==2) {
                   c = stoi(token);
               }
               else if(i==3) {
                   d = stoi(token);
               }
               i++;
           }
           cout << a << " " << b << " " << c << " " << d << endl;
           if (book_ptr == NULL) {
               book_ptr = new_Book(a, b, c, d);
               temp = book_ptr;
           }
           else {
               temp->next = new_Book(a, b, c, d);
               temp = temp->next;
           }
       }
}

void read_BookCopy()
{
   fstream fin;

   fin.open("BookCopy.csv", ios::in);

   string line;
   struct Book_copy* temp = book_copy_ptr;

   while (getline(fin, line))
   {
       stringstream ss(line);
       string token;
       int a, b, c;
       int i = 0;

       while (std::getline(ss, token, ',')) {
           std::cout << token << '\n';
           if (i == 0) {
               a = stoi(token);
           }
           else if (i == 1) {
               b = stoi(token);
           }
           else if (i == 2) {
               c = stoi(token);
           }
           i++;
       }
       cout << a << " " << b << " " << c << " " << endl;
       if (book_copy_ptr == NULL) {
           book_copy_ptr = new_Book_copy(a, b, c);
           temp = book_copy_ptr;
       }
       else {
           temp->next = new_Book_copy(a, b, c);
           temp = temp->next;
       }
   }
}

void read_Borrower()
{
   fstream fin;

   fin.open("Borrower.csv", ios::in);

   string line;
   struct Borrower* temp = borrower_ptr;

   while (getline(fin, line))
   {
       stringstream ss(line);
       string token;
       int a;
       string b, c;
       int i = 0;

       while (std::getline(ss, token, ',')) {
           std::cout << token << '\n';
           if (i == 0) {
               a = stoi(token);
           }
           else if (i == 1) {
               b = token;
           }
           else if (i == 2) {
               c = token;
           }
           i++;
       }
       cout << a << " " << b << " " << c << " " << endl;
       if (borrower_ptr == NULL) {
           borrower_ptr = new_Borrower(a, b, c);
           temp = borrower_ptr;
       }
       else {
           temp->next = new_Borrower(a, b, c);
           temp = temp->next;
       }
   }
}

void read_BookLoan()
{
   fstream fin;

   fin.open("BookLoan.csv", ios::in);

   string line;
   struct BookLoan* temp = bookloan_ptr;

   while (getline(fin, line))
   {
       stringstream ss(line);
       string token;
       int a, d;
           string b, c;
       int i = 0;

       while (std::getline(ss, token, ',')) {
           std::cout << token << '\n';
           if (i == 0) {
               a = stoi(token);
           }
           else if (i == 1) {
               b = token;
           }
           else if (i == 2) {
               c =token;
           }
           else if (i == 3) {
               d = stoi(token);
           }
           i++;
       }
       cout << a << " " << b << " " << c << " " << endl;
       if (book_copy_ptr == NULL) {
           bookloan_ptr = new_BookLoan(a, b, c,d);
           temp = bookloan_ptr;
       }
       else {
           temp->next = new_BookLoan(a, b, c,d);
           temp = temp->next;
       }
   }
}

void A(int year) {
   struct Book* temp = book_ptr;
   while (temp) {
       if (temp->year == year) {
           cout << temp->title << endl;
       }
       temp = temp->next;
   }
   cout << endl;
}

void B(string title) {
   struct Book* temp = book_ptr;
   struct Book_copy* temp1 = book_copy_ptr;

   cout << "Title " << "\t" << "Copy number" << "\t" << "ISBN" << "\t" << "Avialable" << endl;

   while (temp) {
       if (temp->title == title) {
           int ISBN = temp->ISBN;
           temp1 = book_copy_ptr;
           while (temp1) {
               if (temp1->ISBN == ISBN) {
                   cout << title << temp1->copy_number << "\t" << temp1->ISBN << "\t" << temp1->available << endl;
               }
               temp1 = temp1->next;
           }
       }
       temp = temp->next;
   }

   cout << endl;
}

void C(string title) {
   struct Book* temp = book_ptr;
   struct Book_copy* temp1 = book_copy_ptr;
   struct Borrower* temp2 = borrower_ptr;
   struct BookLoan* temp3 = bookloan_ptr;

   while (temp) {
       if (temp->title == title) {
           int ISBN = temp->ISBN;
           temp1 = book_copy_ptr;
           while (temp1) {
               if (temp1->ISBN == ISBN) {
                   int copy_number = temp1->copy_number;
                   temp3 = bookloan_ptr;
                   while (temp3) {
                       if (temp3->copy_number == copy_number) {
                           int member_number = temp3->member_number;
                           temp2 = borrower_ptr;
                           while (temp2) {
                               if (temp2->member_number = member_number) {
                                   cout << temp2->name << endl;
                               }
                               temp2 = temp2->next;
                           }
                       }
                       temp3 = temp3->next;
                   }

               }
               temp1 = temp1->next;
           }
       }
       temp = temp->next;
   }

   cout << endl;
}

void D() {
   struct Borrower* temp2 = borrower_ptr;
   struct BookLoan* temp3 = bookloan_ptr;

                   while (temp3) {
                           int member_number = temp3->member_number;
                           temp2 = borrower_ptr;
                           while (temp2) {
                               if (temp2->member_number = member_number) {
                                   cout << temp2->name << endl;
                               }
                               temp2 = temp2->next;
                           }
                      
                       temp3 = temp3->next;
                   }

   cout << endl;
}

int main() {
   read_Book();
   read_BookCopy();
   read_Borrower();
   read_BookLoan();

   cout << "A) the list of all the book that were published in a given publication year" << endl;
   int year;
   cout << "Input Year" << endl;
   cin >> year;
   A(year);

   cout << "B)The list of all the book of a given title that are available for borrowing" << endl;
   string title;
   cin >> title;
   B(title);

   cout << "C)The name of all the members who have a copy of a given title in their possession" << endl;
   cin >> title;
   C(title);

   cout << "D)The name of all the members who have a book in their possession." << endl;
   D();

   return 0;

}