mysql_list.c 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507
  1. /* $Id: mysql_list.c,v 1.12 2001/04/20 10:25:13 kilobug Exp $ */
  2. #include "mclient.h"
  3. void mysql_list_refresh(const sql_list_t *l, const char *where)
  4. {
  5. char *s;
  6. MYSQL_RES *res;
  7. MYSQL_ROW row;
  8. char **tb;
  9. int *p, i;
  10. GdkColor *col;
  11. if (where != NULL)
  12. s = g_strconcat(l->query, " AND (", where, ")", NULL);
  13. else
  14. s = g_strdup(l->query);
  15. if (mysql_query_gtk(gl_config->mysql, s))
  16. return;
  17. g_free(s);
  18. res = mysql_store_result(gl_config->mysql);
  19. i = mysql_num_fields(res);
  20. if (i != l->nb_fields)
  21. {
  22. fprintf(stderr,
  23. "Warning: SQL error: number of rows mismatch (%d / %d).\n",
  24. i, l->nb_fields);
  25. return;
  26. }
  27. tb = g_malloc(sizeof(*tb) * (l->nb_fields - 1));
  28. gtk_clist_unselect_all(l->clist);
  29. gtk_clist_freeze(l->clist);
  30. gtk_clist_clear(l->clist);
  31. while ((row = mysql_fetch_row(res)) != NULL)
  32. {
  33. for (i = 1; i < l->nb_fields; i++)
  34. if (l->items[i].cvt_func != NULL)
  35. tb[i - 1] = l->items[i].cvt_func(row[i], l->items[i].data);
  36. else
  37. tb[i - 1] = row[i];
  38. p = g_malloc(sizeof(*p));
  39. *p = atoi(row[0]);
  40. col = NULL;
  41. if (l->color_func != NULL)
  42. col = l->color_func(l, *p, l->color_func_data);
  43. i = gtk_clist_append(l->clist, tb);
  44. gtk_clist_set_row_data_full(l->clist, i, p, g_free);
  45. if (col != NULL)
  46. {
  47. gtk_clist_set_foreground(l->clist, i, col);
  48. g_free(col);
  49. }
  50. for (i = 1; i < l->nb_fields; i++)
  51. if (l->items[i].destroy_func != NULL)
  52. l->items[i].destroy_func(tb[i - 1]);
  53. }
  54. mysql_free_result(res);
  55. g_free(tb);
  56. gtk_clist_thaw(l->clist);
  57. }
  58. sql_list_t *mysql_list_make(const char *query, int nb_fields, GtkCList *clist,
  59. ...)
  60. {
  61. sql_list_t *res;
  62. va_list va;
  63. int i;
  64. res = g_malloc(sizeof(*res));
  65. res->query = query;
  66. res->clist = clist;
  67. res->color_func = NULL;
  68. res->color_func_data = NULL;
  69. res->nb_fields = nb_fields;
  70. res->items = g_malloc(sizeof(*(res->items)) * nb_fields);
  71. for (i = 0; i < nb_fields; i++)
  72. {
  73. res->items[i].destroy_func = NULL;
  74. res->items[i].cvt_func = NULL;
  75. res->items[i].data = NULL;
  76. }
  77. va_start(va, clist);
  78. while ((i = va_arg(va, int)) >= 0)
  79. {
  80. res->items[i].cvt_func = va_arg(va, ml_cvt_func_t *);
  81. res->items[i].destroy_func = va_arg(va, void *);
  82. res->items[i].data = va_arg(va, void *);
  83. }
  84. va_end(va);
  85. return res;
  86. }
  87. void mysql_list_set_color_func(sql_list_t *list, ml_color_func_t *callback,
  88. void *data)
  89. {
  90. if (list == NULL)
  91. return;
  92. list->color_func = callback;
  93. list->color_func_data = data;
  94. }
  95. /*
  96. ** Adder
  97. */
  98. static void mysql_adder_do_commit(const sql_add_t *adder, const char *before,
  99. const char *after)
  100. {
  101. char buf[MYSQL_BUFFER_SIZE], *p;
  102. GSList *l;
  103. sql_add_item_t *item;
  104. int i;
  105. char *path, *apath, *s;
  106. if (adder->table == NULL)
  107. {
  108. adder->callback(NULL, adder);
  109. return;
  110. }
  111. g_snprintf(buf, MYSQL_BUFFER_SIZE,
  112. "%s %s SET auteur=%d", before, adder->table, getuid());
  113. p = buf + strlen(buf);
  114. for (l = adder->items; l != NULL; l = l->next)
  115. {
  116. item = l->data;
  117. p += g_snprintf(p, MYSQL_BUFFER_SIZE - (p - buf), ", %s=", item->field);
  118. switch (item->type)
  119. {
  120. case sql_add_str:
  121. p += g_snprintf(p, MYSQL_BUFFER_SIZE - (p - buf),
  122. "'%s'", gtk_entry_get_text(GTK_ENTRY(item->widget)));
  123. break;
  124. case sql_add_file:
  125. path = gtk_entry_get_text(GTK_ENTRY(item->widget));
  126. if (g_path_is_absolute(path))
  127. apath = path;
  128. else
  129. {
  130. s = g_get_current_dir();
  131. apath = g_strconcat(s, G_DIR_SEPARATOR_S, path, NULL);
  132. g_free(s);
  133. }
  134. p += g_snprintf(p, MYSQL_BUFFER_SIZE - (p - buf), "'%s'", apath);
  135. if (apath != path)
  136. g_free(apath);
  137. break;
  138. case sql_add_num:
  139. set_data_from_spin(item->widget, &i);
  140. p += g_snprintf(p, MYSQL_BUFFER_SIZE - (p - buf), "'%d'", i);
  141. break;
  142. case sql_add_flag:
  143. set_data_from_toggle(item->widget, &i);
  144. p += g_snprintf(p, MYSQL_BUFFER_SIZE - (p - buf), "'%d'", i);
  145. break;
  146. default:
  147. fprintf(stderr,
  148. "Warning: internal error in `mysql_adder_commit'.\n");
  149. }
  150. }
  151. p += g_snprintf(p, MYSQL_BUFFER_SIZE - (p - buf), " %s", after);
  152. mysql_query_gtk(gl_config->mysql, buf);
  153. adder->callback(NULL, adder);
  154. }
  155. static void mysql_adder_commit(GtkWidget *wid, sql_add_t *adder)
  156. {
  157. mysql_adder_do_commit(adder, "INSERT INTO ", "");
  158. }
  159. static void mysql_adder_item_create(sql_add_item_t *item, GtkWidget *tbl,
  160. int pos,
  161. GtkSignalFunc activate, void *actdata,
  162. GtkSignalFunc activate2, void *actdata2)
  163. {
  164. int *foo = NULL;
  165. char *s;
  166. GtkWidget *widget;
  167. widget = create_label(item->label);
  168. gtk_table_attach_defaults(GTK_TABLE(tbl), widget, 0, 1, pos, pos + 1);
  169. switch (item->type)
  170. {
  171. case sql_add_str:
  172. foo = item->param;
  173. item->widget = create_entry(NULL, *foo);
  174. gtk_table_attach_defaults(GTK_TABLE(tbl), item->widget,
  175. 1, 3, pos, pos + 1);
  176. gtk_signal_connect(GTK_OBJECT(item->widget), "activate",
  177. activate, actdata);
  178. gtk_signal_connect_after(GTK_OBJECT(item->widget), "activate",
  179. activate2, actdata2);
  180. break;
  181. case sql_add_num:
  182. foo = item->param;
  183. item->widget = create_spin(foo[0], foo[1], foo[2]);
  184. gtk_table_attach_defaults(GTK_TABLE(tbl), item->widget,
  185. 1, 3, pos, pos + 1);
  186. break;
  187. case sql_add_flag:
  188. foo = item->param;
  189. item->widget = create_check(*foo);
  190. gtk_table_attach(GTK_TABLE(tbl), item->widget, 1, 3, pos, pos + 1,
  191. GTK_FILL | GTK_EXPAND, GTK_FILL | GTK_EXPAND, 0, 5);
  192. break;
  193. case sql_add_file:
  194. s = item->param;
  195. item->widget = create_entry(NULL, 200);
  196. gtk_table_attach_defaults(GTK_TABLE(tbl), item->widget,
  197. 1, 2, pos, pos + 1);
  198. widget = create_filesel_button("Parcourir", "Parcourir...",
  199. GTK_ENTRY(item->widget));
  200. gtk_tooltips_set_tip(gl_config->tooltips, widget,
  201. "Choisir le fichier...", "");
  202. gtk_table_attach(GTK_TABLE(tbl), widget, 2, 3, pos, pos + 1,
  203. GTK_FILL | GTK_EXPAND, GTK_FILL | GTK_EXPAND, 5, 0);
  204. gtk_signal_connect(GTK_OBJECT(item->widget), "activate",
  205. activate, actdata);
  206. gtk_signal_connect_after(GTK_OBJECT(item->widget), "activate",
  207. activate2, actdata2);
  208. break;
  209. default:
  210. fprintf(stderr, "Warning: internal error in `make_mysql_adder'.\n");
  211. }
  212. gtk_tooltips_set_tip(gl_config->tooltips, item->widget, item->tooltip, "");
  213. }
  214. static sql_add_item_t *mysql_adder_item_get(va_list *va)
  215. {
  216. int *foo = NULL;
  217. sql_add_item_t *item;
  218. char *s;
  219. item = g_malloc(sizeof(*item));
  220. item->label = va_arg(*va, const char *);
  221. item->field = va_arg(*va, const char *);
  222. item->tooltip = va_arg(*va, const char *);
  223. item->type = va_arg(*va, int);
  224. switch (item->type)
  225. {
  226. case sql_add_str:
  227. foo = item->param = g_malloc(sizeof(int));
  228. *foo = va_arg(*va, int);
  229. break;
  230. case sql_add_num:
  231. foo = item->param = g_malloc(sizeof(int) * 3);
  232. foo[0] = va_arg(*va, int);
  233. foo[1] = va_arg(*va, int);
  234. foo[2] = va_arg(*va, int);
  235. break;
  236. case sql_add_flag:
  237. foo = item->param = g_malloc(sizeof(int));
  238. *foo = va_arg(*va, int);
  239. break;
  240. case sql_add_file:
  241. s = va_arg(*va, char *);
  242. item->param = s;
  243. break;
  244. }
  245. return item;
  246. }
  247. sql_add_t *mysql_adder_make(const char *table, const char *title,
  248. GtkSignalFunc callback, int nb, ...)
  249. {
  250. sql_add_t *res;
  251. GtkWidget *tbl;
  252. int i;
  253. va_list va;
  254. sql_add_item_t *item;
  255. va_start(va, nb);
  256. res = g_malloc(sizeof(*res));
  257. res->table = table;
  258. res->items = NULL;
  259. res->callback = callback;
  260. /* Main box */
  261. tbl = gtk_table_new(3, nb, FALSE);
  262. gtk_widget_show(tbl);
  263. res->widget = create_dialog(title, tbl, " Valider ", " Annuler ",
  264. mysql_adder_commit, res, hide_widget);
  265. /* Entrys */
  266. for (i = 0; i < nb; i++)
  267. {
  268. item = mysql_adder_item_get(&va);
  269. mysql_adder_item_create(item, tbl, i, mysql_adder_commit, res,
  270. hide_widget, res->widget);
  271. res->items = g_slist_prepend(res->items, item);
  272. }
  273. va_end(va);
  274. return res;
  275. }
  276. /*
  277. ** Deleter
  278. */
  279. static void mysql_query_callback(GtkWidget *wid, const char *query)
  280. {
  281. mysql_query_gtk(gl_config->mysql, query);
  282. }
  283. static void mysql_list_remove_confirm(char *query, int nb,
  284. GtkSignalFunc refresh_callback)
  285. {
  286. GtkWidget *dialog, *widget, *hbox;
  287. GtkAccelGroup *accel_group;
  288. char buf[MYSQL_BUFFER_SIZE];
  289. /* Main box */
  290. dialog = gtk_dialog_new();
  291. gtk_widget_hide(dialog);
  292. gtk_signal_connect(GTK_OBJECT(dialog), "destroy",
  293. GTK_SIGNAL_FUNC(gtk_widget_destroy), NULL);
  294. gtk_signal_connect_after(GTK_OBJECT(dialog), "destroy",
  295. GTK_SIGNAL_FUNC(free_callback), query);
  296. gtk_window_set_title(GTK_WINDOW(dialog), "Confirmation de suppression");
  297. gtk_container_set_border_width(GTK_CONTAINER(&(GTK_DIALOG(dialog)->window)),
  298. 7);
  299. accel_group = gtk_accel_group_new();
  300. gtk_window_add_accel_group(GTK_WINDOW(&(GTK_DIALOG(dialog)->window)),
  301. accel_group);
  302. /* Buttons */
  303. hbox = gtk_hbox_new(FALSE, 3);
  304. gtk_widget_show(hbox);
  305. widget = gtk_button_new_with_label(" Oui ");
  306. gtk_widget_add_accelerator(widget, "clicked", accel_group, GDK_Return, 0,
  307. GTK_ACCEL_VISIBLE);
  308. gtk_widget_show(widget);
  309. gtk_signal_connect(GTK_OBJECT(widget), "clicked",
  310. GTK_SIGNAL_FUNC(mysql_query_callback), query);
  311. gtk_signal_connect(GTK_OBJECT(widget), "clicked",
  312. GTK_SIGNAL_FUNC(refresh_callback), NULL);
  313. gtk_signal_connect_after(GTK_OBJECT(widget), "clicked",
  314. GTK_SIGNAL_FUNC(destroy_widget), dialog);
  315. gtk_box_pack_start(GTK_BOX(hbox), widget, TRUE, TRUE, 9);
  316. widget = gtk_button_new_with_label(" Non ");
  317. gtk_widget_add_accelerator(widget, "clicked", accel_group, GDK_Escape, 0,
  318. GTK_ACCEL_VISIBLE);
  319. gtk_widget_show(widget);
  320. gtk_signal_connect_after(GTK_OBJECT(widget), "clicked",
  321. GTK_SIGNAL_FUNC(destroy_widget), dialog);
  322. gtk_box_pack_start(GTK_BOX(hbox), widget, TRUE, TRUE, 9);
  323. gtk_box_pack_start(GTK_BOX(GTK_DIALOG(dialog)->action_area), hbox, TRUE,
  324. TRUE, 9);
  325. /* Message */
  326. if (nb > 1)
  327. g_snprintf(buf, MYSQL_BUFFER_SIZE,
  328. "Es-tu sûr de vouloir effacer ces %d éléments ?", nb);
  329. else
  330. g_snprintf(buf, MYSQL_BUFFER_SIZE,
  331. "Es-tu sûr de vouloir effacer cet élément ?");
  332. gtk_box_pack_start(GTK_BOX(GTK_DIALOG(dialog)->vbox), create_label(buf),
  333. TRUE, TRUE, 9);
  334. gtk_widget_show(dialog);
  335. }
  336. void mysql_list_remove(const char *table, GtkCList *clist,
  337. GtkSignalFunc refresh_callback)
  338. {
  339. GSList *valid = NULL, *sl;
  340. GList *l;
  341. int id, nb;
  342. char *buf, *p;
  343. for (l = clist->selection; l != NULL; l = l->next)
  344. {
  345. id = *((int *) gtk_clist_get_row_data(clist, GPOINTER_TO_INT(l->data)));
  346. if ((gl_config->staff) ||
  347. (mysql_get_int(gl_config->mysql,
  348. "SELECT auteur FROM %s WHERE id=%d",
  349. table, id) == getuid()))
  350. valid = g_slist_prepend(valid, GINT_TO_POINTER(id));
  351. }
  352. nb = g_slist_length(valid);
  353. if (nb != 0)
  354. {
  355. p = buf = g_malloc(MYSQL_BUFFER_SIZE);
  356. p += g_snprintf(buf, MYSQL_BUFFER_SIZE,
  357. "UPDATE %s SET actif=0, nom=CONCAT('Z_', id, '_', nom) "
  358. "WHERE 0",
  359. table);
  360. for (sl = valid; sl != NULL; sl = sl->next)
  361. {
  362. id = GPOINTER_TO_INT(sl->data);
  363. p += g_snprintf(p, MYSQL_BUFFER_SIZE - (p - buf), " OR id=%d", id);
  364. }
  365. g_slist_free(valid);
  366. mysql_list_remove_confirm(buf, nb, refresh_callback);
  367. }
  368. }
  369. /*
  370. ** Modifier
  371. */
  372. static sql_add_item_t *mysql_adder_item_duplicate(const sql_add_item_t *foo)
  373. {
  374. sql_add_item_t *item;
  375. item = g_malloc(sizeof(*item));
  376. memcpy(item, foo, sizeof(*item));
  377. return item;
  378. }
  379. static void mysql_adder_item_set_value(sql_add_item_t *item,
  380. const char *table, int id)
  381. {
  382. char *s;
  383. int i;
  384. switch (item->type)
  385. {
  386. case sql_add_file:
  387. case sql_add_str:
  388. s = mysql_get_str(gl_config->mysql, "SELECT %s FROM %s WHERE id=%d",
  389. item->field, table, id);
  390. gtk_entry_set_text(GTK_ENTRY(item->widget), s);
  391. g_free(s);
  392. break;
  393. case sql_add_num:
  394. i = mysql_get_int(gl_config->mysql, "SELECT %s FROM %s WHERE id=%d",
  395. item->field, table, id);
  396. gtk_spin_button_set_value(GTK_SPIN_BUTTON(item->widget), i);
  397. break;
  398. case sql_add_flag:
  399. i = mysql_get_int(gl_config->mysql, "SELECT %s FROM %s WHERE id=%d",
  400. item->field, table, id);
  401. gtk_toggle_button_set_active(GTK_TOGGLE_BUTTON(item->widget), i);
  402. break;
  403. }
  404. }
  405. static void mysql_edit_commit(GtkWidget *wid, sql_add_t *adder)
  406. {
  407. char buf[MYSQL_BUFFER_SIZE];
  408. g_snprintf(buf, MYSQL_BUFFER_SIZE, " WHERE id=%d", adder->id);
  409. mysql_adder_do_commit(adder, "UPDATE ", buf);
  410. }
  411. static void mysql_edit_free(sql_add_t *adder)
  412. {
  413. g_slist_free(adder->items);
  414. g_free(adder);
  415. }
  416. static void mysql_edit_dialog(const char *title, const sql_add_t *adder,
  417. GtkSignalFunc refresh_callback,
  418. int id)
  419. {
  420. sql_add_t *res;
  421. GSList *l;
  422. GtkWidget *tbl;
  423. sql_add_item_t *item;
  424. int i;
  425. res = g_malloc(sizeof(*res));
  426. res->table = adder->table;
  427. res->id = id;
  428. res->callback = refresh_callback;
  429. res->items = NULL;
  430. /* Main box */
  431. tbl = gtk_table_new(3, g_slist_length(adder->items), FALSE);
  432. gtk_widget_show(tbl);
  433. res->widget = create_dialog(title, tbl, " Valider ", " Annuler ",
  434. mysql_edit_commit, res, destroy_widget);
  435. gtk_object_set_data_full(GTK_OBJECT(res->widget), "42", res,
  436. (GtkDestroyNotify) mysql_edit_free);
  437. gtk_widget_show(res->widget);
  438. /* Entrys */
  439. for (i = 0, l = adder->items; l != NULL; l = l->next, i++)
  440. {
  441. item = mysql_adder_item_duplicate(l->data);
  442. mysql_adder_item_create(item, tbl, i, mysql_edit_commit, res,
  443. destroy_widget, res->widget);
  444. mysql_adder_item_set_value(item, adder->table, id);
  445. res->items = g_slist_prepend(res->items, item);
  446. }
  447. }
  448. void mysql_list_edit(const char *title, const GtkCList *sel,
  449. const sql_add_t *adder,
  450. GtkSignalFunc refresh_callback)
  451. {
  452. const GList *l;
  453. int id;
  454. for (l = sel->selection; l != NULL; l = l->next)
  455. {
  456. id = *((int *) gtk_clist_get_row_data(GTK_CLIST(sel),
  457. GPOINTER_TO_INT(l->data)));
  458. if ((gl_config->staff) ||
  459. (getuid() == mysql_get_int(gl_config->mysql,
  460. "SELECT auteur FROM %s WHERE id=%d",
  461. adder->table, id)))
  462. {
  463. mysql_edit_dialog(title, adder, refresh_callback, id);
  464. }
  465. }
  466. }